0 Replies Latest reply on Mar 4, 2015 2:02 PM by Renu Singh

    Jboss 5.1.0 Connection Closed issue

    Renu Singh Newbie

      Hello,

       

      My IdM application is deployed on Jboss 5.1.0 and Jboss server are in clustered mode. I receive Connection is closed message on secondary server and this issue is very intermittent and only on secondary server.


      I verified everything is similar to primary server same JDBC driver same settings and configurations. No network issue.

       

      Any thought greatly appreciated !

      ************************

       

      Line 156: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 209: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 262: 2015-03-04 05:16:30,792 ERROR [com.workpoint.server.ejb.GenericBean] (JobQueryWPDS) SQLException occurred: The connection is closed.

        Line 265: com.workpoint.server.ejb.WorkPointEJBException: The connection is closed.SQL Command = SELECT  WP_JOB_MONITOR.JOB_FIFO, WP_JOB_MONITOR.ASSIGNMENT_FLAG, WP_JOB_MONITOR.ASSIGNEE, WP_JOB_MONITOR.EVALUATION_COUNT, WP_JOB_MONITOR.MONITOR_TYPE, WP_JOB_MONITOR.PROCI_ID, WP_JOB_MONITOR.PROCI_DB, WP_JOB_MONITOR.STATE_ID, WP_JOB_MONITOR.START_DATE, WP_JOB_MONITOR.ROW_VERSION, WP_JOB_MONITOR.LU_ID, WP_JOB_MONITOR.LU_DATE, WP_JOB_MONITOR.PROCI_NODE_ID, WP_JOB_MONITOR.PROCI_NODE_DB FROM WP_JOB_MONITOR WHERE ASSIGNMENT_FLAG=0 AND START_DATE<? ORDER BY JOB_FIFO

        Line 311: com.workpoint.server.ejb.WorkPointEJBException: The connection is closed.SQL Command = SELECT  WP_JOB_MONITOR.JOB_FIFO, WP_JOB_MONITOR.ASSIGNMENT_FLAG, WP_JOB_MONITOR.ASSIGNEE, WP_JOB_MONITOR.EVALUATION_COUNT, WP_JOB_MONITOR.MONITOR_TYPE, WP_JOB_MONITOR.PROCI_ID, WP_JOB_MONITOR.PROCI_DB, WP_JOB_MONITOR.STATE_ID, WP_JOB_MONITOR.START_DATE, WP_JOB_MONITOR.ROW_VERSION, WP_JOB_MONITOR.LU_ID, WP_JOB_MONITOR.LU_DATE, WP_JOB_MONITOR.PROCI_NODE_ID, WP_JOB_MONITOR.PROCI_NODE_DB FROM WP_JOB_MONITOR WHERE ASSIGNMENT_FLAG=0 AND START_DATE<? ORDER BY JOB_FIFO

        Line 357: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 410: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 463: 2015-03-04 05:16:37,364 ERROR [com.workpoint.server.ejb.GenericBean] (MailQueryWPDS) SQLException occurred: The connection is closed.

        Line 466: com.workpoint.server.ejb.WorkPointEJBException: The connection is closed.SQL Command = SELECT  WP_MAIL_MONITOR.MAIL_FIFO, WP_MAIL_MONITOR.ASSIGNMENT_FLAG, WP_MAIL_MONITOR.ASSIGNEE, WP_MAIL_MONITOR.EVALUATION_COUNT, WP_MAIL_MONITOR.MAIL_ID, WP_MAIL_MONITOR.MAIL_DB, WP_MAIL_MONITOR.MAIL_TYPE_ID, WP_MAIL_MONITOR.PROCI_ID, WP_MAIL_MONITOR.PROCI_DB, WP_MAIL_MONITOR.ACTI_ID, WP_MAIL_MONITOR.ACTI_DB, WP_MAIL_MONITOR.WI_ITERATION, WP_MAIL_MONITOR.STATE_ID, WP_MAIL_MONITOR.CHECK_DATE, WP_MAIL_MONITOR.ROW_VERSION, WP_MAIL_MONITOR.LU_ID, WP_MAIL_MONITOR.LU_DATE FROM WP_MAIL_MONITOR WHERE ASSIGNMENT_FLAG=0 AND CHECK_DATE<=? ORDER BY MAIL_FIFO

        Line 512: com.workpoint.server.ejb.WorkPointEJBException: The connection is closed.SQL Command = SELECT  WP_MAIL_MONITOR.MAIL_FIFO, WP_MAIL_MONITOR.ASSIGNMENT_FLAG, WP_MAIL_MONITOR.ASSIGNEE, WP_MAIL_MONITOR.EVALUATION_COUNT, WP_MAIL_MONITOR.MAIL_ID, WP_MAIL_MONITOR.MAIL_DB, WP_MAIL_MONITOR.MAIL_TYPE_ID, WP_MAIL_MONITOR.PROCI_ID, WP_MAIL_MONITOR.PROCI_DB, WP_MAIL_MONITOR.ACTI_ID, WP_MAIL_MONITOR.ACTI_DB, WP_MAIL_MONITOR.WI_ITERATION, WP_MAIL_MONITOR.STATE_ID, WP_MAIL_MONITOR.CHECK_DATE, WP_MAIL_MONITOR.ROW_VERSION, WP_MAIL_MONITOR.LU_ID, WP_MAIL_MONITOR.LU_DATE FROM WP_MAIL_MONITOR WHERE ASSIGNMENT_FLAG=0 AND CHECK_DATE<=? ORDER BY MAIL_FIFO

        Line 558: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 571: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 708: 2015-03-04 09:35:23,686 ERROR [ims.tmt.persistence] (http-0.0.0.0-8081-91) PersistenceProvider: http-0.0.0.0-8081-91: fetchObjectById: tried '3' times, exception getting object id: The connection is closed.

        Line 709: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1207: 2015-03-04 09:35:23,690 ERROR [ims.tmt.persistence] (http-0.0.0.0-8081-91) PersistenceProvider: http-0.0.0.0-8081-91: getRuntimeStatusDetails: exception in retrieving the rsd: The connection is closed.

        Line 1208: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1336: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1463: 2015-03-04 09:35:23,692 ERROR [ims.tmt.persistence] (http-0.0.0.0-8081-91) PersistenceProvider: http-0.0.0.0-8081-91: getRuntimeStatusDetails: exception in retrieving the rsd: The connection is closed.

        Line 1464: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1591: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1717: 2015-03-04 09:35:23,694 ERROR [ims.tmt.persistence] (http-0.0.0.0-8081-91) PersistenceProvider: http-0.0.0.0-8081-91: getTaskEventState: Exception getting event state: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1718: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1843: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 1981: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 2003: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3526: 2015-03-04 10:01:35,931 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3528: 2015-03-04 10:01:35,931 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3640: 2015-03-04 10:01:35,931 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3642: 2015-03-04 10:01:35,931 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3752: 2015-03-04 10:01:35,931 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3754: 2015-03-04 10:01:35,931 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3864: 2015-03-04 10:01:35,931 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3866: 2015-03-04 10:01:35,931 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3976: 2015-03-04 10:01:35,931 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 3978: 2015-03-04 10:01:35,931 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 4088: 2015-03-04 10:01:35,947 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 4090: 2015-03-04 10:01:35,947 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 4200: 2015-03-04 10:01:35,947 ERROR [ims.jdbc.JDBCManagedObjectProvider] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

        Line 4202: 2015-03-04 10:01:35,947 ERROR [ims.llsdk.md.screen] (main) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.