SAP Knowledge Base Article - Public

3251022 - com.sap.fpa.cloud.rest.hana.HanaDetailViewType.toString() of a null object loaded from local variable 'covertedViewType'

Symptom

Import data from HANA to SAC failed and following error can be seen from SAC agent trace:
java.lang.NullPointerException: while trying to invoke the method com.sap.fpa.cloud.rest.hana.HanaDetailViewType.toString() of a null object loaded from local variable 'covertedViewType'

Environment

SAP HANA Platform 1.0

SAP HANA Platform 2.0

Reproducing the Issue

1. Reproduce the issue and capture sqltrace. Following statement can be seen in sqltrace:

SELECT
  DISTINCT "COLUMN_OBJECT",
  "CATALOG_NAME",
  "CUBE_NAME",
  "DESCRIPTION",
  "VIEW_TYPE" 
FROM "_SYS_BI"."BIMC_ALL_AUTHORIZED_CUBES" BIMC_CUBES 
LEFT OUTER JOIN "SYS"."VIEWS" VIEWS_INFO ON (BIMC_CUBES."VIEW_NAME" = VIEWS_INFO."VIEW_NAME") 
ORDER BY "CATALOG_NAME" ASC,
  "CUBE_NAME" ASC"

2. One of the above statement records shows VIEW_TYPE other than CALC, for example, ROW as VIEW_TYPE. The VIEW_TYPE value can be retrieved from either sqltrace generated earlier, or by executing the statement directly on DB level.

Cause

The expected VIEW_TYPE is CALC.

Resolution

Check with the view owner to change VIEW_TYPE to CALC or drop the view if it's not needed.

Keywords

com.sap.fpa.cloud.rest.hana.HanaDetailViewType.toString(), covertedViewType , KBA , HAN-DB , SAP HANA Database , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0