- Customer has created an Oracle sequence and uses a custom SQL() function to gather the next sequence.
- During run time the job fails with the following error:
Error "An integer's range is <-2147483648> to <2147483647>. You are attempting to store value <4100000000>, outside of this range. To successfully store it, you must change the field's data type."
- Changing data type that holds the SQL() function result, fails with the following error.
Error " <OCIStmtExecute>: <ORA-01400: cannot insert NULL into <Number column>"
- The value in question appears to be within the specified range.
SAP Data Services
SAP Data Services all versions
KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem
About this pageThis 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.