4 Replies Latest reply on Dec 2, 2014 4:09 PM by John O'Toole

    BBSA 8.3 upgrade is failing

      Experts,

       

      I am upgrading my Windows appserver from 8.2.01.328 to 8.3 version and it's failing with the below error,

      but there is a user present in DB with name called "bladelogic" and I can connect to DB using that.

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      [12 Dec 2013 16:41:12,288] [main] [ERROR] [::] [] Failed to update deployments

      com.bladelogic.om.infra.app.bladmin.StorageException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'.

        at com.bladelogic.om.infra.app.bladmin.DbStorage.setUpJdbcConnection(DbStorage.java:138)

       

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      deployment_upgrade.log:

       

      [02 Jan 2013 12:12:54,310] [main] [INFO] [::] [] Starting Model Graph Service...

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Model Graph Service started.

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Registering remote services...

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Remote services registered.

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Performing post-deployment operations...

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Post-deployment operations completed.

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Performing post-startup deployment operations...

      [02 Jan 2013 12:12:55,667] [main] [INFO] [::] [] Post-startup deployment operations complete.

      [02 Jan 2013 12:12:55,683] [main] [INFO] [::] [] Updating _launcher deployment

      [02 Jan 2013 12:12:55,698] [main] [INFO] [::] [] set AppServerLauncher KeyStorePassword to EBOUZLPZVZEXEKENQWVXEPVPVNONUNENLPKEXWVUWWNMZNWQLAVBVTTTAQZMUVXV (was ALNXLTUPZUWLMKUOXQKZUVOZKNXQEQVLKXPOEKOKNEEKLVTQPXNNLOAQPMKMVUQN in new installation)

      [02 Jan 2013 12:12:55,698] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_launcher to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_launcher

      [02 Jan 2013 12:12:55,698] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _launcher

      [02 Jan 2013 12:12:55,714] [main] [INFO] [::] [] Copying AppServerLauncher-users.conf from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_launcher to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_launcher

      [02 Jan 2013 12:12:55,714] [main] [INFO] [::] [] Updated AppServerLauncher-users.conf for deployment _launcher

      [02 Jan 2013 12:12:55,839] [main] [INFO] [::] [] Updating _template deployment

      [02 Jan 2013 12:12:55,870] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor (was not previously set in new installation)

      [02 Jan 2013 12:12:55,885] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was not previously set in new installation)

      [02 Jan 2013 12:12:55,901] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was not previously set in new installation)

      [02 Jan 2013 12:12:55,917] [main] [INFO] [::] [] set Database UserId to bladelogic (was not previously set in new installation)

      [02 Jan 2013 12:12:57,539] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was VWMBPPEWXWAAZMBMMVBKBBVPVWMBAEKEPZBKOZPTAEPAQBZNVALKWBTPBQVEQWOU in new installation)

      [02 Jan 2013 12:12:58,881] [main] [INFO] [::] [] set AppServer CertPasswd to MAWKZKLWBUXUEKQUQUZBMNQNWALTXTQLLVVVOXOMTWLPXVATBZMZKEXTOXTOTZAK (was ALNXLTUPZUWLMKUOXQKZUVOZKNXQEQVLKXPOEKOKNEEKLVTQPXNNLOAQPMKMVUQN in new installation)

      [02 Jan 2013 12:12:59,224] [main] [INFO] [::] [] set EmailConfig smtpserver to eusmtp.bp.com (was not previously set in new installation)

      [02 Jan 2013 12:13:00,534] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_template to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_template

      [02 Jan 2013 12:13:00,534] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _template

      [02 Jan 2013 12:13:00,534] [main] [INFO] [::] [] Updating default deployment

      [02 Jan 2013 12:13:01,252] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor (was jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor in new installation)

      [02 Jan 2013 12:13:01,268] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

      [02 Jan 2013 12:13:01,283] [main] [INFO] [::] [] set Database Password to NKTTZOBVOXQULVEWAVTNUKTXZNEEATQEOWEWMABAPWOTWBBPVQXKUQBUAOZNNVTV (was MQWBWQPEVKEMUZZZKVUXUVMEXKLAOMZKPAUNOMKMUMQLBWNTTMZAUTENKZQELTPP in new installation)

      [02 Jan 2013 12:13:01,283] [main] [INFO] [::] [] set Database UserId to bladelogic (was bladelogic in new installation)

      [02 Jan 2013 12:13:01,970] [main] [INFO] [::] [] set Database Password to NKTTZOBVOXQULVEWAVTNUKTXZNEEATQEOWEWMABAPWOTWBBPVQXKUQBUAOZNNVTV (was UAAVKQZOZZEOQOPWEEAAQAWBWOTLVBEZQXKZWAWOXOXAPLOEEOPNQOOPEUTOTTXQ in new installation)

      [02 Jan 2013 12:13:02,094] [main] [INFO] [::] [] set AuthServer IsDomainAuthEnabled to true (was false in new installation)

      [02 Jan 2013 12:13:02,391] [main] [INFO] [::] [] set Logging ConsoleLogfileName to console.log (was not previously set in new installation)

      [02 Jan 2013 12:13:03,077] [main] [INFO] [::] [] set AppServer AppServerName to bp1lcsap073 (was default in new installation)

      [02 Jan 2013 12:13:03,124] [main] [INFO] [::] [] set AppServer CertPasswd to MAWKZKLWBUXUEKQUQUZBMNQNWALTXTQLLVVVOXOMTWLPXVATBZMZKEXTOXTOTZAK (was BEQOKNLMZBXTEUENQEPBWZZTZUKTZTTZBLLTMPUVPNVPXOVTBNPVZLMEOZEUQVLA in new installation)

      [02 Jan 2013 12:13:03,155] [main] [INFO] [::] [] set AppServer DisplayName to BP1LCSAP073 (was default in new installation)

      [02 Jan 2013 12:13:03,374] [main] [INFO] [::] [] set AppServer ProxySvcPort to 9842 (was 0 in new installation)

      [02 Jan 2013 12:13:04,325] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\default to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\default

      [02 Jan 2013 12:13:04,341] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment default

      [02 Jan 2013 12:13:04,341] [main] [INFO] [::] [] Updating _spawner deployment

      [02 Jan 2013 12:13:04,778] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor (was jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor in new installation)

      [02 Jan 2013 12:13:04,778] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

      [02 Jan 2013 12:13:04,793] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was MQWBWQPEVKEMUZZZKVUXUVMEXKLAOMZKPAUNOMKMUMQLBWNTTMZAUTENKZQELTPP in new installation)

      [02 Jan 2013 12:13:04,809] [main] [INFO] [::] [] set Database UserId to bladelogic (was bladelogic in new installation)

      [02 Jan 2013 12:13:05,355] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was VUVKTQQVVXLLUOAAZVKKQEXMQNNKXOZWTTPXAOLTATBQKATQMVMVVKWNZKZLNNPQ in new installation)

      [02 Jan 2013 12:13:05,760] [main] [INFO] [::] [] set ManagementService JMXManagementPort to 0 (was 9838 in new installation)

      [02 Jan 2013 12:13:06,119] [main] [INFO] [::] [] set AppServer CertPasswd to MAWKZKLWBUXUEKQUQUZBMNQNWALTXTQLLVVVOXOMTWLPXVATBZMZKEXTOXTOTZAK (was BEQOKNLMZBXTEUENQEPBWZZTZUKTZTTZBLLTMPUVPNVPXOVTBNPVZLMEOZEUQVLA in new installation)

      [02 Jan 2013 12:13:06,244] [main] [INFO] [::] [] set AppServer MaxPort to 9799 (was 9899 in new installation)

      [02 Jan 2013 12:13:06,275] [main] [INFO] [::] [] set AppServer MinPort to 9750 (was 9799 in new installation)

      [02 Jan 2013 12:13:06,306] [main] [INFO] [::] [] set AppServer RegistryPort to 1067 (was 9836 in new installation)

      [02 Jan 2013 12:13:06,915] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_spawner to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_spawner

      [02 Jan 2013 12:13:06,915] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _spawner

      [02 Jan 2013 12:13:06,915] [main] [INFO] [::] [] Updating _util deployment

      [02 Jan 2013 12:13:07,352] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor (was jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor in new installation)

      [02 Jan 2013 12:13:07,367] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

      [02 Jan 2013 12:13:07,383] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was MQWBWQPEVKEMUZZZKVUXUVMEXKLAOMZKPAUNOMKMUMQLBWNTTMZAUTENKZQELTPP in new installation)

      [02 Jan 2013 12:13:07,383] [main] [INFO] [::] [] set Database UserId to bladelogic (was bladelogic in new installation)

      [02 Jan 2013 12:13:07,820] [main] [INFO] [::] [] set Database Password to LEVXKWUWMLPTAKALUNXOKUTWTLAPAZMPZXTZONMLWAVUZVTAVBNUMBZWTNLWNLMP (was TOEEMTATUXNAAUZVLUAVKUAPVUAUTWKQWNWWWXVZKMVQXTXMMLMPEMQOZZXLLPAX in new installation)

      [02 Jan 2013 12:13:08,225] [main] [INFO] [::] [] set Logging ConsoleLogfileName to _util_console.log (was not previously set in new installation)

      [02 Jan 2013 12:13:08,225] [main] [INFO] [::] [] set Logging LogfileName to _util.log (was not previously set in new installation)

      [02 Jan 2013 12:13:08,584] [main] [INFO] [::] [] set AppServer CertPasswd to MAWKZKLWBUXUEKQUQUZBMNQNWALTXTQLLVVVOXOMTWLPXVATBZMZKEXTOXTOTZAK (was BEQOKNLMZBXTEUENQEPBWZZTZUKTZTTZBLLTMPUVPNVPXOVTBNPVZLMEOZEUQVLA in new installation)

      [02 Jan 2013 12:13:08,709] [main] [INFO] [::] [] set AppServer MaxPort to 9799 (was 9899 in new installation)

      [02 Jan 2013 12:13:08,740] [main] [INFO] [::] [] set AppServer MinPort to 9750 (was 9799 in new installation)

      [02 Jan 2013 12:13:09,598] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_util to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_util

      [02 Jan 2013 12:13:09,598] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _util

      [02 Jan 2013 12:13:09,754] [main] [INFO] [::] [] Deployment upgrades completed successfully.

      [02 Jan 2013 12:13:09,754] [Thread-1] [INFO] [::] [] Undeploying

      [02 Jan 2013 12:13:09,754] [Thread-1] [INFO] [::] [] Stopping Model Graph Service...

      [02 Jan 2013 12:13:09,754] [Thread-1] [INFO] [::] [] Model Graph Service stopped.

      [12 Dec 2013 16:41:09,300] [main] [INFO] [::] [] Starting Model Graph Service...

      [12 Dec 2013 16:41:11,357] [main] [INFO] [::] [] Model Graph Service started.

      [12 Dec 2013 16:41:11,358] [main] [INFO] [::] [] Registering remote services...

      [12 Dec 2013 16:41:11,360] [main] [INFO] [::] [] Remote services registered.

      [12 Dec 2013 16:41:11,360] [main] [INFO] [::] [] Performing post-deployment operations...

      [12 Dec 2013 16:41:11,360] [main] [INFO] [::] [] Post-deployment operations completed.

      [12 Dec 2013 16:41:11,360] [main] [INFO] [::] [] Performing post-startup deployment operations...

      [12 Dec 2013 16:41:11,361] [main] [INFO] [::] [] Post-startup deployment operations complete.

      [12 Dec 2013 16:41:11,369] [main] [INFO] [::] [] Updating _launcher deployment

      [12 Dec 2013 16:41:11,399] [main] [INFO] [::] [] set AppServerLauncher KeyStorePassword to EPULZXZXQPLKOZWKPELZULBXEWMNWAKTUALVZWEXXTQBVXMZQXALPVMVVUXQQXXX (was ALNXLTUPZUWLMKUOXQKZUVOZKNXQEQVLKXPOEKOKNEEKLVTQPXNNLOAQPMKMVUQN in new installation)

      [12 Dec 2013 16:41:11,406] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_launcher to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_launcher

      [12 Dec 2013 16:41:11,409] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _launcher

      [12 Dec 2013 16:41:11,410] [main] [INFO] [::] [] Copying AppServerLauncher-users.conf from D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_old\_launcher to D:\Program Files\BMC Software\BladeLogic\NSH\br\deployments\_launcher

      [12 Dec 2013 16:41:11,419] [main] [INFO] [::] [] Updated AppServerLauncher-users.conf for deployment _launcher

      [12 Dec 2013 16:41:11,533] [main] [INFO] [::] [] Updating _template deployment

      [12 Dec 2013 16:41:11,566] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogic;SelectMethod=cursor (was not previously set in new installation)

      [12 Dec 2013 16:41:11,582] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was not previously set in new installation)

      [12 Dec 2013 16:41:11,603] [main] [INFO] [::] [] set Database Password to MQWBWQPEVKEMUZZZKVUXUVMEXKLAOMZKPAUNOMKMUMQLBWNTTMZAUTENKZQELTPP (was not previously set in new installation)

      [12 Dec 2013 16:41:11,622] [main] [INFO] [::] [] set Database UserId to bladelogic (was not previously set in new installation)

      [12 Dec 2013 16:41:12,288] [main] [ERROR] [::] [] Failed to update deployments

      com.bladelogic.om.infra.app.bladmin.StorageException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'.

        at com.bladelogic.om.infra.app.bladmin.DbStorage.setUpJdbcConnection(DbStorage.java:138)

        at com.bladelogic.om.infra.app.bladmin.DbStorage.retrieveOptionValue(DbStorage.java:182)

        at com.bladelogic.om.infra.app.bladmin.BlAdminProcessor.retrieveOptionValueFromModule(BlAdminProcessor.java:465)

        at com.bladelogic.om.infra.app.bladmin.BlAdminProcessor.getOptionValue(BlAdminProcessor.java:1333)

        at com.bladelogic.om.infra.app.bladmin.BlAdminProcessor.getOptionValue(BlAdminProcessor.java:1320)

        at com.bladelogic.om.infra.app.configuration.migration.DeploymentXMLMigrator.updateModule(DeploymentXMLMigrator.java:387)

        at com.bladelogic.om.infra.app.configuration.migration.DeploymentXMLMigrator.updateOptions(DeploymentXMLMigrator.java:342)

        at com.bladelogic.om.infra.app.configuration.migration.DeploymentXMLMigrator.updateInstallerDeployment(DeploymentXMLMigrator.java:154)

        at com.bladelogic.om.infra.app.configuration.migration.DeploymentXMLMigrator.main(DeploymentXMLMigrator.java:125)

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'.

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

        at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)

        at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)

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

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

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)

        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at com.bladelogic.om.infra.app.bladmin.DbStorage.setUpJdbcConnection(DbStorage.java:130)

        ... 8 more

      [12 Dec 2013 16:41:12,296] [Thread-0] [INFO] [::] [] Undeploying

      [12 Dec 2013 16:41:12,298] [Thread-0] [INFO] [::] [] Stopping Model Graph Service...

      [12 Dec 2013 16:41:12,299] [Thread-0] [INFO] [::] [] Model Graph Service stopped.

        • 2. Re: BBSA 8.3 upgrade is failing
          John O'Toole

          Hi,

           

          It looks like your DB information may have changed at some point but the _template deployment was not updated with the new info. This did not cause any problem until this step of the upgrade tried to use it and failed with the following;

           

          [12 Dec 2013 16:41:11,533] [main] [INFO] [::] [] Updating _template deployment

          ..

          ..

          [12 Dec 2013 16:41:12,288] [main] [ERROR] [::] [] Failed to update deployments

          com.bladelogic.om.infra.app.bladmin.StorageException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'.

           

          We have a KA for this situation:

           

          https://kb.bmc.com/infocenter/index?page=content&id=KA346236

           

          However, the set of steps can be a little tricky. In this case, step 3 would involve fixing the _template db password:

           

          blasadmin -s _template set database password newpass

           

          I would recommend you open a ticket on this one. Reply here with the ticket number and I'll assist the person assigned in getting this straightened out.

           

          We don't want to try to start and use the appservers until this is fixed. Even if they did start, you would get unpredictable errors when trying to use the product.

           

          John

          • 3. Re: BBSA 8.3 upgrade is failing

            Thanks John, This is upgrade on our LAB instance. we are planning upgrade our PRD instance.

             

            Regards

            • 4. Re: BBSA 8.3 upgrade is failing
              John O'Toole

              In Prod, I would check the DB information is correct across all deployments on each physical appserver by running the following from the NSH/br directory on each appserver:

               

              ./blasadmin -a show file all

              ./blasadmin -s _template show file all

              ./blasadmin -s _spawner show file all

              ./blasadmin -s _pxe show file all

              ./blasadmin -s _postmig show file all

               

              The last two might not exist which is ok.

               

              The others should return your fileserver information e.g.

               

              [FileServer]

              location:/opt/bmc/bladelogic/NSH/br/storage/

              name:fileserver.bladelogic.com


              The reason we run this is that, to capture the fileserver information, it connects to the DB so, if there is a DB connectivity problem for any of the deployments, this will find it and we can fix it before the upgrade.

               

              If you put in a ticket for the LAB issue let me know and I'll assist - its probably too much to try to fix up over this forum. (not that much work but the steps are a little picky)