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