SQL*Loader-951: Error calling once/load initialization

Troubleshooting

Problem

Error when publishing from Contributor 8.4 to an Oracle 9i database.

Symptom

In CAC:
2008-12-08T22:52:01.518+00:00
Machine details: <domain>\<server>
User details: <domain>\<userID>
Process ID / Thread ID: 7944 / 9792

Source: <SupplementalInfo><Source>EAdminORA8_84.ORA8.CheckOutputForErrors</Source><StackInfo><ErrorGuid>{72C0C115-D7F0-43D8-AC8F-0E562074ADE5}</ErrorGuid><StackPosition>9</StackPosition><PreviousUserDomain>Unknown user domain</PreviousUserDomain><PreviousUserName>Unknown user name</PreviousUserName><PreviousComputerDomain>domain</PreviousComputerDomain><PreviousComputerName>server</PreviousComputerName></StackInfo></SupplementalInfo>
Error Number: -2147220587
Line Number: 220
Description: Unable to get Job Item

The Job management step failed. An attempt has been made to mark the 'REPORTING_PUBLISH' Job as CANCELLED. Please rectify the problem and re-create a similar Job.

The call to 'JobBegin' on 'ReportingPublish_%v.Implementation' was not successful.

Unable to Bulk Load the data.

Error found in output.

SQL*Loader-951: Error calling once/load initialization

In Planningerrorlog.csv:
Unable to execute Job Item~~~~Unable to Bulk Load the data.~~~~Error found in output.~~~~SQL*Loader-951: Error calling once/load initialization

In Bulk Loader .out file:
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges

[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Historical Number

1042406

Was this topic helpful?

Document Information

More support for:
Cognos 8 Planning

Software version:
8.4

Operating system(s):
Windows

Document number:
620675

Modified date:
09 May 2025

UID

swg21375199

IBM Support

Tips