AnsweredAssumed Answered

Specific columns from HANA View not getting displayed in NSQL Grid Portlet

Question asked by Georgy N Joseph on Feb 24, 2017
Latest reply on Mar 1, 2017 by Georgy N Joseph

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

Outcomes