Hi all,
We are installing EHP5 stack 4 on a system (SAP ERP 6.0, MSSQL 2008R2) and we have reached stage Preprocessing. We are currently stuck at phase MAIN_SHDCRE/DBCLONE and find an error in step DBCLONE.ELG, there being no space problems. Some of you could help us?
DBCLONE.ELG:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.T04
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN /OSP/T_RAUI_DEL
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN /OSP/T_SQ_REPORT
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN AGR_NUM_2
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN ALTEXTSCHEMA
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN AQLTQ
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN BADIIMPL_MENU
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN BCST_ASSIGNMENT
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN BSAUTHORS
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN BSPTEMPXSRFSTORE
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN CNTLSTREAM
1EETGCLN
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN DB2CCACCOX
DBCLONE01.T04:
4 EPU201XBEGIN OF SECTION BEING ANALYZED IN PHASE DBCLONE
3 ETGCLN ***********(221259)***********
8 ETGCLN START CLONING TABLES
3 ETGCLN Cannot read C:\EHPI\abap\mem\TAIATRANS.DAT
3 ETGCLN START /OSP/T_RAUI_DEL -> /OSP/T_RAUI_DEL~
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE [/OSP/T_RAUI_DEL~];
3 ETGCLN CREATE TABLE [/OSP/T_RAUI_DEL~] ( [MANDT] nvarchar(000003) NOT NULL , [CAT_ID] nvarchar(000004) NOT NULL , [REPORT] nvarchar(000040) NOT NULL , [RFCDEST] nvarchar(000032) NOT NULL , [RP_DEL_TYP] nvarchar(000050) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE );
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'MSS' AND TABNAME = '/OSP/T_RAUI_DEL~' AND INDEXNAME = ' ';
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '000', '/OSP/T_RAUI_DEL~', 'MANDT' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_RAUI_DEL~', 'CAT_ID' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_RAUI_DEL~', 'REPORT' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_RAUI_DEL~', 'RFCDEST' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_RAUI_DEL~', 'RP_DEL_TYP' ');
3 ETGCLN ALTER TABLE [/OSP/T_RAUI_DEL~] ADD CONSTRAINT [/OSP/T_RAUI_DEL^0] PRIMARY KEY CLUSTERED ( [MANDT] , [CAT_ID] , [REPORT] , [RFCDEST] , [RP_DEL_TYP] ) ON [PRIMARY];
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'MSS' AND TABNAME = '/OSP/T_RAUI_DEL~' AND INDEXNAME = '0';
3 ETGCLN /OSP/T_RAUI_DEL : only client 000 will be copied
3 ETGCLN insert into [/OSP/T_RAUI_DEL~] ( [MANDT], [CAT_ID], [REPORT], [RFCDEST], [RP_DEL_TYP] ) select [MANDT], [CAT_ID], [REPORT], [RFCDEST], [RP_DEL_TYP] from [/OSP/T_RAUI_DEL] WHERE [MANDT]='000'
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN /OSP/T_RAUI_DEL
1EETGCLN
3 ETGCLN START /OSP/T_SQ_REPORT -> /OSP/T_SQ_REPORT~
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE [/OSP/T_SQ_REPORT~];
3 ETGCLN CREATE TABLE [/OSP/T_SQ_REPORT~] ( [MANDT] nvarchar(000003) NOT NULL , [SQ_REPORT] nvarchar(000040) NOT NULL , [WORKSPACE] nvarchar(000001) NOT NULL , [OLD_USERGROUP] nvarchar(000012) NOT NULL , [OLD_QUERY] nvarchar(000014) NOT NULL , [SQ_CHDATE] nvarchar(000008) NOT NULL , [SQ_CHTIME] nvarchar(000006) NOT NULL , [IS_CHDATE] nvarchar(000008) NOT NULL , [IS_CHTIME] nvarchar(000006) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE );
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'MSS' AND TABNAME = '/OSP/T_SQ_REPORT~' AND INDEXNAME = ' ';
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '000', '/OSP/T_SQ_REPORT~', 'MANDT' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_SQ_REPORT~', 'SQ_REPORT' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_SQ_REPORT~', 'WORKSPACE' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_SQ_REPORT~', 'OLD_USERGROUP' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind ' ', '/OSP/T_SQ_REPORT~', 'OLD_QUERY' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '00000000', '/OSP/T_SQ_REPORT~', 'SQ_CHDATE' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '000000', '/OSP/T_SQ_REPORT~', 'SQ_CHTIME' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '00000000', '/OSP/T_SQ_REPORT~', 'IS_CHDATE' ');
3 ETGCLN INSERT INTO @XSQL VALUES (' sap_atomic_defaultbind '000000', '/OSP/T_SQ_REPORT~', 'IS_CHTIME' ');
3 ETGCLN ALTER TABLE [/OSP/T_SQ_REPORT~] ADD CONSTRAINT [/OSP/T_SQ_REPORT^0] PRIMARY KEY CLUSTERED ( [MANDT] , [SQ_REPORT] ) ON [PRIMARY];
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'MSS' AND TABNAME = '/OSP/T_SQ_REPORT~' AND INDEXNAME = '0';
3 ETGCLN /OSP/T_SQ_REPORT : only client 000 will be copied
3 ETGCLN insert into [/OSP/T_SQ_REPORT~] ( [MANDT], [SQ_REPORT], [WORKSPACE], [OLD_USERGROUP], [OLD_QUERY], [SQ_CHDATE], [SQ_CHTIME], [IS_CHDATE], [IS_CHTIME] ) select [MANDT], [SQ_REPORT], [WORKSPACE], [OLD_USERGROUP], [OLD_QUERY], [SQ_CHDATE], [SQ_CHTIME], [IS_CHDATE], [IS_CHTIME] from [/OSP/T_SQ_REPORT] WHERE [MANDT]='000'
1EETGCLN [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'DDPRH~0'. Cannot insert duplicate key in object 't04.DDPRH'.
1EETGCLN /OSP/T_SQ_REPORT