6 Replies Latest reply on Nov 6, 2014 2:49 PM by Amir Khamis

    An issue with the BSA 8.5 offline database cleanup utility (dbm)

    Amir Khamis

      Hello,

      I am attempting to use the new BSA 8.5SP1P2 DBM (offline database cleanup) Utility described here: https://docs.bmc.com/docs/display/public/bsa85/Performing+offline+database+cleanup

      Which gets installed on the APP server.  My lab DB server is SQL 2008SP3 with BSA 8.5SP1P2.  BSA was upgraded from 8.2.04 in my case, my starting point was 8.2.04.

      I get an error message stating that my bsa db user should have the sysadmin role which it does and that my SQL Server Agent Service is running which is down and disabled.

      I attached 3 screenshots.

      Here is the error log messages I see in my \NSH\br\dbm-rcp\dbmaintenance.log

       

      [05 Nov 2014 13:21:48,869] [main] [INFO] [::] [] Current DB Date : 2014-11-05 13:21:48.867

      [05 Nov 2014 13:21:48,869] [main] [INFO] [::] [] Generated guid : F9E672DB35F9FC40B03080DDCF989936

      [05 Nov 2014 13:21:48,869] [main] [INFO] [::] [] Calling offline maintenance SP : guid<[B@1fa3da81> duration<-1>

      [05 Nov 2014 13:21:48,884] [main] [INFO] [::] [] SQLException: Sql State (S0001) Vendor Code (50000)

      [05 Nov 2014 13:21:48,884] [main] [ERROR] [::] [] Exception Occured :

      1. com.bladelogic.dbm.exception.DataAccessException

      at com.bladelogic.dbm.ui.dataaccess.DataAccessHelper.performOfflineMaintenance(DataAccessHelper.java:490)

      at com.bladelogic.dbm.ui.DbMaintenancePageComposite$7.callDbMaintenanceSP(DbMaintenancePageComposite.java:555)

      at com.bladelogic.dbm.ui.DbMaintenancePageComposite$7.run(DbMaintenancePageComposite.java:545)

      at java.lang.Thread.run(Unknown Source)

      at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:180)

      at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)

      at org.eclipse.swt.widgets.Display.syncExec(Display.java:4683)

      at com.bladelogic.dbm.ui.DbMaintenancePageComposite.startDbMaintenance(DbMaintenancePageComposite.java:563)

      at com.bladelogic.dbm.ui.DbMaintenancePageComposite.renderPage(DbMaintenancePageComposite.java:362)

      at com.bladelogic.dbm.ui.AbstractComposite.renderCenterArea(AbstractComposite.java:125)

      at com.bladelogic.dbm.ui.AbstractComposite.<init>(AbstractComposite.java:49)

      at com.bladelogic.dbm.ui.DbMaintenancePageComposite.<init>(DbMaintenancePageComposite.java:100)

      at com.bladelogic.dbm.ui.View.getCurrentPageComponent(View.java:347)

      at com.bladelogic.dbm.ui.View.setCurrentStep(View.java:305)

      at com.bladelogic.dbm.ui.SettingsPageComposite.handleProceedToNextStep(SettingsPageComposite.java:1070)

      at com.bladelogic.dbm.ui.SettingsPageComposite.handleNextBtnClick(SettingsPageComposite.java:919)

      at com.bladelogic.dbm.ui.SettingsPageComposite.access$0(SettingsPageComposite.java:882)

      at com.bladelogic.dbm.ui.SettingsPageComposite$1.handleEvent(SettingsPageComposite.java:201)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)

      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)

      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)

      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)

      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

      at com.bladelogic.dbm.ui.Application.start(Application.java:41)

      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)

      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)

      at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

      at org.eclipse.equinox.launcher.Main.main(Main.java:1386)

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 20001

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)

      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)

      at com.bladelogic.om.infra.shared.db.BlCallableStatement.executeUpdate(BlCallableStatement.java:485)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

      at com.bladelogic.dbm.ui.dataaccess.DataAccessHelper.performOfflineMaintenance(DataAccessHelper.java:482)

      ... 42 more

      [05 Nov 2014 13:21:48,884] [main] [DEBUG] [::] [] Updating Step status : Database Maintenance = ERRORED

      [05 Nov 2014 13:21:48,884] [main] [DEBUG] [::] [] Updating Step status : Summary = PROCESSING

      [05 Nov 2014 13:21:50,522] [main] [DEBUG] [::] [] Refreshing view at : Wed Nov 05 13:21:50 EST 2014

      [05 Nov 2014 13:21:50,522] [main] [INFO] [::] [] runid : -1

      [05 Nov 2014 13:22:20,537] [main] [DEBUG] [::] [] Refreshing view at : Wed Nov 05 13:22:20 EST 2014

      [05 Nov 2014 13:22:20,537] [main] [DEBUG] [::] [] Stopped refreshing view at : Wed Nov 05 13:22:20 EST 2014

       

       

      Can you please let me know what I am doing wrong?

      Thanks