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>~05" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~06" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~07" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~08" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~09" is not created.
(DB) ERROR: failed to load table "/<namespace>/<tablename>", index "/<namespace>/<tablename>~10" 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 Sybase ASE Database Platform , Problem

About this page

This 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.