cancel
Showing results for 
Search instead for 
Did you mean: 

Problem during mssql 2005 system copy

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

Our system only has the ECC 6.0 component installed with AS ABAP +AS JAVA over Netweaver 7.0.

We have added the BI_CONT add-on to match the source system characteristics.

We have followed the note you mention and the Note 888210: NetWeaver 7.0/7.10: System copy (supplementary note).

We didn't make the export but the team on the source system executed the DDL generation report and we included the DFACT.SQL file in the export folder under ABAP/DB/MSS.

Regards

Former Member
0 Kudos

Are you read Note 962124 - Syntax error during migration to SQL Server 2005 ?

Regards.

Former Member
0 Kudos

Yes, we have followed this note and we have upgrade the system to the Netweaver 7.0 SP16

Former Member
0 Kudos

Are you "have upgrade the system to the Netweaver 7.0 SP16" source system(not target) befor export and running SMIGR_CREATE_DDL report ?

If yes, and you have same error you need to open OSS call to SAP.

Regards.

Former Member
0 Kudos

No, we have only upgrade the target system, so we have a higher level of patches in the target system than in the source system.

Is this a problem??? Do you know any note or documentation regrading this???

Former Member
0 Kudos

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.