on 03-07-2016 4:15 PM
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.
Hi Benoit,
Kindly check the sapnote
2219528 - Upgrade issue due to conversion error for table SUSAGE
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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,
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,
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
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,
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I have also found the following SAP error:
Nametab-Inconsistency for Table QCM8TARCHE regarding buffering of database views
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.