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

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'

SAP HANA Platform 1.0

SAP HANA Platform 2.0

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.

The expected VIEW_TYPE is CALC.

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

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