cancel
Showing results for 
Search instead for 
Did you mean: 

Error on Table QCM8TARCHE during MAIN_TRANSEXEC/PARCONV_TRANS

benoit-schmid
Contributor
0 Kudos

Hello,

I am running an upgrade ECC 6.04 -> 6.07.


During the phase MAIN_TRANSEXEC/PARCONV_TRANS, I have the following error:

4 EGT281 sql:

4 DGT292   "CREATE UNIQUE INDEX 'SUSAGE~0' ON" "'QCM8SUSAGE'" " " " "

4 EGT231      "('PPMSPV',"

4 EGT231      "'FEATURE',"

4 EGT231      "'TYPE',"

4 EGT231      "'SUBTYPE',"

4 EGT231      "'CALENDAR_MONTH')"

4 EGT231      "PCTFREE 10"

4 EGT231      "INITRANS 002"

4 EGT231      "TABLESPACE PSAPSR3"

4 EGT231      "NOCOMPRESS"

4 EGT231      "STORAGE (INITIAL 0000000016 K"

4 EGT231      "NEXT 0000005120 K"

4 EGT231      "MINEXTENTS 0000000001"

4 EGT231      "MAXEXTENTS UNLIMITED"

4 EGT231      "PCTINCREASE 0000"

4 EGT231      "FREELISTS 001)"

4 EDA093 "DDL time(___3):" ".........3" milliseconds

4 EGT281 sql:

4 EGT231      "DELETE FROM DDSTORAGE WHERE"

4 EGT231      "DBSYSABBR = 'ORA' AND"

4 EGT231      "TABNAME = 'QCM8SUSAGE' AND"

4 EGT231      "INDEXNAME = '0'"

4 EDA093 "DDL time(___4):" ".........0" milliseconds

4 EGT830XConversion method : "LOAD" ("RADCVSCH")

4 EGT841 Mapping function: "DEF_MAP"

4 EGT818 Commit after at least every "16.777.216" bytes

2EED0800X"DB_DATA_MOVE": Operation "DD_CHECK_AUTH" failed

2EED0800 "STEP 5": Operation "DB_DATA_MOVE" failed

2EEGT239 Error in step "SUSAGE-STEP5"

4 EGT253XTotal time for table "SUSAGE": "000:00:00"

2EEGT094 Conversion could not be restarted

2 EGT067 Request for "SUSAGE" could not be executed

Could you please tell me how I could solve this inconsistencies?

Thanks in advance for your answer.

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Benoit,

Kindly check the sapnote

2219528 - Upgrade issue due to conversion error for table SUSAGE

With Regards

Ashutosh Chaturvedi

benoit-schmid
Contributor
0 Kudos

Hello,

The note is not very clear:

"During the conversion of the table SUSAGE, the original table is renamed to QCMSUSAGE. This table holds the erroneous data at that point in time. Remove those entries with database means and continue with by repeating the current phase within SUM. The content of this table is only temporary and can be deleted."

Here is my table:

SQL> desc sapsr3.qcmsusage;

Name                       Null?    Type

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

PPMSPV                    NOT NULL VARCHAR2(60)

FEATURE                   NOT NULL VARCHAR2(60)

TYPE                       NOT NULL VARCHAR2(30)

SUBTYPE                   NOT NULL VARCHAR2(30)

CALENDAR_MONTH                NOT NULL VARCHAR2(6)

TRAFFIC                   NOT NULL FLOAT(126)

NORM                       NOT NULL FLOAT(126)

SQL> desc sapsr3.SUSAGE;

ERROR:

ORA-04043: object sapsr3.SUSAGE does not exist

Should I drop the table or truncate it?

Regards,

benoit-schmid
Contributor
0 Kudos

Hello,

The content of the table is

PPMSPV

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

FEATURE

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

TYPE                   SUBTYPE                  CALEND    TRAFFIC

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

      NORM

----------

BAPI_ALM_ORDER_GET_DETAIL

EAM                                  201512          6

     0

PPMSPV

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

FEATURE

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

TYPE                   SUBTYPE                  CALEND    TRAFFIC

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

      NORM

----------

BAPI_ALM_ORDER_GET_DETAIL

EAM                                  201602          1

     0

Regards,

benoit-schmid
Contributor
0 Kudos

Hello,

After reading the Note, I have assumed they meant:

SQL> truncate table sapsr3.qcmsusage;

Please tell me I was correct ?

Thanks in advance for your anwer.

benoit-schmid
Contributor
0 Kudos

Hello,

After deleting the entries I still have the same error:

CONV ENTRY TCNV SUSAGE CNVTTI QCMSUSAGE XXXX 20160308092559DDIC

4 EGT281 sql:

4 EGT231      "DELETE FROM DDSTORAGE WHERE"

4 EGT231      "DBSYSABBR = 'ORA' AND"

4 EGT231      "TABNAME = 'QCM8SUSAGE' AND"

4 EGT231      "INDEXNAME = '0'"

4 EDA093 "DDL time(___4):" ".........0" milliseconds

4 EGT830XConversion method : "LOAD" ("RADCVSCH")

4 EGT841 Mapping function: "DEF_MAP"

4 EGT818 Commit after at least every "16.777.216" bytes

2EED0800X"DB_DATA_MOVE": Operation "DD_CHECK_AUTH" failed

2EED0800 "STEP 5": Operation "DB_DATA_MOVE" failed

2EEGT239 Error in step "SUSAGE-STEP5"

4 EGT253XTotal time for table "SUSAGE": "000:00:00"

2EEGT094 Conversion could not be restarted

2 EGT067 Request for "SUSAGE" could not be executed

The problem seems to be on QCM8SUSAGE

SQL> desc sapsr3.QCM8SUSAGE;

Name                       Null?    Type

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

PPMSPV                    NOT NULL VARCHAR2(60)

FEATURE                   NOT NULL VARCHAR2(60)

TYPE                       NOT NULL VARCHAR2(30)

SUBTYPE                   NOT NULL VARCHAR2(30)

CALENDAR_MONTH                NOT NULL VARCHAR2(6)

TRAFFIC                   NOT NULL NUMBER(16,2)

NORM                       NOT NULL NUMBER(16,2)

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

  COUNT(*)

----------

     0

Regards,

former_member185239
Active Contributor
0 Kudos

Hi Benoit,

Are you getting any dump in the system.

Kindly check the sapnote 1419489 - Conversion of table PRCD_COND terminates in PARCONV_UPG

With Regards

Ashutosh Chaturvedi

benoit-schmid
Contributor
0 Kudos

Hello,


Ashutosh Chaturvedi wrote:

Kindly check the sapnote 1419489 - Conversion of table PRCD_COND terminates in PARCONV_UPG

I have checked the note. But it is not relevant.

Regards,

benoit-schmid
Contributor
0 Kudos

Good morning,

As nobody replied, I had opened an incident.

I provide the the work around that SAP has provided, in case you face such problem.

se14 -> susage -> unlock table -> yes

se14 -> Extras -> Invalid temp.

-> Select QCM8USAGE and QCMSUSAGE -> Delete

se11 -> susage -> activate

The SAP note for this problem is not yet released.

Regards,

0 Kudos

merci beacoup!!!

benoit-schmid
Contributor
0 Kudos

Good morning,


Jürgen Gärtner wrote:

merci beacoup!!!

Have you also met this bug?

Regards,

0 Kudos

Hello Benoit,

yes, also had this problem.

We came from NW7.01 and are trying to go to 7.42.

Thanks again,

Jürgen

Answers (2)

Answers (2)

former_member185239
Active Contributor
0 Kudos

Hi Benoit,

Thank you for the information.

The sapnote which i have provided before which is not related to this table however it has asked to delete the table.

Due to lack of confidence , we didn't suggest you to drop the table.

With Regards

Ashutosh Chaturvedi

benoit-schmid
Contributor
0 Kudos

Hello,

I have also found the following SAP error:

Nametab-Inconsistency for Table QCM8TARCHE regarding buffering of database views

Regards,