IMAService event ID 3664

[Nicolas Vallon]

Hello all.

 

(sorry but I'm a french native speaker, and i'll do my best to write as right as possible) I'm totaly newer in xenapp ...  :)

 

I went in trouble with my xenapp farme.

 

For a little time, I'm not able to change anything in my published app with an error message (wich is not present anymore ... But I'm not able to change something at all).

 

I found in the event log a lot of event 3664 who tell me that :

"Erreur SQL Server.  Code SQLSTATE : S0022, message : [Microsoft][ODBC SQL Server Driver]

Nom de colonne non valide : 'NODEID'.. Code d'erreur SQL Server : 207, état de résultat Citrix : IMA_RESULT_SQL_EXECUTE_FAILED"

 

If I translate it tell me that process cant found column named NODEID (and other in different event la IMALOCK) in database, result in SQL server error. What is strange, in DATABASE I have a nodeid colum but not a NODEID, and because the databse is case sensitive I cant pasted a SQL COMMANDE using upper case.

 

Connexion to datastore seem to be good and application IMA helper reached the server ...

 

Thanks for any help you''ll be able to provide !

 

Cheers !

[venkata sasank]

hi,

 

Have you got this issue resolved? 

I'm facing issue with similar event ID

 

Log Name:      System
Source:        IMAService
Date:          3/30/2019 1:08:02 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]

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/30/2019 1:08:02 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