Clarity

Hi Friends,

We are trying to remove some external data which we currently store in our CA PPM Database by accessing the same residing in SAP HANA views using NSQL Grid portlets, as and when needed, made possible by the database link we created from our Oracle PPM DB to the SAP HANA DB. 

We were successful in displaying the column data from SAP Hana Views inside this NSQL Grid portlet but not for all the columns in that HANA view. It works only for a subset of columns. We have confirmed that in the HANA view which we are trying to display inside the Grid portlet  all measures are with decimal data type and attributes in NVARCHAR. But still, for a random set of columns, when we add them to the @SELECT clause inside NSQL  (NSQL validates fine) and try to display them on the grid portlet, we get the general GUI error as below on clicking the FILTER button on the portlet.

"Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."

When we look at the PPM logs, we always get the below lines in the app-ca log files:-

ERROR 2017-02-20 09:44:29,186 [http-bio-***.XX.***.***-443-exec-781] dal.NSQLClient (clarity:XXXXXXXX:482XXXXX__660CXXXX-77XX-40XX-9CXX-78A2681XXXX:npt.gridFilter)

Unable to retrieve NSQL cube. NSQLException was thrown. com.niku.union.persistence.nsql.NSQLException: com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [qctchr : bfl], [10], [3], [2], [871], [1], [0], [], [], [], [], []
…………………......
Caused by: com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [qctchr : bfl], [10], [3], [2], [871], [1], [0], [], [], [], [], []
…………………........
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [qctchr : bfl], [10], [3], [2], [871], [1], [0], [], [], [], [], []

This is so strange because it works perfectly for almost half the columns in that HANA view but not for the other half 

Has anyone tried something like this before? Any troubleshooting ideas? Please help.

CA PPM Full Version : 14.2.0.237 04 21
Oracle Database Version: 11.2.0.4.0
Application Server OS: Windows Server 2008 R2 Datacenter
Database Server OS: Windows Server 2008 R2 Datacenter

Regards,

Georgy

Hi Georgy,

It says here that ORA-600 should be reported to the Oracle Technical Support for them to troubleshoot: ORA-00600 - Oracle FAQ; ORA-00600: internal error code, arguments string string string string string string string tips 

Do let us know how it goes with them.. Seems to be an interesting thing that is happening here

Hi Jeevan,

Thanks a lot. Yea, we had raised a support case with Oracle too and is following up with them in parallel. Good news is that they are responding fast and giving us some more parameters to set in the Oracle Gateway Init file. We are trying the same one-by-one and hoping to hit the right target soon. Will keep you all posted.

Regards,

Georgy

Don't know anything about HANA datatypes, but could you try creating an Oracle view instead and access that from the NSQL. (just GUESSING obviously).

i.e. instead of the NSQL trying to directly access the HANA data via the DB link, the Oracle view does that and all the NSQL does is reference the view - this might help you track down where the problem is (whether it really is a problem with the NSQL or with the data-trasnfer via the DB-link - if you get the same "missing data" in the view then you have purely a Oracle/HANA problem and have removed Clarity/PPM from the problem).

Hi Dave, 

Thanks a lot for the suggestion. Tried this now and we get the same issue. So now we are almost sure that the problem is outside CA PPM. We are still tuning the oracle heterogeneous gateway init file along with the Oracle Support team as we don't want to store those data in a View/MaterializedView inside CA PPM anyway.

Regards,

Georgy

Ahh good - definitely not a PPM problem then ; good luck!

Hi Friends,

Thanks a lot for all the suggestions here.

Finally we got the correct HS Init parameters to set in the Oracle Heterogeneous Gateway Init file and once these two were added to the Init file, the troublesome columns started appearing inside CA PPM Grid Portlet 

HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_NLS_NCHAR=UCS2

Have to say that the Oracle Support person was really prompt and interested in solving this issue for us, even by trial and error method.

Regards,

Georgy