SAP Knowledge Base Article - Preview

2921205 - ORA-01722 error when using calculated views - Data Services


  • A job using an Oracle calcuated view suddenly fails with the following error:
    Error "<ORA-01722: invalid number>. The SQL submitted is SELECT " " FROM "database"."Table""
  • Same error is seen when viewing data in the datastore connection.
  • When the calculated view is refreshed on the Database side, the error is resolved for a short time only.



SAP Data Services 14.x


SAP Data Services 4.2


KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.