cancel
Showing results for 
Search instead for 
Did you mean: 

error in MAIN_NEWBAS/PARCONV_UPG

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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

tobiasharmes
Participant
0 Kudos

Hi Ram.

Thanks for sharing. That worked for me as well.

Cheers, Tobias

0 Kudos

Worked! Thanks Ram.

Answers (7)

Answers (7)

sourabhchordiya
Explorer
0 Kudos

Thanks. Solution worked well for me

former_member188433
Participant
0 Kudos

Worked for me as well - Thanks Ram for sharing.  Cheers - Jeff

former_member182657
Active Contributor
0 Kudos

Hi Ram,

Please follow scn link

Hope this will also help you.

Regards

former_member182657
Active Contributor
0 Kudos

Hi Ram,

Please follow SAP Note   1346662 - Avoid index creation errors in 7.0x upgrades

Regards,

Gaurav

former_member182657
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Yes, i have seen that !!!

Let me know how now we can avoid this !!!!

Regards

Ram

former_member187565
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello Ram,

Did you try exiting from and then re-starting the SUM tool?

Best Regards,

Anita

former_member182657
Active Contributor
0 Kudos

Hi ,

Please refer scn link

Regards,

Gaurav

Former Member
0 Kudos

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