SAP Knowledge Base Article - Preview

2170441 - Query on SDA object fails with Error "ORA-00972: identifier is too long"


You are querying a virtual table from an SDA remote database object from and you run into one of the following errors:

  • SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database
    [Oracle][ODBC][Ora]ORA-00972: identifier is too long for query" 
  • odbcaccess.cpp(03824) : ODBC error: connected: 1 state: 42000 code: 972 [Oracle][ODBC][Ora]ORA-00972: identifier is too long



SAP HANA, platform edition


SAP HANA, platform edition all versions


SDA, oracle, smart data access, accessing, schema, name, naming, error, ora, 00972, Smart Data Access , 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.