ASE 16 - BULK COPY IN failed during import

[former_member117942]

Hi all,

we are moving our BW 7.40 from Oracle to Sybase ASE 16.

Export was executed succesfully; now during import the SAPDFACT_2 (and other processes) terminates with the following message.

(GSI) INFO: vname    = "SYBASE                          "

(GSI) INFO: hostname = "HOST1BWD"                                                     "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "HOST1BWD"

(GSI) INFO: release  = "6.3"

(GSI) INFO: version  = "9600 "

(GSI) INFO: machine  = "4x AMD64 Level 6 (Mod 37 Step 1)"

(RDI) WARNING: O:\EXPORT_BWD\ABAP\DATA\SAPDFACT_2.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: O:\EXPORT_BWD\ABAP\DATA\SAPDFACT_2.STR: unknown file format, assuming version 2

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file O:\EXPORT_BWD\ABAP\DB/SQLFiles.LST

(SQL) INFO: found O:\EXPORT_BWD\ABAP\DB/SQLFiles.LST

(SQL) INFO: Trying to open O:\EXPORT_BWD\ABAP\DB/SQLFiles.LST

(SQL) INFO: O:\EXPORT_BWD\ABAP\DB/SQLFiles.LST opened

(SQL) INFO: Searching for SQL file DFACT.SQL

(SQL) INFO: DFACT.SQL not found

(SQL) INFO: Searching for SQL file O:\EXPORT_BWD\ABAP\DB/SYB/DFACT.SQL

(SQL) INFO: found O:\EXPORT_BWD\ABAP\DB/SYB/DFACT.SQL

(SQL) INFO: Trying to open O:\EXPORT_BWD\ABAP\DB/SYB/DFACT.SQL

(SQL) INFO: O:\EXPORT_BWD\ABAP\DB/SYB/DFACT.SQL opened

(DB) INFO: /BI0/F0TCT_C01 created

(SYB_IMP) ERROR: DbSlEndModify failed

  rc = 99, table "/BI0/F0TCT_C01"

  (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 '/BI0/F0TCT_C01'.

[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 '/BI0/F0TCT_C01'.

[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 "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~0" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~010" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~020" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~040" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~050" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~060" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~070" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~080" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~090" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~100" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~110" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~120" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~130" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~140" is not created.

(DB) ERROR: failed to load table "/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~150" is not created.

Looking for SAP notes or SDN discussions without success.

Any idea?

Regards.

[former_member188883 · Accepted solution]

Hi Maurizio,

Did you happen to execute report SMIGR_CREATE_DDL report before exporting database.

This report will create relevant SQL files for FACT and ODS tables

Secondly from the error

(RDI) WARNING: O:\EXPORT_BWD\ABAP\DATA\SAPDFACT_2.STR: cannot find version token "ver:" at line 1
(RDI) WARNING: O:\EXPORT_BWD\ABAP\DATA\SAPDFACT_2.STR: unknown file format, assuming version 2
(SQL) INFO: Searching for SQL file SQLFiles.LST

Looks likes some issue with export files. please re-copy the files one more time and check the results or you may need to perform the export again.

Regards,

Deepak Kori

[former_member117942 · Accepted solution]

Installed SAP note 1821924 (SYB: SAP BW 7.40 Correction Collection) on Oracle source system and performed the export again.

Now the problem is solved.

Regards.

[janos_czettler]

Hi!

I have faced with same issue on a BW (NW731) with ASE16.

I found this note: 2125141 - Error SQL4851 returned during import of F table - BW on SAP ASE.

This explains exactly the error.

Regards,

Janos

[Former Member]

could you please check

your dfact table in export location

this index not locate in file or it doesnt create succesfully,(/BI0/F0TCT_C01", index "/BI0/F0TCT_C01~0" is not created.)

copy your dfact.sql file and repair manually.