EIM/WIM: Errors while agent logging

Unanswered Question
Jun 7th, 2010

Hi,

We have noticed that there are a lot of errors in the eg_log_ipcc-weim1_agent-assignment-process.log file produced while an agent attempts to relogin to the system. Below is an excerpt from that log:

07 июн 2010 10:00:44,391 <@> ERROR <@> [55526:MessageListenerThread - egpl.rulecache.dirty] <@> ProcessId:2088 <@> PID:1 <@> UID:12 <@> HttpSessionId:  <@> com.egain.platform.module.cb.AllBridges <@> executeBridge <@> I18N_EGPL_CB-QUERY_BRIDGE_EXECUTE_FAIL com.egain.platform.framework.dataaccess.exception.DBConnectionException: I18N_EGPL_DATAACCESS-POOL_NOT_FOUNDI18N_EGPL_DATAACCESS-POOL_NOT_FOUNDIPCC_MSSQL_POOL_1 Property = BridgeId & value = 1001
Property = BridgeName & value = Primary_AdapterToFetchDataForMRD
Property = Description & value = Adapter To Fetch Data For MRD
Property = MaxNumRows & value = 999999999
Property = DataSourceName & value = ipcc_db_prim
Property = QueryType & value = 1
Property = SQLQuery & value = Select tmrd.MRDomainID, tmrd.EnterpriseName, tmrd.MediaClassID, tmrd.Description, tmcl.EnterpriseName as MediaClassName  from t_Media_Routing_Domain tmrd, t_Media_Class tmcl where tmrd.MRDomainID = 1 and tmrd.MediaClassID = tmcl.MediaClassID UNION Select distinct tmrd.MRDomainID, tmrd.EnterpriseName, tmrd.MediaClassID, tmrd.Description, tmcl.EnterpriseName as MediaClassName  from t_Media_Routing_Domain tmrd, t_Media_Class tmcl, t_Application_Instance tai, t_Application_Path tap, t_Application_Path_Member tapm where tai.EnterpriseName = '<%CiscoApplicationInstance%>' and tai.ApplicationInstanceID = tap.ApplicationInstanceID and tmrd.MediaClassID != 4 and tap.ApplicationPathID = tapm.ApplicationPathID and tapm.MRDomainID = tmrd.MRDomainID and tmrd.MediaClassID = tmcl.MediaClassID and tmcl.EnterpriseName IN (<%MediaClassIdNames%>) order by tmrd.EnterpriseName
Property = BridgeType & value = 3
Property = DepartmentId & value = 1
Property = bridge_name & value = Primary_AdapterToFetchDataForMRD
Property = bridge_id & value = 1001
Property = delete_flag & value = n
  <@>
com.egain.platform.framework.dataaccess.exception.DBConnectionException: I18N_EGPL_DATAACCESS-POOL_NOT_FOUNDI18N_EGPL_DATAACCESS-POOL_NOT_FOUNDIPCC_MSSQL_POOL_1
at com.egain.platform.framework.dataaccess.DataAccess.getDBConnection(DataAccess.java:4230)
at com.egain.platform.framework.dataaccess.DataAccess.executeSQLSelect(DataAccess.java:457)
at com.egain.platform.module.cb.QueryBridge.executeQueryBridge(QueryBridge.java:563)
at com.egain.platform.module.cb.QueryBridge.executeQueryBridge(QueryBridge.java:501)
at com.egain.platform.module.cb.AllBridges.executeBridge(AllBridges.java:1330)
at com.cisco.ipcc.DataAdapterExecutor.executeBridge(DataAdapterExecutor.java:216)
at com.cisco.ipcc.DataAdapterExecutor.executeBridge(DataAdapterExecutor.java:78)
at com.cisco.ipcc.queue.Queue.getNonEmailMrdDetails(Queue.java:1868)
at com.cisco.ipcc.IPCCHookImplementation.postRetrieveAllQueuesForUserWithPermission(IPCCHookImplementation.java:7922)
at com.egain.platform.module.routing.QueueHook.postRetrieveAllQueuesForUserWithPermission(QueueHook.java:278)
at com.egain.platform.module.routing.Queue.retrieveAllQueuesForUserWithPermission(Queue.java:1962)
at com.egain.live.framework.aas.service.AgentAssignServiceImpl.onMessage(AgentAssignServiceImpl.java:1505)
at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:697)
at java.lang.Thread.run(Thread.java:595)
07 июн 2010 10:00:44,391 <@> ERROR <@> [55526:MessageListenerThread - egpl.rulecache.dirty] <@> ProcessId:2088 <@> PID:1 <@> UID:12 <@> HttpSessionId:  <@> ? <@> ? <@> list of non email mrds could not be fetched. <@>
com.egain.platform.module.cb.exception.BridgeExecuteFailException: I18N_EGPL_CB-QUERY_BRIDGE_EXECUTE_FAIL :: I18N_EGPL_DATAACCESS-POOL_NOT_FOUNDI18N_EGPL_DATAACCESS-POOL_NOT_FOUNDIPCC_MSSQL_POOL_1
at com.egain.platform.module.cb.QueryBridge.executeQueryBridge(QueryBridge.java:693)
at com.egain.platform.module.cb.QueryBridge.executeQueryBridge(QueryBridge.java:501)
at com.egain.platform.module.cb.AllBridges.executeBridge(AllBridges.java:1330)
at com.cisco.ipcc.DataAdapterExecutor.executeBridge(DataAdapterExecutor.java:216)
at com.cisco.ipcc.DataAdapterExecutor.executeBridge(DataAdapterExecutor.java:78)
at com.cisco.ipcc.queue.Queue.getNonEmailMrdDetails(Queue.java:1868)
at com.cisco.ipcc.IPCCHookImplementation.postRetrieveAllQueuesForUserWithPermission(IPCCHookImplementation.java:7922)
at com.egain.platform.module.routing.QueueHook.postRetrieveAllQueuesForUserWithPermission(QueueHook.java:278)
at com.egain.platform.module.routing.Queue.retrieveAllQueuesForUserWithPermission(Queue.java:1962)
at com.egain.live.framework.aas.service.AgentAssignServiceImpl.onMessage(AgentAssignServiceImpl.java:1505)
at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:697)
at java.lang.Thread.run(Thread.java:595)
07 июн 2010 10:01:22,676 <@> ERROR <@> [174792:RMI TCP Connection(9235)-172.18.96.244] <@> ProcessId:2088 <@> PID:1 <@> UID:12 <@> HttpSessionId:  <@> com.egain.live.framework.aas.service.AgentAssignServiceImpl <@> removeAgent <@> Agent already is in unavailable store : 1005 <@>
07 июн 2010 10:19:41,149 <@> ERROR <@> [175206:RMI TCP Connection(9261)-172.18.96.244] <@> ProcessId:2088 <@> PID:1 <@> UID:12 <@> HttpSessionId:  <@> com.egain.live.framework.aas.service.AgentAssignServiceImpl <@> removeAgent <@> Agent already is in unavailable store : 1005 <@>

What's the nature of these errors? How do we avoid them?

Thanks.

Igor

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

I put a Unix tail -f on my log file and logged an agent in and there is only a small amount of activity in that log file on the login. I do see the stuff about

"removeAgent <@> Agent already is in unavailable store : 1005 <@> "

But not your exception.

Going available doesn't add more trace.

Looking at your log file - "Property = DataSourceName & value = ipcc_db_prim" - seems to be indicating

    I18N_EGPL_DATAACCESS-POOL_NOT_FOUND

that your data sources may not be set up correctly in conf\dataaccess\egpl_ds_connpool_map.xml, although if that was wrong, you should have no ICM integration.

Does everything work correctly?

Regards,

Geoff


Igor1906 Mon, 06/07/2010 - 04:16

Hi Geoff,

Thanks for your response.

Yes, everything works but often after login the agent console is not responding and an agent have to relogin to make the agent console working.

Thanks.

Igor

Igor1906 Mon, 06/07/2010 - 04:20

Geoff,

Just one remark: we have installed WEIM as a standalone server, i.e. we did not integrate WEIM with Cisco IPCC.

Igor

Actions

This Discussion