Unable to join to XenApp 6.5 Farm IMA_RESULT_SQL_EXECUTE_FAILED

[venkata sasank]

Hi All,

 

When we try to join a new server to XenApp Farm it fails with below series of errors.

 

Any quick help is very much appreciated. 

 

Log Name:      System
Source:        IMAService
Date:          3/28/2019 6:47:47 AM
Event ID:      3664
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ABCD.Domain.NET
Description:
Error from SQL Server.  SQLSTATE code: 37000, Message: [Microsoft][ODBC SQL Server Driver]

The subscription is uninitialized or unavailable for immediate updating as it is marked for reinitialization. If using queued failover option, run Queue Reader Agent for subscription initialization. Try again aft. SQL Server error code: 21064, Citrix result status: IMA_RESULT_SQL_EXECUTE_FAILED

 

Log Name:      System
Source:        IMAService
Date:          3/28/2019 6:47:47 AM
Event ID:      3664
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ABCD.Domain.NET
Description:
Error from SQL Server.  SQLSTATE code: 37000, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Updateable Subscriptions: Rolling back transaction.. SQL Server error code: 20512, Citrix result status: IMA_RESULT_SQL_EXECUTE_FAILED

 

Log Name:      System
Source:        IMAService
Date:          3/28/2019 6:47:47 AM
Event ID:      3664
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ABCD.Domain.NET
Description:
Error from SQL Server.  SQLSTATE code: 37000, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction ended in the trigger. The batch has been aborted.. SQL Server error code: 3609, Citrix result status: IMA_RESULT_SQL_EXECUTE_FAILED

 

Log Name:      System
Source:        IMAService
Date:          3/28/2019 6:49:49 AM
Event ID:      3609
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ABCD.Domain.NET
Description:
Failed to load plugin C:\Program Files (x86)\Citrix\System32\Citrix\IMA\SubSystems\ImaRuntimeSS.dll with error IMA_RESULT_SQL_EXECUTE_FAILED

 

Log Name:      System
Source:        IMAService
Date:          3/28/2019 6:49:49 AM
Event ID:      3601
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ABCD.Domain.NET
Description:
Failed to load initial plugins with error IMA_RESULT_SQL_EXECUTE_FAILED
 

[venkata sasank]

Hi All,

 

This issue has been magically resolved after SQL server reboot.

 

Regards,

Sasank

[Alan Lantz]

https://www.sqlservercentral.com/Forums/Topic813399-146-1.aspx

 

Sounds like you have some sort of SQL issue.

 

--Alan--