Cognos Planning 8.4 - Automated Reporting Publish Job Error

[vishnuvarthan]

Hello,

We are having Issue with Cognos Planning Publish Jobs. We have batch scripts to automate the Publish Jobs. We get the following error, when we do auto Publish. We use 4 job servers to share the load inside planning contributor admin. When I manually publish my application, sometimes it gets published and some times it throws the below error. It always fails during the Automated publish. Please help us out on this Issue!

Error Description from Job Management:



Process ID / Thread ID: 1496 / 2936

Source: <SupplementalInfo><Source>ACE2_84.DCubeExport</Source><StackInfo><ErrorGuid>{3DD38B7D-EF2A-445C-830A-00EA70BA142E}</ErrorGuid><StackPosition>3</StackPosition><PreviousUserDomain>domain name</PreviousUserDomain><PreviousUserName>cogsvr</PreviousUserName><PreviousComputerDomain>domain</PreviousComputerDomain><PreviousComputerName>servername</PreviousComputerName></StackInfo></SupplementalInfo>
Error Number: -2147352567
Line Number: 390
Description: Unable to execute Job Item

Error executing J expression : 'ACE2_rc ACE2_xids ' =: 230 ExportToFile2_IDCubeExport_ FileName;ColumnItemGuids;<ColumnDataTypes


Job Item GUID: {89737BDD-7DDB-4EF7-AF61-11728262DDF6}


Error Message from planningerrorlog.csv file:

domain\server name   1356   5368
{597BF796-C1DC-4B17-84E0-6921BF02A670}   3   2014-09-03 13:47:58.185 UTC -300   epPlanningService   8.4.2531.0   default   MacroExecManager.cpp   ExecuteMacro   42   epPlanningService::default::ThreadSystemMacro.cpp::ExecuteMacro::391   -2147220889   Failed HRESULT [0x80040267] :Unable to execute macro 'Publish SGM'~~~~Unable to execute macro step 'Publish - Table Only Layout'~~~~The 'REPORTING_PUBLISH' Job is at state 'CANCELLED'.~~~~The reason for failure is unknown   domain\cogsvr   domain\server name   domain\cogsvr   domain\server name   1356   5368
{597BF796-C1DC-4B17-84E0-6921BF02A670}   4   2014-09-03 13:47:58.310 UTC -300   epPlanningService   8.4.2531.0   default   MacroExecManager.cpp   ExecuteMacro   44   epPlanningService::default::ThreadSystemMacro.cpp::ExecuteMacro::391   -2147220889   Failed HRESULT [0x80040267] :Unable to execute macro 'Publish SGM'~~~~Unable to execute macro step 'Publish - Table Only Layout'~~~~The 'REPORTING_PUBLISH' Job is at state 'CANCELLED'.~~~~The reason for failure is unknown   domain\cogsvr   domain\server name   domain\cogsvr   domain\server name   1356   5368


Error Message from jce18.temp file (this file gets created everytime when the publish job fails):

ERRORTXT 1676 á      w     w  **** Error report from JCE ****
JCE Version:
   8.4.2505.0
Timestamp:
   2014 9 2 20 10 1.232
Error message:
   out of memory: GetProjectionTraversalSpec_array_
      ResolveProjectionToTraversalSpec projrank;projshape;(ForceToInteger;    ,each projinx);(ForceToInteger;projdims);dimsperaxis;rank;arrayshape;<<addressoflongnoun'spec'
   GetProjectionTraversalSpec_array_[:8]
Last cd error (cder): 0 0

Exceptions:
   0 E Error: out of memory: GetProjectionTraversalSpec_array_[8] 2014 9 2 20 10 1.264
Stack:
   GetProjectionTraversalSpec_array_[8]   ResolveProjectionToTraversalSpec projrank ; projshape ; (ForceToInteger ; , each projinx) ; (ForceToInteger ; projdims) ; dimsperaxis ; rank ; arrayshape ; < < addressoflongnoun 'spec'
   ResolveTraversalSpecs[31]              traversalspec=.ShapeExtended GetProjectionTraversalSpec_array_ projdims ; < projinx
   gettraversalspec[2]                    ResolveTraversalSpecs ''
   Get[19]                                end.
   Get[0]                                 (0$0)Get y
   u_IArrayRead_GetAll__arrayloc[0]       [: Get (; ;&0)
   u_IArrayReadGet[2]                     hObj ('u_IArrayRead_Get' , m , '__arrayloc')~ y
   IArrayRead_GetAll_964_[0]              if. IsValid do.
   invoke[5]                              if. ('AllowInterface' , loc)~ m do.
   GetAll_IArrayRead_[0]                  :
   ReadTable[76]                          values=.checkrx hds GetAll_IArrayRead_ array_attrib
   IDCubeExport_ExportToFile2_269_[2]     string=.checkrx ReadTable 'TAB' ; fileName ; columnItemGuids ; columnDataTypes
   invoke[5]                              if. ('AllowInterface' , loc)~ m do.
   ExportToFile2_IDCubeExport_[0]         :


Error description from Macro section:

Machine details: domain\server name

User details: domain\cogsvr

Process ID / Thread ID: 1356 / 272

Unable to execute macro step 'Publish - Table Only Layout'.

Unable to execute macro 'Publish SGM'

Unable to execute macro step 'Publish - Table Only Layout'

The 'REPORTING_PUBLISH' Job is at state 'CANCELLED'.

The reason for failure is unknown

See the log file for further details.


Please help us out in this Issue. Thanks!