SAP Knowledge Base Article - Preview

3378310 - Error while accessing a MSSQL table with unsupported datatype via SDA

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

SAP HANA, platform edition 2.0

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.