Symptom
- 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.
Read more...
Environment
SAP Data Services 14.x
Product
SAP Data Services 4.2
Keywords
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.