Posted on

Citrix XenApp 6.5 Initialize data store fails when creating a new farm

When working with a recent customer I came across a rather odd issue. I was creating a second XenApp farm for testing, however, I kept getting a failure when “Initializing the Citrix data store”.

The installer log showed little more than the following.

Exception: Initializing the Citrix data store failed.

The Windows system event log showed some further detail but still wasn’t giving much away. I had gone through many different troubleshooting steps including different database servers, rebuilding the server from a clean Windows DVD and manually setting up an ODBC connect to test the username, password and database. Everything worked as expected but the farm could still not be created.

Log Name: System
Source: IMAService
Date: 30/01/2012 17:04:42
Event ID: 3989
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Server1
Description:
Citrix XenApp failed to connect to the Data Store. ODBC error while connecting to the database: IM002 -> [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Finally I tried some further troubleshooting including changing the farm name, database name, username and password. I was using SQL authentication in this instance, ultimately I found the issue was caused by the use of a semi-colon ; in the password. It appears ; is either an illegal or escape character for the XenApp farm creation. It is worth noting the semi-colon was accepted in an OBDC connection and at the SQL server.

Hope this helps!

Posted on

Citrix The Independent Management Architecture service terminated with service-specific error 2147483659

In Citrix Presenstation Server version 4 and 4.5 you may receive the following error messages in the event log.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 01/08/2011
Time: 15:53:15
User: N/A
Computer: SERVER1
Description:
The Independent Management Architecture service terminated with service-specific error 2147483659 (0x8000000B).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3601
Date: 01/08/2011
Time: 15:53:15
User: N/A
Computer: SERVER1
Description:
Failed to load initial plugins with error IMA_RESULT_TIMEOUT

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3609
Date: 01/08/2011
Time: 15:53:15
User: N/A
Computer: SERVER1
Description:
Failed to load plugin ImaRuntimeSS.dll with error IMA_RESULT_TIMEOUT

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3609
Date: 01/08/2011
Time: 15:53:15
User: N/A
Computer: SERVER1
Description:
Failed to load plugin ImaPsSs.dll with error IMA_RESULT_TIMEOUT

Event Type: Error
Event Source: IMAService
Event Category: None
Event ID: 3615
Date: 01/08/2011
Time: 15:53:15
User: N/A
Computer: SERVER1
Description:
The server running MetaFrame Presentation Server failed to connect to the Data Store. Error – IMA_RESULT_TIMEOUT An unknown failure occurred while connecting to the database.

After initial investigation it wasn’t create if the IMA configuration was connecting to the datastore correctly so I followed CTX105257 to check the location of the DSN was correct. After looking through the config for some reason this server wasn’t connecting directly SQL instance but instead was indirectly connecting to another Presentation server which was down and hense the IMA service couldn’t find the datastore. I reconfigure the datastore to be the SQL instance and started the service which ultimately fixed this issue.