Hi All,
We have migrated our OIM databse servers from one infrastructure to New infrastructure.
As part of this migration we created backup of main database and history database and restored to new databse servers on azure infrastructure.
All is working fine except history databse job is getting frozen with below error.
I have enabled DTC properties on both history and main database.
1drv.ms/.../s!At2ViqLAc9Hpxl4f8re7J6ZLepVE
I did checked some solutions on google but nothing helping.
If anyone faced same issue could you please give some pointers how to resolve this.
OIM version on old infrastructure was 8.1.1 and after migration we upgrated to 8.1.5.
ErrorMessages (2022-04-07 11:42:01.973) [810023] Error during execution of statement: exec HDB_PGetRawFromSource N'VMOIMPRxxxx', N'DIM_P', N'DIM_Prod', N'xxxxxxx', 0
[810143] Database error 0: A severe error occurred on the current command. The results, if any, should be discarded.
OLE DB provider "SQLNCLI11" for linked server "Q5012D8C8AF25D8D09FCBF2DADC37547ED363B75C" returned message "No transaction is active.".
[System.Data.SqlClient.SqlException] A severe error occurred on the current command. The results, if any, should be discarded.
OLE DB provider "SQLNCLI11" for linked server "Q5012D8C8AF25D8D09FCBF2DADC37547ED363B75C" returned message "No transaction is active.".
Kind Regards,
Dnyandev
