Skip to Content
avatar image
Former Member

Problem during mssql 2005 system copy

Hi,

We are migarting an ECC 6.0 system with Windows and Oracle database to a system with Windows and MS SQL server 2005 database.

We start the system migration but it stops in Import Abap step with an error in importing the SAPDFACT monitor. The error in the log is:

********************************************************************************************************

(DB) ERROR: DDL statement failed

( """""ALTER PARTITION SCHEME /BI0/F0CM_C03_PSCH0 NEXT USED [] )

DbSlExecute: rc = 99

(SQL error 102)

error message returned by DbSl:

Unclosed quotation mark after the character string '""ALTER PARTITION SCHEME /BI0/F0CM_C03_PSCH0 NEXT USED [] '.

Incorrect syntax near '""ALTER PARTITION SCHEME /BI0/F0CM_C03_PSCH0 NEXT USED [] '.

(DB) ERROR: DDL statement failed

(INSERT INTO @XSQL VALUES (' sp_recompile [/BI0/F0CM_C03]'))

DbSlExecute: rc = 99

(SQL error 15165)

error message returned by DbSl:

Could not find object '/BI0/F0CM_C03' or you do not have permission.

Interface access functions from dynamic library dbmssslib.dll loaded.

(IMP) INFO: InitFastLoad failed with <2: This is not an error and can be ignored:[208] Invalid object name 'd04./BI0/F0CM_C03'.>

(IMP) INFO: DBSL will be used

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 103, table "/BI0/F0CM_C03"

(SQL error 208)

error message returned by DbSl:

Invalid object name '/BI0/F0CM_C03'.

Statement(s) could not be prepared.

(DB) ERROR: DDL statement failed

( CREATE CLUSTERED INDEX [/BI0/F0CM_C03~010] ON [/BI0/F0CM_C03] ( [KEY_0CM_C03P] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~020] ON [/BI0/F0CM_C03] ( [KEY_0CM_C03T] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~030] ON [/BI0/F0CM_C03] ( [KEY_0CM_C03U] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~040] ON [/BI0/F0CM_C03] ( [KEY_0CM_C031] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~050] ON [/BI0/F0CM_C03] ( [KEY_0CM_C032] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~060] ON [/BI0/F0CM_C03] ( [KEY_0CM_C033] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

(DB) ERROR: DDL statement failed

( CREATE INDEX [/BI0/F0CM_C03~070] ON [/BI0/F0CM_C03] ( [KEY_0CM_C034] ) )

DbSlExecute: rc = 99

(SQL error 1088)

error message returned by DbSl:

Cannot find the object "/BI0/F0CM_C03" because it does not exist or you do not have permissions.

*************************************************************************************************************************

And the same error occurs in some other tables of the SAPDFACT monitor.

Does anyone have an idea of how to solve this?? It's very important because we have people stuck waiting for the migration.

Thanks!!

Best Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 08, 2008 at 10:08 AM

    Are your system is BW? Are you do befor export SMIGR_CREATE_DDL report?

    Note 771209 - NetWeaver 04: System copy (supplementary note)

    Try to read Note 942540 - System copy fails on SAPDFACT import

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Please read the Note 960504 (the 962124 note send you to read this note) -->

      "Do also apply note 962124 in your source system to be able to create correct partition schemes in your DFACT.SQL file" . Regards.