SAP Knowledge Base Article - Preview

2125141 - Error SQL4851 returned during import of F table - BW on SAP ASE

Symptom

  • You are migrating your BW environment to ASE and some F fact tables are returning the following error during migration process 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 you have 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) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Business Wharehouse (SAP BW)
  • SAP Solution Manager (SOLMAN) - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions ; SAP Solution Manager all versions

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.