cancel
Showing results for 
Search instead for 
Did you mean: 

Severe error(s) occured in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE! ORA-01400 cannot insert NULL into SWBRULECOM

Former Member
0 Kudos

Hi,

I've got the above error message during the MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE step of my ERP 6 Ehp5 to Ehp6 upgrade using the SUM tool.

The error is :-

ERROR:
Detected the following errors due to error summary in /usr/sap/Q3K/DVEBMGS00/P6/abap/log/DBCLONE.ELG:

8 ETGCLN START CLONING TABLES

3 ETGCLN Reading /usr/sap/Q3K/DVEBMGS00/P6/abap/mem/TAIATRANS.DAT

3 ETGCLN START SWBRULECOM -> SWBRULECOM~

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN  DROP TABLE "SWBRULECOM~"

3 ETGCLN  CREATE TABLE "SWBRULECOM~" ("CLIENT" VARCHAR2 (000003) DEFAULT '000' NOT NULL, "WORKFLOWID" VARCHAR2 (000010) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000004) DEFAULT ' ' NOT NULL, "CATID" VARCHAR2 (000002) DEFAULT ' ' NOT NULL, "OBJTYPE" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "EVENT" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "PARSE_TYP" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "LINE_ID" VARCHAR2 (000003) DEFAULT '000' NOT NULL, "LINE_TYP" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "LEFTEXPR" VARCHAR2 (000255) DEFAULT ' ' NOT NULL, "LEFTEXPTY" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "RIGHTEXPR" VARCHAR2 (000255) DEFAULT ' ' NOT NULL, "RIGHTEXPTY" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "COMPOP" VARCHAR2 (000002) DEFAULT ' ' NOT NULL, "LOGOP" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "NOTFLAG" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "IS_CONTEXT" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "IDENTIFIER" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "DEFAULTCUR" VARCHAR2 (000005) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000064 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN  DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SWBRULECOM~' AND INDEXNAME = ' '

3 ETGCLN  CREATE UNIQUE INDEX "SWBRULECOM^0" ON "SWBRULECOM~" ("CLIENT", "WORKFLOWID", "VERSION", "CATID", "OBJTYPE", "EVENT", "PARSE_TYP", "LINE_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000064 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN  DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SWBRULECOM~' AND INDEXNAME = '0'

3 ETGCLN SWBRULECOM : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "SWBRULECOM~" (  "CLIENT", "WORKFLOWID", "VERSION", "OBJTYPE", "EVENT", "PARSE_TYP", "LINE_ID", "LINE_TYP", "LEFTEXPR", "LEFTEXPTY", "RIGHTEXPR", "RIGHTEXPTY", "COMPOP", "LOGOP", "NOTFLAG", "IS_CONTEXT", "IDENTIFIER", "DEFAULTCUR", "CATID" ) select  "CLIENT", "WORKFLOWID", "VERSION", "OBJTYPE", "EVENT", "PARSE_TYP", "LINE_ID", "LINE_TYP", "LEFTEXPR", "LEFTEXPTY", "RIGHTEXPR", "RIGHTEXPTY", "COMPOP", "LOGOP", "NOTFLAG", "IS_CONTEXT", "IDENTIFIER", "DEFAULTCUR", "CATID" from "SWBRULECOM" WHERE "CLIENT"='000'

1EETGCLN ORA-01400: cannot insert NULL into ("SAPSR3"."SWBRULECOM~"."CATID")

1EETGCLN SWBRULECOM

1EETGCLN

9 ETGCLN CLONING TABLES FAILED

3 ETGCLN ************(094525)************

Looking at the table in the Oracle DB there are only 6 entries in the table and the CATID field is empty in all 6 records :-

SQL> select count(*) from sapsr3.swbrulecom;

  COUNT(*)

----------

         6

SQL> describe sapsr3.swbrulecom;

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

CLIENT                                    NOT NULL VARCHAR2(3)

WORKFLOWID                                NOT NULL VARCHAR2(10)

VERSION                                   NOT NULL VARCHAR2(4)

OBJTYPE                                   NOT NULL VARCHAR2(32)

EVENT                                     NOT NULL VARCHAR2(32)

PARSE_TYP                                 NOT NULL VARCHAR2(1)

LINE_ID                                   NOT NULL VARCHAR2(3)

LINE_TYP                                  NOT NULL VARCHAR2(1)

LEFTEXPR                                  NOT NULL VARCHAR2(255)

LEFTEXPTY                                 NOT NULL VARCHAR2(1)

RIGHTEXPR                                 NOT NULL VARCHAR2(255)

RIGHTEXPTY                                NOT NULL VARCHAR2(1)

COMPOP                                    NOT NULL VARCHAR2(2)

LOGOP                                     NOT NULL VARCHAR2(3)

NOTFLAG                                   NOT NULL VARCHAR2(1)

IS_CONTEXT                                NOT NULL VARCHAR2(1)

IDENTIFIER                                NOT NULL VARCHAR2(32)

DEFAULTCUR                                NOT NULL VARCHAR2(5)

CATID                                     NOT NULL VARCHAR2(2)

SQL> select client,catid from sapsr3.swbrulecom;

CLI CA

--- --

000

000

000

000

000

500

6 rows selected.

SQL>

The ora-01400 error is related to the NULL insert breaking the "NOT NULL" rules of the table definition in the shadow table.

I can't see any similar hits in SDN, Notes and even google search doesn't throw much up.

Does anyone have any ideas on the solution to enable me to continue with the Ehp6 upgrade process ?

Regards,

Brian.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Brian / Dan,

did you ever found a resolution for this?

regards,

Ricardo

dan_pfingsten2
Participant
0 Kudos

Applied the latest Oracle (SBP) bundle patch available at that time to, this resolved the issue.

I believe it was bug 10214232.


0 Kudos

Also worked for me NW740 SP09 to SP14

Answers (1)

Answers (1)

Former Member
0 Kudos

I've also patched R3trans, tp etc to the latest available.

dan_pfingsten2
Participant
0 Kudos

Did you ever find a resolution to this issue?

Any feedback would be appreciated.  Have encountered the same issue, am currently running the latest SUM tool, R3trans, etc.. as you.