Symptom
When accessing a Virtual Table (VT) including an unsupported datatype (DATETIMEOFFSET MSSQL) using Smart Data Access (SDA) the following error occurred and can't use Tables/View with Columns Datatype DATETIMEOFFSET.
Error:
com.sap.hana.di.virtualtable: Could not create the virtual table in the database [8254003]
at "src/virtualtable/RS_DB_PUBCashflowsLatest.hdbvirtualtable" (0:0)
Error:
com.sap.hana.di.virtualtable: Database error 7: : feature not supported: Unsupported datatype for column BSM_ResultDb_DEV.dbo.PUB_Cashflows_Latest.DataQueriedAt [8201003]
at "src/virtualtable/RS_DB_PUBCashflowsLatest.hdbvirtualtable" (0:0)
Read more...
Environment
SAP HANA Database
Product
Keywords
SDA, Smart Data Access, MSSQL, remote, table, remote tables, remote table, tables, DATETIMEOFFSET, Could not create the virtual table in the database, Database error 7, Unsupported datatype for column, feature not supported, error 7, Unsupported datatype, Unsupported, datatype , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview