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

 

Error with Oracle Function call in model with Framework Manager 11.1.3

Started by Penny, 05 Sep 2019 03:13:45 PM

Previous topic - Next topic

Penny

We recently upgraded to 11.1.3 from 11.0.9.  We run Cognos in a Windows Server environment against an Oracle 12c datasource, with an Oracle 12c content store.  The upgrade worked beautifully and the majority of our reports migrated successfully.  All of our packages are using DQM.

A few select reports did not work in the new version, and I have narrowed it down to two specific calculated query items in the model.  In both cases the query item was calling an oracle function with several parameters where one or more parameters passed were null. I tried using '', instead of null and even tried using cast on the null with no effect.  When testing the query subject in the model using DQM, Framework Manager worked fine with no indication of a problem, however if a report references the query item with the function call (with null parameters) the report fails.  I updated the ojdbc.jar file to version 8 as per IBM to no avail.  Initially after the upgrade we thought that republishing the package would correct the problem (FM was also upgraded) but it did not.  I had an online meeting with IBM this morning to demonstrate the problem. 

We are using other oracle functions in the model that do not cause a problem in reports, but the others do not try to pass a null parameter.  All of the affected reports were working correctly in 11.0.9.

I mostly post this to warn anyone else about to move to this version, however if you have any ideas they would be welcome. 

Here is the error:  Found an internal error:
java.lang.NullPointerException

I will update this post when IBM has finished reviewing the problem.  At the moment they are trying to reproduce the error which I demonstrated for them.

the6campbells

In the <cogos>\logs\XQE folder you should see xqe log files

As you duplicate your issue, the NPE you referenced will be in the log with a more complete Java stack trace.

Did you provide that to IBM support. Can you paste an example.