Informatica RA Agent remains in STOPPED status

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After starting RA Informatica Agent, it remains in a STOPPED status

The following error can be found in the AgentService.log

ErrorMsg: AwE-9999 Internal error
Details: invalid column XML [AGENT, AGENT_DESCR, IP_ADDRESS, ON_LINE, SPOOL_PATH, SLEEP_CMND, OP_SYS, LOGIN_MATCH, USE_REVISIONS, TIME_ZONE, THREAD_SCHED, MASTER_FLAG, AGENT_TYPE, USER_NAME, AGENT_LOGIN, QUEUE, AGENT_LINK, MASTER_LINK, AGENT_STATE, VALIDATION_IP, SO_XML_CLOB, SO_OPER_SEQ, SO_EMAIL, AW_ENVLST_NAME, SO_MACH_LIMIT, CIT_ID] 
java.lang.IllegalArgumentException: XML 
at com.uc4.be.data.TableData.getValueAt(TableData.java:191) 
at com.uc4.be.data.TableData.getStringAt(TableData.java:209) 
at com.appworx.server.sql.CommonDB.getAgent(CommonDB.java:950) 
at com.appworx.agent.AgentService.getAgent(AgentService.java:2481) 
at com.appworx.agent.AgentService.<init>(AgentService.java:493) 
at com.appworx.agent.AgentService.main(AgentService.java:1089)

Environment

Release: AAMORS99000-9.2-Automic Applications Manager-Oracle - RMS
Component:

Resolution

This error is commonly seen when the master and remote Informatica agent are not on the same version. The version details can be confirmed as followed.

Please do this for both the master server and the remote agent server the Informatica agent runs on. 

1. Log into the servers as the Applications Manager OS user.
2. Run $AW_HOME/site/sosite or %AW_HOME%\site\sosite.bat (Windows) directory to set the Applications Manager environment.
3. Run the command 'sover' without the quotes.

This will provide the complete build version details. 

If the version information between the master and remote agent does not match, upgrade the agent or master to a matching version.