MaxDb 7.7 startup failed

[Former Member]

Hi

i am trying to start the db but it is getting failed with the below error

OS Windows 32 bit

Maxdb 7.7

dbmcli on master6>db_state

OK

State

OFFLINE

---

dbmcli on master6>db_admin

OK

---

dbmcli on master6>db_online

ERR

-24988,ERR_SQL: SQL error

250,Duplicate secondary key

3,Database state: OFFLINE

Internal errorcode, Error code 3320 "duplicate_invkey"

---

dbmcli on master6>db_state

OK

State

OFFLINE

---

Thanks

Sahil Garg

[lbreddemann · Accepted solution]

Hmm... ok, the "duplicates key" error usually can only be the result of an INSERT or UPDATE statement.

But what INSERT/UPDATE SQL happens during the startup?

Well, there is a thing called "SYSTEMTRIGGER" that is executed during startup.

Part of it's duties is to modify entries in the QUERYREWRITERULES table.

To workaround this issue I'd propose to

a) disable the system triggers (parameter UseSystemTriggers = NO)

b) startup the database to online mode

c) reload the system tables (command load_systab)

d) check for any bad indexes

e) shutdown the database (command db_offline)

f) enable the system triggers again and startup

If the problem is not solved by that, a support message would be a good idea (given you're SAP customer).

regards,

Lars

[Former Member]

Hi,

Even we got similar issue but in our case we migrated MAxDB (7.6) to new host and while starting DB on new host it gave us below issue:

dbmcli on <SID>>db_online

ERR

-24988,ERR_SQL: SQL error

250,Duplicate secondary key

3,Database state: OFFLINE

Solution in our Case:

Though while creating DB instance on target host we opt "Restore Parameters from a backup" option but we are giving different database manager user on target host while creating DB instance. On source it was DBAADMIN but on target while creating insatnce we were giving CONTROL.

Check CONTROLUSERID parameter in source host in /sapdb/data/wrk/<SID>/KnlMsg file and use same user while creating new DB instance on target host. It solved our issue.

Regards,

Mukul SHarma

[Former Member]

Hello Sahil,

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"

Did you find a solution?

I have tried with 2 different backup but the result is the same.

I also tried to turn log in overwrite mode because i tought maybe the error comes from the log files but it didn't helped me.

The method from Lars did not helped me either.

Thank you.