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.
SAP Knowledge Base Article - Preview