Cognos planning job is failed due to this error
" Failed HRESULT [0x80040267] :Unable to execute macro 'YER Planning Job' Unable to execute 'Publish - Control - Table Only Layout' The 'REPORTING_PUBLISH' Job is at state 'CANCELLED'. 2009-07-27T04:42:54.083+00:00 JobExecutor_83 Error Number: -2147417848 Line Number: 400 Description: Unable to execute Job Item Method '~' of object '~' failed Job Item GUID: {306A20ED-8E25-4E0F-8FF3-90E5D8457CA7}â€
After that
I have done the analysis but unable to find out what is the reason of failure, after sometime i have re-run the cognos planning job from failed step but its got successfully executed.
I would like to know that is the reason of failure.
Could you please any one help me out. thanks!
Hi Guys.
I would like to let you know that
reason of failure:-
Failed HRESULT [0x80042399] :Unable to execute macro '<Macroname>'
Unable to execute 'Publish - Table Only Layout'.
This does not support related objects.
Cause
No rights assigned to the macro's user ID to work with the publish container under 'Access Rights' in CAC.
Resolving the problem
Assign rights to work with the publish container to the user which executes the macro under 'Access Rights' Steps:1) In CAC, Select 'Access Rights' in the left-hand pane.
2) In the right-hand pane, select the group or role of which the macro user identity is a member
3) Filter access rights view by 'Table-only Publish Container' or 'View Publish Container' as applicable
4) Ensure that all check-boxes for the relevant container are selected
5) Click 'Save' to confirm the changes.
Regards
SKM