Symptom
- During migration process of BW environment to ASE, some F fact tables are returning the following error on import_monitor.log file :
INFO: 2015-01-24 19:41:49 com.sap.inst.migmon.LoadTask run_report
Monitor jobs: running 2, waiting 24, completed 127, failed 1, total 154 error processing of package SAPDFACT_xx
ERROR: 2015-01-24 19:41:49 com.sap.inst.migmon.LoadTask run
Loading of 'SAPDFACT_xx' import package is interrupted with R3load error.
Process '<SAPinstallPath>\R3load.exe -i SAPDFACT_xx.cmd -dbcodepage 4103 -k 179geEM50D801eqteAYt1Aq2 -l SAPDFACT_xx.log -c 99000000 -loadprocedure fast -merge_bck' exited with return code 2.
For mode details see 'SAPDFACT_xx.log' file.
Standard error output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
- In the SAPDFACT_xx.log the SQL4851 error returned :
(DB) INFO: /<namespace>/<tablename> created
(SYB_IMP) ERROR: DbSlEndModify failed
rc = 99, table "/<namespace>/<tablename>"
(SQL error 3621)
error message returned by DbSl:
[ASE Error SQL4851][SAP][ASE ODBC Driver][Adaptive Server Enterprise]BULK COPY IN failed. One or more rows do not belong to any partition of table '/<namespace>/<tablename>'.
[ASE Error SQL4851][SAP][ASE ODBC Driver][Adaptive Server Enterprise]BULK COPY IN failed. One or more rows do not belong to any partition of table '/<namespace>/<tablename>'.
[ASE Error SQL3621][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Command has been aborted.
(IMP) ERROR: EndFastload: rc = 2
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~0" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~01" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~02" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~04" is not created.
....
....
....
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~11" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~12" is not created.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Business Wharehouse (SAP BW)
- SAP Solution Manager (SOLMAN) - All versions
Product
Keywords
SAP ASE BW, migration, SQL4851, BULK COPY, partition , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.