Symptom
- The SAP Enterprise Inventory and Service-Level Optimization (EIS) Analytics batch job J_SmartOps_DM_Load or J_SmartOps_DM_Load_Manual fails with the following error:
DBS-120417: |Data flow DF_Dim_Hist|Loader Key_Generation_DM_FACT_PERF_DIM_HISTORY
Oracle API bulk loader CONVERSION_ERROR: <ORA-1722:ORA-01722: invalid number: >
- Note: The name of the Data Flow (DF), e.g. DF_Dim_Hist, could differ in your environment but the solution is the same.
- Other DF names where this can occur are DF_F_Inven_History, DF_F_Perf_Trck, DF_F_Planned_vs_Actual, DF_F_Stocking_Point_Plan, DF_Perf_Alert_Agg, DF_F_Supply_Path
- You have also already applied SAP Note 2365666 if you are on SAP EIS Analytics 6.10.3.3 or 6.10.3.4
Read more...
Environment
- SAP Enterprise Inventory and Service-Level Optimization (EIS) Analytics 6.10 Support Pack 3 Patch 5 (6.10.3.5) or earlier
- SAP Business Objects Data Services
Product
SAP Enterprise Inventory and Service-Level Optimization Analytics all versions
Keywords
SmartOps, EIS, EIO, MIPO, AIM, 1722, 6.10.3.5, 6.10.3.4, 6.10.3.3, 6.10.3.2, 6.10.3.1 6.10.3, 6.10.2, 6.10.1 , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , 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.
SAP Knowledge Base Article - Preview