User Disconnected Several Times per day problem
jmfoster68 Jun 17, 2013 11:43 AMI have a user that gets disconnected from the server several times per day.
It does not appear that her internet connection is dropping, only the connection to jboss.
Could someone please review this error log and suggest a solution. The program is simply a client on her desktop which accesses the server at 192.168.1.36 to run our dispatch software.
log4j:WARN No appenders could be found for logger (org.jboss.security.SecurityAssociation).
log4j:WARN Please initialize the log4j system properly.
select * from company where id ='TMS'
Execution time: 00:00:02
select * from users where users.company_id = 'TMS'
Execution time: 00:00:02
select * from user_menu_toolbar where user_menu_toolbar.company_id = 'TMS' and menu_item_id ='LoadMaster Enterprise Main Menu'
and user_id ='cmorgan' order by sequence
Execution time: 00:00:04
select * from dispatch_control where dispatch_control.company_id = 'TMS' and id =1
Execution time: 00:00:02
select * from planning_profile where planning_profile.company_id = 'TMS' and id ='TANKS'
Execution time: 00:00:01
select * from user_list_default where user_list_default.company_id = 'TMS' and user_id ='cmorgan' and
grid_name ='Available Orders'
Execution time: 00:00:01
select * from list_config where list_config.company_id = 'TMS' and grid_name ='Available Orders' and config_name
='Cassie' order by sequence
Execution time: 00:00:01
select * from user_list_default where user_list_default.company_id = 'TMS' and user_id ='cmorgan' and
grid_name ='TractorPlanning'
Execution time: 00:00:01
select * from list_config where list_config.company_id = 'TMS' and grid_name ='TractorPlanning' and config_name
='Chads Book 2' order by sequence
Execution time: 00:00:01
select * from user_list_default where user_list_default.company_id = 'TMS' and user_id ='cmorgan' and
grid_name ='TractorPlanning'
Execution time: 00:00:01
select * from list_config where list_config.company_id = 'TMS' and grid_name ='TractorPlanning' and config_name
='Chads Book 2' order by sequence
Execution time: 00:00:01
select * from movement where movement.company_id = 'TMS' and id ='121066'
Execution time: 00:00:03
select name, field_name from fieldinfo ,tableinfo where data_type = 'date' and status = 'C' and (fieldinfo.table_name
= tableinfo.name or fieldinfo.table_name = (select name from tableinfo t where tableinfo.duplicate_of_table
= t.name))
Execution time: 00:00:175
select * from users where users.company_id = 'TMS' and id ='cmorgan'
Execution time: 00:00:01
select * from distance_control where distance_control.company_id = 'TMS' and id =1
Execution time: 00:00:01
select * from user_list_default where user_list_default.company_id = 'TMS' and user_id ='cmorgan' and
grid_name ='dispatch_status'
Execution time: 00:00:01
select * from list_config where list_config.company_id = 'TMS' and grid_name ='dispatch_status' and config_name
='Default' order by sequence
Execution time: 00:00:01
select * from fuel_price where fuel_price.company_id = 'TMS' order by price_date desc
Execution time: 00:00:04
select * from pnn_control where pnn_control.company_id = 'TMS' and id =1
Execution time: 00:00:01
True costing permission=false
select * from mc_control where mc_control.company_id = 'TMS'
Execution time: 00:00:01
select * from seg_alloc_control where seg_alloc_control.company_id = 'TMS' and id =1
Execution time: 00:00:01
select * from dspopt_control where dspopt_control.company_id = 'TMS' and id =1
Execution time: 00:00:01
select * from movement_order where movement_order.company_id = 'TMS' and movement_id ='121066' order by
movement_id,movement_order.sequence
Execution time: 00:00:01
select * from orders where orders.company_id = 'TMS' and id ='1040897'
Execution time: 00:00:02
select * from currency_type
Execution time: 00:00:01
select * from customer where customer.company_id = 'TMS' and id ='0065'
Execution time: 00:00:02
select * from equipment_type where equipment_type.company_id = 'TMS'
Execution time: 00:00:01
select stop.* from stop where stop.company_id = 'TMS' and order_id = '1040897' order by order_id, order_sequence
Execution time: 00:00:01
select * from zones where zones.company_id = 'TMS'
Execution time: 00:00:01
select * from stop_note where stop_note.company_id = 'TMS' and stop_id = 'Heathe13681035784191368133963216'
order by sequence
Execution time: 00:00:01
select * from reference_number where reference_number.company_id = 'TMS' and stop_id = 'Heathe13681035784191368133963216'
order by stop_id
Execution time: 00:00:01
select * from stop_note where stop_note.company_id = 'TMS' and stop_id = 'Heathe13681035784191368133963247'
order by sequence
Execution time: 00:00:01
select * from reference_number where reference_number.company_id = 'TMS' and stop_id = 'Heathe13681035784191368133963247'
order by stop_id
Execution time: 00:00:01
select * from other_charge where other_charge.company_id = 'TMS' and order_id = '1040897' order by sequence
Execution time: 00:00:01
select * from movement where movement.company_id = 'TMS' and id ='121066'
Execution time: 00:00:01
select * from stop where stop.company_id = 'TMS' and movement_id = '121066' order by movement_id,movement_sequence
Execution time: 00:00:01
select * from movement_order where movement_order.company_id = 'TMS' and movement_id ='121066' order by
movement_id,movement_order.sequence
Execution time: 00:00:00
select mc_position.* from mc_position ,mc_unit where mc_position.company_id = 'TMS' and mc_unit.id =''
and mc_unit.mc_position_id = mc_position.id and mc_unit.company_id = 'TMS'
Execution time: 00:00:01
select * from callin where callin.company_id = 'TMS' and tractor_id = '' and call_date_time = (select
max(call_date_time) from callin where company_id = 'TMS' and tractor_id = '')
Execution time: 00:00:01
select count(*) temp from order_post_hist where order_post_hist.company_id = 'TMS' and order_id ='1040897'
Execution time: 00:00:00
select * from order_post_hist where order_post_hist.company_id = 'TMS' and order_id ='1040897'
Execution time: 00:00:01
Asynchronous JMSException received at 05/13/2013 10:01:17
org.jboss.mq.SpyJMSException: Exiting on IOE; - nested throwable: (java.net.SocketException: Connection
reset)
at org.jboss.mq.SpyJMSException.getAsJMSException(SpyJMSException.java:72)
at org.jboss.mq.Connection.asynchFailure(Connection.java:421)
at org.jboss.mq.il.uil2.UILClientILService.asynchFailure(UILClientILService.java:174)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleStop(SocketManager.java:439)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.run(SocketManager.java:371)
Asynchronous JMSException received at 05/13/2013 10:01:17
at java.lang.Thread.run(Unknown Source)
org.jboss.mq.SpyJMSException: Exiting on IOE; - nested throwable: (java.net.SocketException: Connection
reset)
org.jboss.mq.SpyJMSException: Exiting on IOE; - nested throwable: (java.net.SocketException: Connection
reset)
at org.jboss.mq.SpyJMSException.getAsJMSException(SpyJMSException.java:72)
at org.jboss.mq.SpyJMSException.getAsJMSException(SpyJMSException.java:72)
at org.jboss.mq.Connection.asynchFailure(Connection.java:421)
at org.jboss.mq.Connection.asynchFailure(Connection.java:421)
at org.jboss.mq.il.uil2.UILClientILService.asynchFailure(UILClientILService.java:174)
at org.jboss.mq.il.uil2.UILClientILService.asynchFailure(UILClientILService.java:174)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleStop(SocketManager.java:439)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.run(SocketManager.java:371)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleStop(SocketManager.java:439)
at java.lang.Thread.run(Unknown Source)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.run(SocketManager.java:371)
at java.lang.Thread.run(Unknown Source)
java.lang.Exception: This is a diagnostic message that is used to help us find screens that are opened
without parent screens.
at com.tms.client.lib.FramedPanel.checkParent(FramedPanel.java:1212)
at com.tms.client.lib.FramedPanel.showInModalFrame(FramedPanel.java:1221)
at com.tms.client.lib.MessageDialog.showMessage(MessageDialog.java:108)
at com.tms.client.lib.Dialogs.error(Dialogs.java:67)
at com.tms.client.lib.FramedPanel$2.onException(FramedPanel.java:384)
at com.tms.common.lib.JMSFactory$LocalExceptionListener.onException(JMSFactory.java:678)
at org.jboss.mq.Connection$ExceptionListenerRunnable.run(Connection.java:1348)
at java.lang.Thread.run(Unknown Source)
05/13/2013 10:04:44 Non-fatal error sending metrics to server.
javax.naming.CommunicationException [Root exception is java.rmi.ConnectIOException: Exception creating
connection to: 192.168.1.36; nested exception is:
java.net.NoRouteToHostException: No route to host:
connect]
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
at javax.naming.InitialContext.lookup(Unknown Source)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:262)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:268)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:207)
at com.tms.common.remote.lib.LibFactory.createLibUtil(LibFactory.java:31)
at com.tms.common.lib.management.SystemMonitor.publish(SystemMonitor.java:147)
at com.tms.common.lib.management.SystemMonitor$MonitorThread.run(SystemMonitor.java:249)
05/13/2013 10:09:50 Non-fatal error sending metrics to server.
javax.naming.CommunicationException: Could not obtain connection to any of these urls: jnjndbapp:5660
and discovery failed with error: javax.naming.CommunicationException: Receive timed out [Root exception
is java.net.SocketTimeoutException: Receive timed out] [Root exception is javax.naming.CommunicationException:
Failed to connect to server jnjndbapp:5660 [Root exception is javax.naming.ServiceUnavailableException:
Failed to connect to server jnjndbapp:5660 [Root exception is java.net.NoRouteToHostException: No route
to host: connect]]]
at org.jnp.interfaces.NamingContext.checkRef(NamingContext.java:1414)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:594)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
at javax.naming.InitialContext.lookup(Unknown Source)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:262)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:268)
at com.tms.common.lib.RemoteFactory.lookup(RemoteFactory.java:207)
at com.tms.common.remote.lib.LibFactory.createLibUtil(LibFactory.java:31)
at com.tms.common.lib.management.SystemMonitor.publish(SystemMonitor.java:147)
at com.tms.common.lib.management.SystemMonitor$MonitorThread.run(SystemMonitor.java:249)