Reconcile getting fail

Legacy Cognos Products Cognos 8 Planning
1

Hi all,
Reconcile is getting fail with following errors.

2011-12-07T16:29:54.850+00:00

Machine details: KV\GORDIAS

User details: KV\s_cog_gordias

Process ID / Thread ID: 5704 / 4516

Source: OraOLEDB{409D9519-56B8-4D05-8CB4-7867EF224277}4KVs_cog_gordiasKVGORDIAS
Error Number: -2147217845
Line Number: 390
Description: Unable to execute Job Item

Accessor is not a parameter accessor.

Job Item GUID: {8624D58A-E0C3-46E4-9B43-17F8F58BBCF7}

Any one have any idea ??

THANKS,
Manoj

2

Looks like a Oracle database issue to me.
let the Oracle DBA monitor the database when you perform a reconsile.

3

DBA has checked many time, but no error or less table space. :’(

4

does it occur with every reconsile on every planning database? Or just on 1 planning database?

If it is only one planning database try to export the content and restore it in a newly created database. When it fails a corruption might be exported/imported. Then create a new database and rebuild it step by step with analyst queries, piece by piece to see where it fails.

5

HI GURU,

I followed the steps now again reconcile getting fail with following error.
2011-12-15T11:51:00.900+00:00

Machine details: KV\GORDIAS

User details: KV\s_cog_gordias

Process ID / Thread ID: 6048 / 4672

Source: Reconcile_85.Implementation.Execute{253002DB-B730-4806-8931-EB7C58BF3183}1KVs_cog_gordiasKVGORDIAS
Error Number: 7
Line Number: 390
Description: Unable to execute Job Item

Unable to write data for e.List item {D39A40AE-9F9E-4D06-AB0D-309CEB1B2B6A} (9710 Johto) using ‘epRT_%v.AdminServer.WriteReconciledData’

Failed HRESULT [0x8007000E]: Not enough storage is available to complete this operation.

Job Item GUID: {74E658A0-373F-4813-99A2-6591C5D4EE79}

6

Hi Manjo,

Looks like not enough disk space to perform the reconsile action

Failed HRESULT [0x8007000E]: Not enough storage is available to complete this operation
I'm not sure if it is the database server or the Cognos Planning server which has not enough diskspace... ::) my educated guess is the database server, sinced reconsile is mainly a database action..
7

HI,
Can you please explain me what do you mean by planning server and DB diskspace??
In planning server we have 24 GB RAM and in DE we have 50 GB free table space for this application.

Now am getting different error, PFA

8

i found this:

The error indicates that there isn´t enough memory available to complete the job item. When the job item starts, a specified amount of memory is requested and that memory needs to be contiguous (memory fragmentation is a common cause of this error), so the larger the node, the more memory is needed and the harder it may become to obtain a large contiguous memory space. A reboot commonly fixes the problem as it clears out your memory fragmentation.