SUM Upgrade : error in execution phase MAIN_NEWBAS/PARCONV_UPG

[Former Member]

Hi experts,

would anyone be able to help with the following issue.

We are upgrading from 7.0 to 7.4 using SUM (SP 12).

We have reached the execution phase and have received the following error :

Checks after phase MAIN_NEWBAS/PARCONV_UPG were negative!

Last error code set: Unhandled mode flags found, check 'PARCONV.LOG' for details

ERROR:
Detected the following errors:

# /74upgrade/SUM/abap/log/PD991019.BIW:
3 ETP000 ADD ("LOAD DATE" VARCHAR2 (000008)
3 ETP000 DEFAULT '00000000' NOT NULL
3 ETP000 )
3 ETP000
2WETP000 14:18:03: Retcode 1: error in DDL statement for "/BIC/B0004180001 " - repeat
2EETP345 14:18:15: Retcode 1: SQL-error "1430-ORA-01430: column being added already exists in table
2EETP345 " in DDL statement for "/BIC/B0004180001 "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 14:18:15: error in DDL, nametab for "/BIC/B0004180001" not activated

Am not sure what to do to resolve this.

Have checked the following in SQL :

SQL> describe SAPBW1."/BIC/B0004180001"

Name                                      Null?    Type

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

REQUEST                                   NOT NULL VARCHAR2(30)

DATAPAKID                                 NOT NULL VARCHAR2(6)

PARTNO                                    NOT NULL NUMBER(10)

RECORD                                    NOT NULL NUMBER(10)

/BIC/YMT_YEAR                             NOT NULL VARCHAR2(4)

/BIC/YMT_WEEK                             NOT NULL VARCHAR2(2)

/BIC/YXXMCENT2                            NOT NULL VARCHAR2(2)

/BIC/YMT_CELL                             NOT NULL VARCHAR2(10)

/BIC/YMT_RES                              NOT NULL VARCHAR2(10)

/BIC/YMTMORDNB                            NOT NULL VARCHAR2(15)

/BIC/YMT_PNUM                             NOT NULL VARCHAR2(30)

/BIC/YMT_OPNUM                            NOT NULL VARCHAR2(4)

/BIC/YMT_TIME                             NOT NULL NUMBER(17,3)

/BIC/YMT_RESUB                            NOT NULL NUMBER(10)

/BIC/YMT_CLEAR                            NOT NULL NUMBER(10)

/BIC/YMT_REWRK                            NOT NULL NUMBER(10)

/BIC/YMT_SCRAP                            NOT NULL NUMBER(10)

/BIC/YMT_CNCSS                            NOT NULL NUMBER(10)

/BIC/YXXMCONT2                            NOT NULL VARCHAR2(2)

LOAD DATE                                 NOT NULL VARCHAR2(8)

CALWEEK                                   NOT NULL VARCHAR2(6)

/BIC/YMT_CLRRS                            NOT NULL NUMBER(10)

/BIC/YMT_RFT                              NOT NULL NUMBER(10)

/BIC/YMT_RTIME                            NOT NULL NUMBER(17,3)

/BIC/YMT_CRECS                            NOT NULL NUMBER(10)

SQL> select count(*) from SAPBW1."/BIC/B0004180001" ;

  COUNT(*)

----------

         0

SQL> select * from SAPBW1."/BIC/B0004180001";

no rows selected

Would anyone know how I can proceed from here.

thanks so much for any advice

Terry

[Former Member]

Hello Terry,

As per your query, describe SAPBW1."/BIC/B0004180001", it is clear that column 'LOAD DATE' exists. I suggest you take a backup of this table and then proceed to delete the column and retry using SUM tool.

Thanks.

Best Regards,

Anita