6 Replies Latest reply on Jun 21, 2012 2:19 AM by Namita Jain

    Cannot decomission the server in BSA 8.2 SP1

      I have recently upgraded BSA 8.2 to SP1 and can't decommission the servers; getting the following error in last dialog box.

       

      no entry in mapping files for query with ID_Select_Latest_Components_key_by device_and_ignore_saved_explicitly.

       

      Any advice?

        • 1. Cannot decomission the server in BSA 8.2 SP1

          Namita,

          Are you getting this error while decommissioning the server or while trying to access the job logs for it? Do you see a similar error while checking any other job logs too? See this KB article: https://kb.bmc.com/infocenter/index?page=content&id=KA325887&actp=search&viewlocale=en_US&searchid=1339588705793

           

          This issue is known to happen when you have an outdated sqlmap.properites file in the deployments/[instance]/sql folder.

           

          Check the article and the solution too.

          Hope this helps.

          1 of 1 people found this helpful
          • 2. Cannot decomission the server in BSA 8.2 SP1

            Hi Prabhat,

             

            I am getting this error while decomissioning the server.

            My DB Migration and deployments were successful.

            Is sqlmap.properties file supposed to be upgraded while DB migration?

            In _spawner- last updated 22/3

            In _template - last updated 21/5

             

            I am not sure how do I fix it?

            • 3. Re: Cannot decomission the server in BSA 8.2 SP1
              Bill Robinson

              Can you attach/look at the deployment_upgrade.log ?

               

              An appserver upgrade should upgrade the sqlmap.properties.  yours may not have been updated properly.

              • 4. Re: Cannot decomission the server in BSA 8.2 SP1

                Hi Bill,

                Please find the attached deployment_upgrade.log.

                 

                *********************************************************************************************************

                [12 Jun 2012 03:28:23,901] [main] [INFO] [::] [] Starting Model Graph Service...

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Model Graph Service started.

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Registering remote services...

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Remote services registered.

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Performing post-deployment operations...

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Post-deployment operations completed.

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Performing post-startup deployment operations...

                [12 Jun 2012 03:28:26,647] [main] [INFO] [::] [] Post-startup deployment operations complete.

                [12 Jun 2012 03:28:26,662] [main] [INFO] [::] [] Updating _launcher deployment

                [12 Jun 2012 03:28:26,694] [main] [INFO] [::] [] set AppServerLauncher KeyStorePassword to ZXUNUBNEALZUWKLQMBTVVWZAUOOLETMVPWPVTKPXKNOPMNMBKAPEOOEVTWQUUBWE (was ALNXLTUPZUWLMKUOXQKZUVOZKNXQEQVLKXPOEKOKNEEKLVTQPXNNLOAQPMKMVUQN in new installation)

                [12 Jun 2012 03:28:26,694] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\BMC\BladeLogic\NSH\br\deployments\_old\_launcher to D:\BMC\BladeLogic\NSH\br\deployments\_launcher

                [12 Jun 2012 03:28:26,694] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _launcher

                [12 Jun 2012 03:28:26,694] [main] [INFO] [::] [] Copying AppServerLauncher-users.conf from D:\BMC\BladeLogic\NSH\br\deployments\_old\_launcher to D:\BMC\BladeLogic\NSH\br\deployments\_launcher

                [12 Jun 2012 03:28:26,694] [main] [INFO] [::] [] Updated AppServerLauncher-users.conf for deployment _launcher

                [12 Jun 2012 03:28:26,834] [main] [INFO] [::] [] Updating _template deployment

                [12 Jun 2012 03:28:26,881] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor (was not previously set in new installation)

                [12 Jun 2012 03:28:27,364] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was not previously set in new installation)

                [12 Jun 2012 03:28:27,380] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was not previously set in new installation)

                [12 Jun 2012 03:28:27,396] [main] [INFO] [::] [] set Database UserId to BLAdmin-SQL (was not previously set in new installation)

                [12 Jun 2012 03:28:29,564] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was PWBVNTPNOUOLVEKXKZPVAZVVMKPUQZVBEMWQQLNTTVAZETPVWEZOQAONMUPLTQWO in new installation)

                [12 Jun 2012 03:28:30,344] [main] [INFO] [::] [] Unable to find old value for Module: Logging Option: Logformat

                [12 Jun 2012 03:28:30,859] [main] [INFO] [::] [] set AppServer CertPasswd to LBKXQVVUPBXLMXTPTAOZXEWVNVUEWWNPEAAOBLKMOVBATXAUBKMQPTAELWUQAOUB (was ALNXLTUPZUWLMKUOXQKZUVOZKNXQEQVLKXPOEKOKNEEKLVTQPXNNLOAQPMKMVUQN in new installation)

                [12 Jun 2012 03:28:30,874] [main] [INFO] [::] [] set AppServer DefaultRestVersion to (was 8.1.02 in new installation)

                [12 Jun 2012 03:28:30,968] [main] [INFO] [::] [] set AppServer HTTPProxyPassword to NQMKMTZWWUMWAWXTPQZKWAVUVELWTMVETBTTLKMAVELPWLTUKZTMBUTWZAPMTKKM (was not previously set in new installation)

                [12 Jun 2012 03:28:31,093] [main] [INFO] [::] [] set AppServer RestAssetAttributesUseInternalNames to true (was false in new installation)

                [12 Jun 2012 03:28:31,202] [main] [INFO] [::] [] Unable to find old value for Module: SSHConnection Option: supportedCiphers

                [12 Jun 2012 03:28:32,512] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\BMC\BladeLogic\NSH\br\deployments\_old\_template to D:\BMC\BladeLogic\NSH\br\deployments\_template

                [12 Jun 2012 03:28:32,512] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _template

                [12 Jun 2012 03:28:32,528] [main] [INFO] [::] [] Updating default deployment

                [12 Jun 2012 03:28:33,012] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor (was jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor in new installation)

                [12 Jun 2012 03:28:33,012] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

                [12 Jun 2012 03:28:33,027] [main] [INFO] [::] [] set Database Password to OZUZWTALQXOUKEWTLUPNWPNXBOPEXTEMBZZMTAEAQEPTOAOMPEVBZMAKNBOBKZOO (was OTLXKKZXBPUBNWLOXXNPMPQLPUVBBVZVZNMALTAAEWNQXZUVOENUEUPVKKTZUXTW in new installation)

                [12 Jun 2012 03:28:33,043] [main] [INFO] [::] [] set Database UserId to BLAdmin-SQL (was BLAdmin-SQL in new installation)

                [12 Jun 2012 03:28:33,838] [main] [INFO] [::] [] set Database Password to OZUZWTALQXOUKEWTLUPNWPNXBOPEXTEMBZZMTAEAQEPTOAOMPEVBZMAKNBOBKZOO (was KUBBEVNQWXWQNWMVZZVONXTAQZUBUTZZQKBUOEKPEAUTKVTWMVTBWBOELXKUAMKO in new installation)

                [12 Jun 2012 03:28:33,885] [main] [INFO] [::] [] set AuthServer ActiveDirectoryLdapUrl to ldap://stdom001.gsp.accenture.com:389 (was not previously set in new installation)

                [12 Jun 2012 03:28:33,901] [main] [INFO] [::] [] set AuthServer ActiveDirectorySearchBase to DC=Users, DC=Administrative Environment, DC=GSP, DC=ACCENTURE, DC=COM (was not previously set in new installation)

                [12 Jun 2012 03:28:33,948] [main] [INFO] [::] [] set AuthServer IsActiveDirectoryLdapCheckEnabled to true (was false in new installation)

                [12 Jun 2012 03:28:33,948] [main] [INFO] [::] [] set AuthServer IsDomainAuthEnabled to true (was false in new installation)

                [12 Jun 2012 03:28:34,447] [main] [INFO] [::] [] set Logging ConsoleLogfileName to console.log (was not previously set in new installation)

                [12 Jun 2012 03:28:34,462] [main] [INFO] [::] [] Unable to find old value for Module: Logging Option: Logformat

                [12 Jun 2012 03:28:34,930] [main] [INFO] [::] [] set AppServer AppServerName to stbbl001 (was default in new installation)

                [12 Jun 2012 03:28:34,946] [main] [INFO] [::] [] set AppServer CertPasswd to LBKXQVVUPBXLMXTPTAOZXEWVNVUEWWNPEAAOBLKMOVBATXAUBKMQPTAELWUQAOUB (was NVXVPKZBZWBQKQWLBZKLWZQXULUUOATQVOOOTWNEKXMXXVAVOWEXQBKPNTPZALTN in new installation)

                [12 Jun 2012 03:28:34,977] [main] [INFO] [::] [] set AppServer DisplayName to STBBL001 (was default in new installation)

                [12 Jun 2012 03:28:35,040] [main] [INFO] [::] [] set AppServer HTTPProxyPassword to WXNAVQQZAZKTPKVZONWLQAUKQBMZAUZNWXWVZKLZZZZZMXOPMVLPNTXNBVUULNVA (was BZMZMVXANBUOTWBOUZOAATPVEPXAUVTLAXATEMAXKOEBLXXNWVPPWQPWENQXBEKN in new installation)

                [12 Jun 2012 03:28:35,227] [main] [INFO] [::] [] Unable to find old value for Module: SSHConnection Option: supportedCiphers

                [12 Jun 2012 03:28:35,258] [main] [INFO] [::] [] set EmailConfig fromaddress to bbsa.prod@accenture.com (was not previously set in new installation)

                [12 Jun 2012 03:28:35,289] [main] [INFO] [::] [] set EmailConfig smtpserver to AMR.SMTP.ACCENTURE.COM (was not previously set in new installation)

                [12 Jun 2012 03:28:36,381] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\BMC\BladeLogic\NSH\br\deployments\_old\default to D:\BMC\BladeLogic\NSH\br\deployments\default

                [12 Jun 2012 03:28:36,381] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment default

                [12 Jun 2012 03:28:36,381] [main] [INFO] [::] [] Updating _spawner deployment

                [12 Jun 2012 03:28:36,678] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor (was jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor in new installation)

                [12 Jun 2012 03:28:36,693] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

                [12 Jun 2012 03:28:36,693] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was OTLXKKZXBPUBNWLOXXNPMPQLPUVBBVZVZNMALTAAEWNQXZUVOENUEUPVKKTZUXTW in new installation)

                [12 Jun 2012 03:28:36,709] [main] [INFO] [::] [] set Database UserId to BLAdmin-SQL (was BLAdmin-SQL in new installation)

                [12 Jun 2012 03:28:37,224] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was VMKKPUWBUNVATVOVEPKVPKVOEKKUXLNLOOAWWXLWTBWNLQBOPUUWOQZLTWATOEAP in new installation)

                [12 Jun 2012 03:28:37,692] [main] [INFO] [::] [] Unable to find old value for Module: Logging Option: Logformat

                [12 Jun 2012 03:28:37,785] [main] [INFO] [::] [] set ManagementService JMXManagementPort to 0 (was 9838 in new installation)

                [12 Jun 2012 03:28:38,160] [main] [INFO] [::] [] set AppServer CertPasswd to LBKXQVVUPBXLMXTPTAOZXEWVNVUEWWNPEAAOBLKMOVBATXAUBKMQPTAELWUQAOUB (was NVXVPKZBZWBQKQWLBZKLWZQXULUUOATQVOOOTWNEKXMXXVAVOWEXQBKPNTPZALTN in new installation)

                [12 Jun 2012 03:28:38,206] [main] [INFO] [::] [] set AppServer HTTPProxyPassword to (was BZMZMVXANBUOTWBOUZOAATPVEPXAUVTLAXATEMAXKOEBLXXNWVPPWQPWENQXBEKN in new installation)

                [12 Jun 2012 03:28:38,269] [main] [INFO] [::] [] set AppServer MaxPort to 9799 (was 9899 in new installation)

                [12 Jun 2012 03:28:38,300] [main] [INFO] [::] [] set AppServer MinPort to 9750 (was 9799 in new installation)

                [12 Jun 2012 03:28:38,331] [main] [INFO] [::] [] set AppServer RegistryPort to 1067 (was 9836 in new installation)

                [12 Jun 2012 03:28:38,378] [main] [INFO] [::] [] Unable to find old value for Module: SSHConnection Option: supportedCiphers

                [12 Jun 2012 03:28:39,174] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\BMC\BladeLogic\NSH\br\deployments\_old\_spawner to D:\BMC\BladeLogic\NSH\br\deployments\_spawner

                [12 Jun 2012 03:28:39,174] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _spawner

                [12 Jun 2012 03:28:39,174] [main] [INFO] [::] [] Updating _util deployment

                [12 Jun 2012 03:28:39,470] [main] [INFO] [::] [] set Database ConnectionString to jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor (was jdbc:sqlserver://GSPBBL01\P01DBBBL:51116;DatabaseName=Bladelogic_db;SelectMethod=cursor in new installation)

                [12 Jun 2012 03:28:39,470] [main] [INFO] [::] [] set Database DriverClass to com.microsoft.sqlserver.jdbc.SQLServerDriver (was com.microsoft.sqlserver.jdbc.SQLServerDriver in new installation)

                [12 Jun 2012 03:28:39,486] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was OTLXKKZXBPUBNWLOXXNPMPQLPUVBBVZVZNMALTAAEWNQXZUVOENUEUPVKKTZUXTW in new installation)

                [12 Jun 2012 03:28:39,486] [main] [INFO] [::] [] set Database UserId to BLAdmin-SQL (was BLAdmin-SQL in new installation)

                [12 Jun 2012 03:28:40,000] [main] [INFO] [::] [] set Database Password to UWOLAQTNNKBPXZABNVMNKLQTNMEMPQTULNOQZQWBXWOUUZNLQKUZLXWMXPKELKPL (was WUKBBQBTLQKUQEAUBUBWOMTQKOBNEWPEAKONNAABEPUUQXOPVAVELZAAKPKUBZTQ in new installation)

                [12 Jun 2012 03:28:40,375] [main] [INFO] [::] [] set Logging ConsoleLogfileName to _util_console.log (was not previously set in new installation)

                [12 Jun 2012 03:28:40,375] [main] [INFO] [::] [] set Logging LogfileName to _util.log (was not previously set in new installation)

                [12 Jun 2012 03:28:40,375] [main] [INFO] [::] [] Unable to find old value for Module: Logging Option: Logformat

                [12 Jun 2012 03:28:40,765] [main] [INFO] [::] [] set AppServer CertPasswd to LBKXQVVUPBXLMXTPTAOZXEWVNVUEWWNPEAAOBLKMOVBATXAUBKMQPTAELWUQAOUB (was NVXVPKZBZWBQKQWLBZKLWZQXULUUOATQVOOOTWNEKXMXXVAVOWEXQBKPNTPZALTN in new installation)

                [12 Jun 2012 03:28:40,827] [main] [INFO] [::] [] set AppServer HTTPProxyPassword to (was BZMZMVXANBUOTWBOUZOAATPVEPXAUVTLAXATEMAXKOEBLXXNWVPPWQPWENQXBEKN in new installation)

                [12 Jun 2012 03:28:40,874] [main] [INFO] [::] [] set AppServer MaxPort to 9799 (was 9899 in new installation)

                [12 Jun 2012 03:28:40,921] [main] [INFO] [::] [] set AppServer MinPort to 9750 (was 9799 in new installation)

                [12 Jun 2012 03:28:40,968] [main] [INFO] [::] [] Unable to find old value for Module: SSHConnection Option: supportedCiphers

                [12 Jun 2012 03:28:41,826] [main] [INFO] [::] [] Copying bladelogic.keystore from D:\BMC\BladeLogic\NSH\br\deployments\_old\_util to D:\BMC\BladeLogic\NSH\br\deployments\_util

                [12 Jun 2012 03:28:41,826] [main] [INFO] [::] [] Updated bladelogic.keystore for deployment _util

                [12 Jun 2012 03:28:41,966] [main] [INFO] [::] [] Deployment upgrades completed successfully.

                [12 Jun 2012 03:28:41,966] [Thread-1] [INFO] [::] [] Undeploying

                [12 Jun 2012 03:28:41,966] [Thread-1] [INFO] [::] [] Stopping Model Graph Service...

                [12 Jun 2012 03:28:41,966] [Thread-1] [INFO] [::] [] Model Graph Service stopped.

                **********************************************************************************************************

                • 5. Re: Cannot decomission the server in BSA 8.2 SP1
                  Bill Robinson

                  that looks ok.  what is the md5sum of each of the sqlmap.properties file under NSH\br\deployments\*\sql ?

                  • 6. Re: Cannot decomission the server in BSA 8.2 SP1

                    Hi Bill,

                     

                    Issue is resolved.

                    There was a discrepancy between the md5sum of sqlmap.properties file from _tempalate and others.

                    We matched them and all is good now.

                    Thank you for your suggestions.

                     

                    Regards

                    Namita