-24988,ERR_SQL: SQL error250,Duplicate secondary key:IND1

Arjun Venkateswarlu Apr 20, 2011 5:39 PM

Currently Being Moderated

Hello Guru's,

We have done system copy to MaxDB QA server from Production and completed all the steps except below step

sql_execute update "SAPMCQ"."/SAPAPO/ORDMAP" set logsys='MCQCLNT100' where logsys='MCPCLNT100'.

we are now trying to convert production logical system to QA and getting below error.

dbmcli on SAPMCQ : MCQ>sql_execute update "SAPMCQ"."/SAPAPO/ORDMAP" set logsys='MCQCLNT100' where logsys='MCPCLNT100'

ERR

-24988,ERR_SQL: SQL error

250,Duplicate secondary key:IND1

Please suggest, what can be done to fix it.

Re: -24988,ERR_SQL: SQL error250,Duplicate secondary key:IND1

Natalia Khlopina Apr 21, 2011 1:09 AM (in response to Arjun Venkateswarlu)

Currently Being Moderated

Hello,
I think that you have already the SAP message on this issue.
Is it correct?
Regards, Natalia Khlopina
Report Abuse

Like (0)
- Re: -24988,ERR_SQL: SQL error250,Duplicate secondary key:IND1
  
  Arjun Venkateswarlu Apr 21, 2011 3:07 AM (in response to Natalia Khlopina)
  
  Currently Being Moderated
  
  Yes...
  
  Report Abuse
  
  Like (0)
  - Re: -24988,ERR_SQL: SQL error250,Duplicate secondary key:IND1
    
    Joskin Developpement Jun 10, 2011 1:23 PM (in response to Arjun Venkateswarlu)
    
    Currently Being Moderated
    
    Hi,
    
    after a backup restore of the database, we are experiencing the same problem.
    
    > db_online ERR -24988,ERR_SQL: SQL error 250,Duplicate secondary key 3,Database state: OFFLINE Internal errorcode, Error code 3320 "duplicate_invkey"
    
    How did correct this error?
    
    Thank you.
    
    Report Abuse
    
    Like (0)
    - Re: -24988,ERR_SQL: SQL error250,Duplicate secondary key:IND1
      
      Arjun Venkateswarlu Jun 10, 2011 5:17 PM (in response to Joskin Developpement)
      
      Currently Being Moderated
      
      Hi Joskin,
      
      I had to restore the LiveCache and executed completed post steps and BDLS for LiveCache before releasing system to the users. I didnt get any other solution and that's what recommended by SAP too.
      
      Thanks,
      Arjun
      
      Report Abuse
      
      Like (0)

Go to original post