Error on restoring DB on another SQL server

When I restored a DB on another SQL server I got the error bellow when I enter new connection string and try to generate new ID

Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Single, Line 7
Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Bulk, Line 14
Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Int, Line 71
Database error 3930: detected in (SRV=HSE-SQL4, DB=OneIM21) Procedure QBM_PDBQueueInsert_Int, Line 47
Database error 3930: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.

SQL user is ok and also viadmin has correct password .... so any ideas?

Thank you 

Parents
  • Hey mekindad,

    The root cause to our case is the broker service not enabled. We followed the steps in KB189214 (Identity Manager Upgrade Error: "50000: Cannot enable broker because of other users are active.", and finally resolved the issue to restore DB. HTH. 

Reply
  • Hey mekindad,

    The root cause to our case is the broker service not enabled. We followed the steps in KB189214 (Identity Manager Upgrade Error: "50000: Cannot enable broker because of other users are active.", and finally resolved the issue to restore DB. HTH. 

Children
No Data