1 Reply Latest reply on Aug 10, 2015 1:21 PM by Bill Robinson

    BSA 8.6 upgrade SQL issue

    Mike Reider

      Wondering if anyone run into this, upgrading RHEL6-based 8.5.1 to 8.6 on MSSQL

       

      when running the DB migration using setup.bin getting this SQL error, pretty generic error.

       

      running the setup file as root.

       

       

       

      015-08-10 11:34:55,399 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(altr_scap_result_rule_and_oval.sql) : 5 milli-seconds

      2015-08-10 11:34:55,412 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.om.infra.shared.db.BlCallableStatement  - SQLException: Sql State (S0001) Vendor Code (3903)

      2015-08-10 11:34:55,414 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] ERROR com.bladelogic.mig.framework.datamigration.action.DataMigrationRestartableAction  - The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

      com.microsoft.sqlserver.jdbc.SQLServerException: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

        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.execute(SQLServerPreparedStatement.java:332)

        at com.bladelogic.om.infra.shared.db.BlCallableStatement.execute(BlCallableStatement.java:454)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

        at com.bladelogic.mig.framework.datamigration.action.DataMigrationRestartableAction$SqlStoredProcedure.doExecute(DataMigrationRestartableAction.java:507)

        at com.bladelogic.mig.framework.datamigration.action.DataMigrationXmlAction.execute(DataMigrationXmlAction.java:191)

        at com.bladelogic.mig.framework.datamigration.action.DataMigrationRestartableAction.doExecute(DataMigrationRestartableAction.java:186)

        at com.bladelogic.mig.framework.datamigration.action.DataMigrationXmlAction.execute(DataMigrationXmlAction.java:191)

        at com.bladelogic.mig.framework.datamigration.XmlCommands.executeXmlAction(XmlCommands.java:138)

        at com.bladelogic.mig.framework.datamigration.XmlCommands.execute(XmlCommands.java:126)

        at com.bladelogic.mig.framework.datamigration.DataMigration.doMigrateData(DataMigration.java:60)

        at com.bladelogic.mig.framework.datamigration.AbstractDataMigration.migrateData(AbstractDataMigration.java:26)

        at com.bladelogic.mig.framework.singlestepmigration.XMLFileMigration.runCommandsInXMlFile(XMLFileMigration.java:56)

        at com.bladelogic.mig.framework.singlestepmigration.SingleStepMigration.runSQLInMigrationActionsXML(SingleStepMigration.java:151)

        at com.bladelogic.mig.framework.singlestepmigration.SingleStepMigration.runSingleStepMigration(SingleStepMigration.java:89)

        at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.runChainedMigration(ChainedMigration.java:79)

        at com.bladelogic.mig.Migration.runCLI(Migration.java:218)

        at com.bladelogic.mig.Migration.runMigration(Migration.java:160)

        at com.bladelogic.mig.Migration.main(Migration.java:41)

        at com.bmc.install.product.bladelogic.action.others.BlDatabaseUpgradeAction.runDBMigration(BlDatabaseUpgradeAction.java:143)

        at com.bmc.install.product.bladelogic.action.others.BlDatabaseUpgradeAction.runInteractiveDBMigrator(BlDatabaseUpgradeAction.java:85)

        at com.bmc.install.product.bladelogic.action.others.BlDatabaseUpgradeAction.execute(BlDatabaseUpgradeAction.java:53)

        at com.bmc.install.product.bladelogic.standalone.StandaloneDatabaseMigrationCommand.execute(StandaloneDatabaseMigrationCommand.java:39)

        at com.bmc.install.product.bladelogic.standalone.StandaloneConfiguratorCommandExecutor.execute(StandaloneConfiguratorCommandExecutor.java:68)

        at com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask.execute(BSAStandaloneStatelessConfiguratorTask.java:73)

        at com.bmc.install.task.InstallationTask.run(InstallationTask.java:93)

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

      2015-08-10 11:34:55,416 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(altr_scap_result_rule_and_oval) : 17 milli-seconds

      2015-08-10 11:34:55,421 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(mig_scap_result_rule_and_oval.sql) : 5 milli-seconds

      2015-08-10 11:34:55,433 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(mig_scap_result_rule_and_oval) : 12 milli-seconds

      2015-08-10 11:34:55,437 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(Drop_altr_scap_result_rule_and_oval.sql) : 4 milli-seconds

      2015-08-10 11:34:55,437 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(altr_scap_result_rule_and_oval) : 45 milli-seconds

      2015-08-10 11:34:55,439 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(QM001850726.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,440 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(QM001850726)

      2015-08-10 11:34:55,440 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(QM001850726) : 3 milli-seconds

      2015-08-10 11:34:55,442 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(aix_gwp.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,442 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(aix_gwp)

      2015-08-10 11:34:55,442 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(aix_gwp) : 2 milli-seconds

      2015-08-10 11:34:55,444 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(patch_iava_suma.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,444 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(patch_iava_suma)

      2015-08-10 11:34:55,444 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(patch_iava_suma) : 2 milli-seconds

      2015-08-10 11:34:55,446 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(REPOPULATE_ACL_AGGREGATION_TABLE_98005.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,446 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(REPOPULATE_ACL_AGGREGATION_TABLE_98005)

      2015-08-10 11:34:55,446 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(REPOPULATE_ACL_AGGREGATION_TABLE_98005) : 2 milli-seconds

      2015-08-10 11:34:55,448 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(REPOPULATE_ACL_POLICY_AGGREGATION_TABLE_98010.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,448 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(REPOPULATE_ACL_POLICY_AGGREGATION_TABLE_98010)

      2015-08-10 11:34:55,448 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(REPOPULATE_ACL_POLICY_AGGREGATION_TABLE_98010) : 2 milli-seconds

      2015-08-10 11:34:55,450 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(REPOPULATE_ROLE_AGGREGATION_TABLE_98015.mig_should_task_script_run) : 1 milli-seconds

      2015-08-10 11:34:55,450 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(REPOPULATE_ROLE_AGGREGATION_TABLE_98015)

      2015-08-10 11:34:55,450 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(REPOPULATE_ROLE_AGGREGATION_TABLE_98015) : 2 milli-seconds

      2015-08-10 11:34:55,452 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(QM001852852.mig_should_task_script_run) : 2 milli-seconds

      2015-08-10 11:34:55,452 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(alter_constraint)

      2015-08-10 11:34:55,452 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(alter_constraint) : 2 milli-seconds

      2015-08-10 11:34:55,454 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(prop_def_psipv_insert.mig_should_task_script_run) : 2 milli-seconds

      2015-08-10 11:34:55,454 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(prop_def_psipv_insert)

      2015-08-10 11:34:55,454 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(prop_def_psipv_insert) : 2 milli-seconds

      2015-08-10 11:34:55,456 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(mig_vendor_impact.mig_should_task_script_run) : 2 milli-seconds

      2015-08-10 11:34:55,456 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(mig_vendor_impact)

      2015-08-10 11:34:55,456 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(mig_vendor_impact) : 2 milli-seconds

      2015-08-10 11:34:55,458 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(Sql) name(UPDDBVERSION_100000.mig_should_task_script_run) : 2 milli-seconds

      2015-08-10 11:34:55,458 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  -  *********** Exit condition met, exiting this restartable action(UPDDBVERSION_100000)

      2015-08-10 11:34:55,458 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - Time taken for action node(RestartableAction) name(UPDDBVERSION_100000) : 2 milli-seconds

      2015-08-10 11:34:55,473 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.common.MigLogger  - EXCEPTION WHILE RUNNING SINGLE STEP MIGRATION FROM 8.5.00,8.5.01 TO 8.6.00

      ============================================================================================

      [1] ERROR: TSK NM=Alter  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=Error Cannot drop the index 'scap_result_rule_and_oval_data.XFK2431_OVAL_DEFINITIONS', because it does not exist or you do not have permission. 

      [2] ERROR: TSK NM=Alter  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=Upgrade halted. Alter did not complete step altr altr_scap_result_rule_and_oval table.  Contact BladeLogic Support before resuming.             

      .

      .

      ****** FINISHED ****** SINGLE STEP MIGRATION FROM 8.5.00,8.5.01 TO 8.6.00

      FROM CONFIG FILE /app/8.6/Disk1/files/configurations/db_scripts/sqlserver/upgrade/8.5.00_to_8.6.00/OM/Migration_actions/

      WITH **2** ERRORS

      .

      .

      2015-08-10 11:34:55,473 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.chainedmigration.ChainedMigration  -

      ============================================================================================

      DISPLAYING ALL THE ERRORS

      ============================================================================================

       

       

      2015-08-10 11:34:55,474 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.singlestepmigration.SingleStepMigrationResult  - [1] SingleStepMigrationResult: TSK NM=Alter  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=Error Cannot drop the index 'scap_result_rule_and_oval_data.XFK2431_OVAL_DEFINITIONS', because it does not exist or you do not have permission. 

      [2] SingleStepMigrationResult: TSK NM=Alter  ; TSK SCR NM=    ; TO=8.6.00  ; TSK MSG=Upgrade halted. Alter did not complete step altr altr_scap_result_rule_and_oval table.  Contact BladeLogic Support before resuming.             

       

       

      2015-08-10 11:34:55,474 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.chainedmigration.ChainedMigration  - Any error=true;; Framework error=false;; Data error=true

       

       

      2015-08-10 11:34:55,474 [Thread-68 -- Task: com.bmc.install.product.bladelogic.BSAStandaloneStatelessConfiguratorTask] INFO  com.bladelogic.mig.framework.chainedmigration.ChainedMigration  -

      ============================================================================================