If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos Planning Publish Fails after Upgrade of Oracle Client to 12c SOLVED

Started by Danno, 16 Jul 2015 09:40:31 AM

Previous topic - Next topic

Danno

We upgraded the Oracle client on all servers from 11g to 12c. Initially when we were investigating this the IBM had Oracle 12c listed as supported. When I checked again yesterday I see it is not listed there. Good thing I downloaded all this in PDF format otherwise I would have thought I screwed up but I do see the difference in the supported software matrix between April and July. So I have done that homework.

Now the issue is that everything works for Cognos except the publishes. There doesn't seem to be a .out file produced although the log shows one being created as part of the bulk load error. Also we did a full Admin install of the client on the Cognos servers. This is DEV so I want to resolve this before we move forward to the other environments.

Here is the error:

2015-07-16T14:21:04.188+00:00

Machine details: WMIC\WPG1DBPF002

User details: WMIC\cogplan10

Process ID / Thread ID: 1848 / 3996

Source: BulkLoadHelper_10.BulkLoadHelper.BulkLoadExec
ErrorGuid: {2425E988-DE13-48E6-B5DC-3349D03149B9}
StackPosition: 8
PreviousUserDomain: WMIC
PreviousUserName: cogplan10
PreviousComputerDomain: WMIC
PreviousComputerName: WPG1DBPF002
Error Number: -2147220450
Line Number: 280
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.

BulkLoad Execution returned -1073741515.
Output file (C:\Users\COGPLA~1\AppData\Local\Temp\9D604F8DC61E45B18ACF3B52B110A2A7et_AG_FX{E717124D-F3D8-4A62-AD0F-17E8313E75FF}.out):


Any ideas on how to proceed? I'm not getting many hits on the web for this one and the DBA's seem stumped.

Thanks

Danno

It was a confirmed bug with Oracle:

Bug:19787643 - SQL LOADER FAILS TO START - ORANFSODM12.DLL IS MISSING"

They had to supply us with the correct DLL so that we could continue with using Oracle 12c and after installing it the publishes executed as expected.