on 10-08-2008 9:01 AM
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,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.