on 02-17-2014 5:08 AM
Hi Experts ,
We are doing EHP upgrade from EHP6 to EHP7 .Now we are in Downtime phase(Execution phase).We are getting below error.
Further i referred SAP note 1413569 too and followed the attachments too, still stuck in same phase .
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:
# /sapmedia/bharat/tool/SUM/abap/log/PD990217.XXX:
3 ETP399 ("MANDT",
3 ETP399 "SCHEDULERID")
3 ETP399 ALLOW REVERSE SCANS
3 ETP399
2WETP000 05:48:56: Retcode 1: error in DDL statement for "SMSCMAID " - repeat
2EETP345 05:49:08: Retcode 1: SQL-error "-603-SQL0603N A unique index cannot be created because th
2EETP345 e table contains data that would result in duplicate index entries. SQLSTATE=23515" in DD
2EETP345 L statement for "SMSCMAID "
2 ETP399 --------------- DB-ROLLBACK() ---------------
2EETP334 05:49:08: error in DDL, nametab for "SMSCMAID" not activated
The following i did , unlocked the main system and created the Z* report and executed successfully , then locked the system again and tried repeating the phase from where it stopped ,But still error is seen and stuck in the same phase .
Please provide a valuable solution to our issue !!!!
System details:
Type ERP 6.0
Os :Linux x84_64
Db is DB2
Regards
Ram
Hi All,
Issue resolved by giving the below commands:
1)select * from sapxxx.tataf where tabname='SMSCMAID'
2)update sapxxx.tataf set PRTEXT='CREATE INDEX "SMSCMAID~A01" on "SMSCMAID"' where tabname='SMSCMAID' and POSNR=1
3)commit
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks. Solution worked well for me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Worked for me as well - Thanks Ram for sharing. Cheers - Jeff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please confirm your SUM version as under central note 1843776 - Central Note - Software Update Manager 1.0 SP09 [lmt_005]
it is mentioned
--------------------< D053561 13/DEC/12 >-----------------------------
See SAP Note 1413569 for table SMSCMAID
Before you start the Software Update Manager, check if you use the table SMSCMAID. If so, see SAP Note 1413569 to avoid a termination of the upgrade due to duplicate records in the table.
This was prerequisite before starting SUM tool.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ram,
We have the same issue sometime back and after changing the SAP<SID>.TATAF table resolve the issue. We have updated the entry in SAP<SID>.TATAF table to
PRTEXT = CREATE INDEX "SMSCMAID~XXX" on "SMSCMAID" on DB level
XXX----index
Lets try to update your TATAF table and run again.
Regards,
Rafikul
Hi Rafikul,
Thanks for your timely help .
Please provide me the commands to update the entry in TATAF table .
Further , i could see only the below columns in our Database :
db2 => describe table SAPXXX.TATAF
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
TABNAME SYSIBM VARCHAR 90 0 No
POSNR SYSIBM DECIMAL 5 0 No
PRTEXT SYSIBM VARCHAR 237 0 No
3 record(s) selected.
Regards
Ram
Hello Ram,
Did you try exiting from and then re-starting the SUM tool?
Best Regards,
Anita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav ,
Thanks for your help !!!.
Below is the query result ::
db2 => describe indexes for table sapxxx.smscmaid
Index Index Unique Number of Index Index
schema name rule columns type partitioning
------------------------------- ------------------- -------------- -------------- --------------------------- --------------
SAPXXX SMSCMAID~0 P 2 RELATIONAL DATA -
1 record(s) selected.
Just guide me what next to do !!!,i could not see any duplicate entries .
Regards
Ram
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.