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 for Me (Login required).

Search for additional results

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