4 Replies Latest reply on Oct 17, 2016 9:01 PM by Ashish Vijay

    BSA Snapshot job is getting failed on some Servers

    Ashish Vijay

      Hello,

       

      I am trying to execute one snapshot job on some Windows  and Linux Servers and it is success on some servers and getting failed on few other server. I can see below error in snapshot job run.

       

      Snapshot of target part '??TARGET.WINDIR??' of asset class type 'Directory' failed on target 'APLSAPP0': java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

       

      I am using BSA 8.3 SP2 on Linux Server. I checked the server and they are working fine. Also this error is not coming for all parts of component.

       

      Can someone tell me meaning of this error in snapshot job.

        • 1. Re: BSA Snapshot job is getting failed on some Servers
          Bill Robinson

          get the appserver log from the appserver that ran the wit for this target and see if there is a stack trace.

          • 2. Re: BSA Snapshot job is getting failed on some Servers
            Ashish Vijay

            Hello Bill,

             

            Below are stacktrace i can see in job log file.

             

            [17 Oct 2016 04:00:32,594] [WorkItem-Thread-49] [INFO] [BLAdmin:BLAdmins:] [Snapshot] Executing work item Snapshot Job:Snapshot_Track_Chan

            ged_Files_Linux_BL-1.0; Template:Track_Changed_Files_Linux_BL-1.0; Component:Track_Changed_Files_Linux_BL-1.0 (LTERHDQBIBOP); Server:LTERH

            DQBIBOP;  on application server: xxxxxxx-js2

            [17 Oct 2016 04:00:34,317] [WorkItem-Thread-49] [INFO] [BLAdmin:BLAdmins:] [Snapshot] SQLException: Sql State (42000) Vendor Code (933)

            [17 Oct 2016 04:00:34,332] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot of target part '/' of asset class type 'Di

            rectory' failed on target 'LTERHDQBIBOP': java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

            com.bladelogic.om.infra.mfw.util.BlException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

                    at com.bladelogic.om.infra.model.asset.file.FileSystemObjectFactory.openSnapshotResult(FileSystemObjectFactory.java:281)

                    at com.bladelogic.om.infra.model.snapshot.BaseAssetSnapshotImpl.openPath(BaseAssetSnapshotImpl.java:75)

                    at com.bladelogic.om.infra.app.collector.SnapshotPartAssetContainer.openContainer(SnapshotPartAssetContainer.java:79)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotterUtil.recreateBnpFileFromSnapshot(SnapshotterUtil.java:130)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotPartBaselineImpl.buildBaseline(SnapshotPartBaselineImpl.java:146

            )

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotPartBaselineImpl.createBaseline(SnapshotPartBaselineImpl.java:17

            5)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.Snapshotter.<init>(Snapshotter.java:197)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.takeTemplatePartSnapshot(SnapshotJobWorkItemImpl.java:346)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.takeComponentSnapshot(SnapshotJobWorkItemImpl.java:462)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.doWorkItemExecute(SnapshotJobWorkItemImpl.java:564)

                    at com.bladelogic.om.infra.model.job.workitem.ComponentBasedJobWorkItemImpl.execute(ComponentBasedJobWorkItemImpl.java:120)

                    at com.bladelogic.om.infra.app.service.workitem.WorkItem.doExecute(WorkItem.java:114)

                    at com.bladelogic.om.infra.app.service.workitem.thread.WorkItemThread.execute(WorkItemThread.java:176)

                    at com.bladelogic.om.infra.app.service.workitem.thread.WorkItemThread.execute(WorkItemThread.java:51)

                    at com.bladelogic.om.infra.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:95)

            Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

                    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

                    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

                    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

                    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

                    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

                    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)

                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)

                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)

                    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

                    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)

                    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

                    at com.bladelogic.om.infra.shared.db.BlPreparedStatement.executeQuery(BlPreparedStatement.java:47)

                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:1056)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:699)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:683)

                    at com.bladelogic.om.infra.app.db.DBServiceImpl.execute(DBServiceImpl.java:99)

                    at com.bladelogic.om.infra.model.asset.file.FileSystemObjectFactory.openSnapshotResult(FileSystemObjectFactory.java:277)

                    ... 14 more

            [17 Oct 2016 04:00:34,333] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot of target part '/' of asset class type 'Di

            rectory' failed on target 'LTERHDQBIBOP': java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

            [17 Oct 2016 04:00:34,333] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot job 'Snapshot_Track_Changed_Files_Linux_BL

            -1.0' failed for component 'Track_Changed_Files_Linux_BL-1.0 (LTERHDQBIBOP)' part '/' on server 'LTERHDQBIBOP'

            [17 Oct 2016 04:00:34,361] [WorkItem-Thread-49] [INFO] [BLAdmin:BLAdmins:] [Snapshot] SQLException: Sql State (42000) Vendor Code (933)

            [17 Oct 2016 04:00:34,363] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot of target part '/usr' of asset class type

            'Directory' failed on target 'LTERHDQBIBOP': java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

            com.bladelogic.om.infra.mfw.util.BlException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

                    at com.bladelogic.om.infra.model.asset.file.FileSystemObjectFactory.openSnapshotResult(FileSystemObjectFactory.java:281)

                    at com.bladelogic.om.infra.model.snapshot.BaseAssetSnapshotImpl.openPath(BaseAssetSnapshotImpl.java:75)

                    at com.bladelogic.om.infra.app.collector.SnapshotPartAssetContainer.openContainer(SnapshotPartAssetContainer.java:79)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotterUtil.recreateBnpFileFromSnapshot(SnapshotterUtil.java:130)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotPartBaselineImpl.buildBaseline(SnapshotPartBaselineImpl.java:146

            )

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.SnapshotPartBaselineImpl.createBaseline(SnapshotPartBaselineImpl.java:17

            5)

                    at com.bladelogic.om.infra.model.job.snapshot.snapshotter.Snapshotter.<init>(Snapshotter.java:197)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.takeTemplatePartSnapshot(SnapshotJobWorkItemImpl.java:346)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.takeComponentSnapshot(SnapshotJobWorkItemImpl.java:462)

                    at com.bladelogic.om.infra.model.job.snapshot.SnapshotJobWorkItemImpl.doWorkItemExecute(SnapshotJobWorkItemImpl.java:564)

                    at com.bladelogic.om.infra.model.job.workitem.ComponentBasedJobWorkItemImpl.execute(ComponentBasedJobWorkItemImpl.java:120)

                    at com.bladelogic.om.infra.app.service.workitem.WorkItem.doExecute(WorkItem.java:114)

                    at com.bladelogic.om.infra.app.service.workitem.thread.WorkItemThread.execute(WorkItemThread.java:176)

                    at com.bladelogic.om.infra.app.service.workitem.thread.WorkItemThread.execute(WorkItemThread.java:51)

                    at com.bladelogic.om.infra.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:95)

            Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

                    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

                    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

                    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

                    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

                    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

                    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)

                    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)

                    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)

                    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

                    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)

                    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

                    at com.bladelogic.om.infra.shared.db.BlPreparedStatement.executeQuery(BlPreparedStatement.java:47)

                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

                    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:1056)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:699)

                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.execute(DefaultDatabaseServiceImpl.java:683)

                    at com.bladelogic.om.infra.app.db.DBServiceImpl.execute(DBServiceImpl.java:99)

                    at com.bladelogic.om.infra.model.asset.file.FileSystemObjectFactory.openSnapshotResult(FileSystemObjectFactory.java:277)

                    ... 14 more

            [17 Oct 2016 04:00:34,364] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot of target part '/usr' of asset class type

            'Directory' failed on target 'LTERHDQBIBOP': java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

             

            [17 Oct 2016 04:00:34,364] [WorkItem-Thread-49] [ERROR] [BLAdmin:BLAdmins:] [Snapshot] Snapshot job 'Snapshot_Track_Changed_Files_Linux_BL

            -1.0' failed for component 'Track_Changed_Files_Linux_BL-1.0 (LTERHDQBIBOP)' part '/usr' on server 'LTERHDQBIBOP'

            [17 Oct 2016 04:00:35,402] [WorkItem-Thread-99] [INFO] [BLAdmin:BLAdmins:] [Snapshot] Executing work item Snapshot Job:Snapshot_Track_Chan

            ged_Files_Linux_BL-1.0; Template:Track_Changed_Files_Linux_BL-1.0; Component:Track_Changed_Files_Linux_BL-1.0 (LTERHDQECCPA7); Server:LTER

            HDQECCPA7;  on application server: xxxxxxx-js2

            [17 Oct 2016 04:00:35,408] [WorkItem-Thread-16] [INFO] [BLAdmin:BLAdmins:] [Snapshot] Executing work item Snapshot Job:Snapshot_Track_Chan

            ged_Files_Linux_BL-1.0; Template:Track_Changed_Files_Linux_BL-1.0; Component:Track_Changed_Files_Linux_BL-1.0 (LTERHDQCTMSRV1); Server:LTE

            RHDQCTMSRV1;  on application server: xxxxxxx-js2

            [17 Oct 2016 04:00:35,417] [WorkItem-Thread-86] [INFO] [BLAdmin:BLAdmins:] [Snapshot] Executing work item Snapshot Job:Snapshot_Track_Chan

            ged_Files_Linux_BL-1.0; Template:Track_Changed_Files_Linux_BL-1.0; Component:Track_Changed_Files_Linux_BL-1.0 (LTERHDQSAPTWP); Server:LTER

            HDQSAPTWP;  on application server: xxxxxxxx-js2

            • 3. Re: BSA Snapshot job is getting failed on some Servers
              Bill Robinson

              are you recursively snapshotting / on this server? 

              • 4. Re: BSA Snapshot job is getting failed on some Servers
                Ashish Vijay

                Hello Bill,

                 

                Yes, this is recursive schedule on this server which runs daily.