⚑ Deus Ex Machina ➽ Eventlog Lookup

Deus Ex Machina » Eventlog » Event 3621 - IMAService

IMAService - 3621


Error

Description »
The server running Citrix Presentation Server failed to connect to the Data Store.  Error - IMA_RESULT_DBCONNECT_FAILURE The database is down or there is a network failure.
Data formatted as » None

The IMA Service (Citrix Independent Management Architecture) logs this event when it cannot connect to the datastore.

Each Citrix Presentation Server farm has a datastore, which will likely be an MS-SQL or Oracle database server. In order to tell which server this is, you need to look at the MF20.dsn and/or MF22.dsn file. This should be located at %PROGRAMFILES%\Citrix\Independent Management Architecture.

If connecting to an MS-SQL server or instance, these files should contain a line which tells you which server/instance you're using.

C:\Program Files\Citrix\Independent Management Architecture>type MF22.dsn [ODBC] DRIVER=SQL Server UID=serv_ctxdb Network=DBMSSOCN LANGUAGE=us_english DATABASE=CPS45 IMA DB SQL05 BO WSID=LON-TS12 APP=Citrix IMA SERVER=LON_CTX_SQL\CITRIX3 Description=CPS45 IMA DB SQL05 BO

This tells us that we're talking to the server LON_CTX_SQL, and specifically to the instance CITRIX3.

If you're using an Oracle database, the file will look a little different:

[ODBC] DRIVER=Oracle in OraClient10g_home1 UID=citrix_ps TLO=O FBS=60000 FWC=F CSR=F MDI=Me MTS=T DPM=F NUM=NLS BAM=IfAllSuccessful BTD=F RST=T LOB=T FDL=10 FRC=10 QTO=T FEN=T XSM=Default EXC=F APA=T DBA=W DBQ=LIVE SERVER=LIVE

In this case, your best bet is to use TNS Ping to resolve/check the datastore:

C:\Program Files\Citrix\Independent Management Architecture>tnsping live TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 18-JAN-2012 13:11:08 Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files: D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.9.202)(PORT = 1521))) (CONNECT_DATA = (SID = LIVE))) OK (0 msec)

You'll see this event logged if your datastore server/instance is down, or if there's a loss of network connectivity (even if only momentarily - eg while a HA switch pair fails over).