cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member229109
Active Contributor
0 Kudos

Hello,

I think that you have already the SAP message on this issue.

Is it correct?

Regards, Natalia Khlopina

Former Member
0 Kudos

Yes...

Former Member
0 Kudos

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.

Former Member
0 Kudos

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