Severe error(s) occured during phase MAIN_TRANSEXEC/SQLDB_D1GENIN_TRNS of SUM Tool

[Former Member]

Dear Experts,

We encountered this error during EHP upgrade from EHP3 to EHP6.

Severe error(s) occured during phase MAIN_TRANSEXEC/SQLDB_D1GENIN_TRNS

Emergency, waiting for help..

1.  SQLSTMTSTD.OUT

     ===============

EXECUTING E:\usr\sap\EI6\SUM\abap\bin\SAPuptool.EXE execdb ..\var\SQLDBSCRIPT.TQL

Logging to 'E:\usr\sap\EI6\SUM\abap\log\SQLDBSCRIPT.OUT'

FATAL ERROR: DBSL error 26 (db code 2627):

Violation of PRIMARY KEY constraint 'D1GEN~0'. Cannot insert duplicate key in object 'ei6.D1GEN'. The duplicate key value is (UPGRADE).

SAPup> Process with PID 5308 terminated with status 20 at 20150219032448!

SAPup> Starting subprocess in phase 'SQLDB_D1GENIN_TRNS' at 20150219032452

    ENV: DBMS_TYPE=mss

    ENV: JAVA_HOME=E:\usr\sap\EI6\DVEBMGS00\exe\sapjvm_5

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=E:\usr\sap\EI6\SUM\abap\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jre6\bin;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;E:\usr\sap\EI6\DVEBMGS00\exe;E:\usr\sap\EI6\SYS\exe\uc\NTAMD64

    ENV: SAPSYSTEMNAME=EI6

    ENV: dbs_mss_schema=ei6

2.  SQLDBSCRIPT.SAV

     ===============

#!--------------------------------------------------------------

#!---- MASKING file "SQLDBSCRIPT.OUT" from "E:\usr\sap\EI6\SUM\abap\log"

#!---- TIME: 20150219032452  PHASE: MAIN_TRANSEXEC/SQLDB_D1GENIN_TRNS

#!--------------------------------------------------------------

1 ETQ000 ==================================================

1 ETQ399 Executing SQL script '..\var\SQLDBSCRIPT.TQL'.

2 ETQ399 Connecting to database 'mss'.

3 ETQ398 SQL: INSERT INTO D1GEN VALUES ( 'UPGRADE', '000', 'HOST', '19720706000000')

4 ETQ010 Date & Time: 20150219032448 

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20150219032448 

1EETQ008 Error message: DBSL error 26 (db code 2627):

Violation of PRIMARY KEY constraint 'D1GEN~0'. Cannot insert duplicate key in object 'ei6.D1GEN'. The duplicate key value is (UPGRADE).

1EETQ003 exit code: "12"

4 ETQ399 Rollback.

2.  SQLDBSCRIPT.OUT

     ===============

1 ETQ000 ==================================================

1 ETQ399 Executing SQL script '..\var\SQLDBSCRIPT.TQL'.

2 ETQ399 Connecting to database 'mss'.

3 ETQ398 SQL: INSERT INTO D1GEN VALUES ( 'UPGRADE', '000', 'HOST', '19720706000000')

4 ETQ010 Date & Time: 20150219032452 

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20150219032452 

1EETQ008 Error message: DBSL error 26 (db code 2627):

Violation of PRIMARY KEY constraint 'D1GEN~0'. Cannot insert duplicate key in object 'ei6.D1GEN'. The duplicate key value is (UPGRADE).

1EETQ003 exit code: "12"

4 ETQ399 Rollback.

SQLSTMTSTD.OUT.txt.zip

SQLDBSCRIPT.OUT.txt.zip

[former_member182657 · Accepted solution]

Hi,

Could you update DBSL Patch level with latest available at SMP & retry the process.

Regards