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!