1900538 - Error: "ORA-00904: "TABLENAME"."COLUMN_NAME": invalid identifier - Data Services | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1900538 - Error: "ORA-00904: "TABLENAME"."COLUMN_NAME": invalid identifier - Data Services

Symptom

  • After upgrade from Data Services 3.x or earlier to Data Services 4.x or later, Oracle statements are failing on jobs that were previously working fine.
  • Error:  "SQL submitted to Oracle Server <oracle_server> resulted in error <ORA-00904: "TABLENAME"."COLUMN_NAME": invalid identifier>. The SQL submitted is <sql statement>."
  • Can no longer run jobs successfully after upgrading repositories using Repository Manager to 4.x versions from 3.x or 11.x versions.
  • Upgrade using Repository Manager or repoman ran successfully with no errors.

Read more...

Environment

  • SAP Data Services
  • AIX
  • Oracle

Product

SAP Data Services all versions

Keywords

BODS, DSXI, lower case, upper case, Oracle, ORA 00904, invalid identifier , KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.