Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EHP 5 Upgrade

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

Not what you were looking for? View more on this topic or Ask a question