11 Replies Latest reply on Feb 10, 2015 9:53 AM by Lokanadhan Karthik Branched from an earlier discussion.

    exception during cleanupDatabase

    Lokanadhan Karthik

      Getting the following error while executing delete cleanupdatabase

       

        • 1. Re: exception during cleanupDatabase
          Bill Robinson

          look in the appserver log this ran against and there should be a stack trace.  if you see that it's related to a constraint error they you should first try Trending in Support: Avoiding Referential Integrity errors during BSA Database Cleanup and then re-running cleanup.

          • 2. Re: exception during cleanupDatabase
            Lokanadhan Karthik

            I found the below errors but couldn't get it. Can you please check.

             

            [06 Feb 2015 19:45:39,839] [Client-Connections-Thread-6] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] We successfully set 603 foreign key values to null.

            [06 Feb 2015 19:45:39,839] [Client-Connections-Thread-6] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] The reference SWindowsPatchingJob.SWindowsPatchingJob was successfully resolved.

            [06 Feb 2015 19:45:41,040] [Client-Connections-Thread-6] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] Successfully deleted objects of class type: SBLGroup

            [06 Feb 2015 19:45:41,056] [Client-Connections-Thread-6] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] Deleted 24 entries of type SBLGroup

            [06 Feb 2015 19:45:41,149] [Client-Connections-Thread-6] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] Cleanup encoutered an error during execution.

            [06 Feb 2015 19:45:41,196] [Client-Connections-Thread-1] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] Connection disconnecting: id = 15

            [06 Feb 2015 19:45:49,589] [Scheduled-System-Tasks-Thread-17] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 75271088,Used JVM (B): 891384912,VSize (B): 1268666368,RSS (B): 1211170816,Used File Descriptors: 1971

            [06 Feb 2015 19:46:49,759] [Scheduled-System-Tasks-Thread-3] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 72085544,Used JVM (B): 894570456,VSize (B): 1268965376,RSS (B): 1211551744,Used File Descriptors: 1967

            [06 Feb 2015 19:47:49,757] [Scheduled-System-Tasks-Thread-18] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 69390608,Used JVM (B): 897265392,VSize (B): 1269014528,RSS (B): 1211584512,Used File Descriptors: 1968

            [06 Feb 2015 19:48:33,610] [Authentication-Service-Thread-0] [WARN] [::10.216.16.30] [Appserver] Connection closed by /10.216.16.30:50965 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:48:33,610] [Authentication-Service-Thread-0] [INFO] [::10.216.16.30] [Appserver] Authentication Connection closed

            [06 Feb 2015 19:48:49,569] [Scheduled-System-Tasks-Thread-2] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 64574808,Used JVM (B): 902081192,VSize (B): 1269030912,RSS (B): 1211596800,Used File Descriptors: 1974

            [06 Feb 2015 19:49:03,453] [Client-Connections-Thread-3] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Connection closed by /10.216.16.30:51009 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:49:03,453] [Client-Connections-Thread-3] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Error authorizing the connection

            [06 Feb 2015 19:49:03,453] [Client-Connections-Thread-3] [INFO] [Anonymous:Anonymous:10.216.16.30] [Client] Connection disconnecting: id = 47

            [06 Feb 2015 19:49:49,645] [Scheduled-System-Tasks-Thread-15] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 61574056,Used JVM (B): 905081944,VSize (B): 1269088256,RSS (B): 1211654144,Used File Descriptors: 1975

            [06 Feb 2015 19:50:49,612] [Scheduled-System-Tasks-Thread-6] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 58009096,Used JVM (B): 908646904,VSize (B): 1269141504,RSS (B): 1211691008,Used File Descriptors: 1972

            [06 Feb 2015 19:51:40,812] [Authentication-Service-Thread-1] [WARN] [::10.216.16.30] [Appserver] Connection closed by /10.216.16.30:51142 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:51:40,812] [Authentication-Service-Thread-1] [INFO] [::10.216.16.30] [Appserver] Authentication Connection closed

            [06 Feb 2015 19:51:49,688] [Scheduled-System-Tasks-Thread-8] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 53685168,Used JVM (B): 912970832,VSize (B): 1269022720,RSS (B): 1211609088,Used File Descriptors: 1968

            [06 Feb 2015 19:52:13,931] [Client-Connections-Thread-2] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Connection closed by /10.216.16.30:51177 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:52:13,931] [Client-Connections-Thread-2] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Error authorizing the connection

            [06 Feb 2015 19:52:13,931] [Client-Connections-Thread-2] [INFO] [Anonymous:Anonymous:10.216.16.30] [Client] Connection disconnecting: id = 48

            [06 Feb 2015 19:52:49,578] [Scheduled-System-Tasks-Thread-20] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 49689768,Used JVM (B): 916966232,VSize (B): 1269022720,RSS (B): 1211609088,Used File Descriptors: 1969

            [06 Feb 2015 19:53:49,592] [Scheduled-System-Tasks-Thread-19] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 46114488,Used JVM (B): 920541512,VSize (B): 1269071872,RSS (B): 1211641856,Used File Descriptors: 1968

            [06 Feb 2015 19:54:49,762] [Scheduled-System-Tasks-Thread-8] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 42422616,Used JVM (B): 924233384,VSize (B): 1269141504,RSS (B): 1211691008,Used File Descriptors: 1974

            [06 Feb 2015 19:54:59,527] [Authentication-Service-Thread-2] [WARN] [::10.216.16.30] [Appserver] Connection closed by /10.216.16.30:51344 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:54:59,527] [Authentication-Service-Thread-2] [INFO] [::10.216.16.30] [Appserver] Authentication Connection closed

            [06 Feb 2015 19:55:29,558] [Client-Connections-Thread-4] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Connection closed by /10.216.16.30:51373 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:55:29,558] [Client-Connections-Thread-4] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Error authorizing the connection

            [06 Feb 2015 19:55:29,558] [Client-Connections-Thread-4] [INFO] [Anonymous:Anonymous:10.216.16.30] [Client] Connection disconnecting: id = 49

            [06 Feb 2015 19:55:49,588] [Scheduled-System-Tasks-Thread-8] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 39253976,Used JVM (B): 927402024,VSize (B): 1269092352,RSS (B): 1211658240,Used File Descriptors: 1971

            [06 Feb 2015 19:56:49,727] [Scheduled-System-Tasks-Thread-6] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 35886800,Used JVM (B): 930769200,VSize (B): 1269022720,RSS (B): 1211609088,Used File Descriptors: 1967

            [06 Feb 2015 19:57:49,616] [Scheduled-System-Tasks-Thread-14] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 31860216,Used JVM (B): 934795784,VSize (B): 1269071872,RSS (B): 1211641856,Used File Descriptors: 1968

            [06 Feb 2015 19:58:38,616] [Authentication-Service-Thread-0] [WARN] [::10.216.16.30] [Appserver] Connection closed by /10.216.16.30:51535 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:58:38,616] [Authentication-Service-Thread-0] [INFO] [::10.216.16.30] [Appserver] Authentication Connection closed

            [06 Feb 2015 19:58:49,583] [Scheduled-System-Tasks-Thread-12] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 966656000,Free JVM (B): 27974224,Used JVM (B): 938681776,VSize (B): 1269149696,RSS (B): 1211748352,Used File Descriptors: 1971

            [06 Feb 2015 19:59:08,070] [Client-Connections-Thread-5] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Connection closed by /10.216.16.30:51575 before pre-authentication handshake could be completed.

            [06 Feb 2015 19:59:08,070] [Client-Connections-Thread-5] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Error authorizing the connection

            [06 Feb 2015 19:59:08,070] [Client-Connections-Thread-5] [INFO] [Anonymous:Anonymous:10.216.16.30] [Client] Connection disconnecting: id = 50

            [06 Feb 2015 19:59:49,769] [Scheduled-System-Tasks-Thread-7] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 944570368,Free JVM (B): 806459448,Used JVM (B): 138110920,VSize (B): 1224671232,RSS (B): 1167269888,Used File Descriptors: 1970

            [06 Feb 2015 20:00:04,839] [Job-Execution-0] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Started running the job 'Server Properties Check' with priority 'NORMAL' on application server 'BBSAFLRSRV'(1)

            [06 Feb 2015 20:00:07,725] [WorkItem-Thread-42] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.7.51;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,094] [WorkItem-Thread-6] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:172.21.51.50;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-3] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.11.42;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-12] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.3.208;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-21] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.9.153;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-40] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.8.21;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-37] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:172.23.130.58;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-9] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.7.226;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-48] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Server Properties Job:Server Properties Check; Server:10.216.6.53;  on application server: BBSAFLRSRV

            [06 Feb 2015 20:00:11,110] [WorkItem-Thread-2] [INFO] [BLAdmin:BLAdmins:] [ServerProperty] Executing work item Update Serv

            • 3. Re: exception during cleanupDatabase
              Monoj Padhy

              Please attach the logs or errors, if any. Avoid doing just copy and paste.

              Keep community clean and more readable

              • 4. Re: exception during cleanupDatabase
                Monoj Padhy

                I could see some ERROR or WARN related connection getting disconnected. Running the job w/ DEBUG mode enabled may help here.

                 

                [06 Feb 2015 19:45:41,196] [Client-Connections-Thread-1] [INFO] [BLAdmin:BLAdmins:10.216.16.59] [Client] Connection disconnecting: id = 15

                [06 Feb 2015 19:49:03,453] [Client-Connections-Thread-3] [WARN] [Anonymous:Anonymous:10.216.16.30] [Client] Error authorizing the connection

                [06 Feb 2015 19:54:59,527] [Authentication-Service-Thread-2] [WARN] [::10.216.16.30] [Appserver] Connection closed by /10.216.16.30:51344 before pre-authentication handshake could be completed.

                [06 Feb 2015 19:54:59,527] [Authentication-Service-Thread-2] [INFO] [::10.216.16.30] [Appserver] Authentication Connection closed

                • 5. Re: exception during cleanupDatabase
                  Bill Robinson

                  those messages have nothing to do w/ cleanup.

                  • 6. Re: exception during cleanupDatabase
                    Davorin Stevanovic

                    Could you please make sure you are using correct appserver.log file? Also can you provide us with blcli.log from appdata folder of the user who started blcli location of log files can be found here:

                     

                    Overview of BMC Server Automation log files - BMC Server Automation 8.5 - BMC Documentation

                    1 of 1 people found this helpful
                    • 7. Re: Re: exception during cleanupDatabase
                      Lokanadhan Karthik

                      Found few errors in blcli.log at the job run time. PFA.

                      • 8. Re: exception during cleanupDatabase
                        Davorin Stevanovic

                        Your error is:

                         

                        Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK683_JOB_RUN". The conflict occurred in database "Bladelogic_Apps", table "dbo.batch_job_run", column 'job_run_id'.

                         

                        Please look here for more details and how to fix it, please correctly chose your version:

                        The Pulse: Avoiding Referential Integrity errors during BSA Database Cleanup

                        • 10. Re: exception during cleanupDatabase
                          Bill Robinson

                          Ok, now run cleanup again.

                          • 11. Re: exception during cleanupDatabase
                            Lokanadhan Karthik

                            Thanks All.

                             

                            The execution was successful.