Informatica RA Agent remains in STOPPED status

Document ID : KB000103579
Last Modified Date : 02/07/2018
Show Technical Document Details
Issue:
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)
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.