0 Replies Latest reply on Jun 17, 2013 11:43 AM by John Foster

    User Disconnected Several Times per day problem

    John Foster Newbie

      I 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)