10 Replies Latest reply on Jan 16, 2014 7:50 AM by Moses Arockiadass

    Query on Postmigration.exe during the upgrade (8.2 to 8.3)

      Experts,

       

      Should the below be the steps for a postmigration task during the appserver upgrade?

       

      RSCD agent service is be running.

      Appserver service is stopped. (as a part of upgrade process)

      Login to appserver with domain user credentials (User which is having RBAC permissions)

      Run postmigration.exe



      Pls let me know


      Also do let me know if this steps should be followed on the secondary appserver as well?


      Thanks.


      Note: I am upgrading our LAB instance of appserver.

      Current Version: 8.2.01.328

        • 1. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)
          Bill Robinson

          it doesn't matter what user creds you login w/ here, as long as they are an administrator on the box, and you probably want to use the 'run as administrator' unless you are logged in as the actual 'Administrator' account to open the command window to run the postmigration.

           

          you only need to run the postmigration once per bsa installation. so you don't need to run it on the other appserver.

          • 2. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)

            Thanks Bill, it's clear now, No need to run the postmigration on secondary appserver.

            • 3. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)

              Bill,

               

              I was running postmigration.ext as administrator (ACCOUNT on the server) but that was not having any RBAC permissions.

               

              Please find the error from postmigration.log file:

               

              [16 Dec 2013 12:39:59,725] [main] [INFO] [::] [] Starting Configuration Service...

              [16 Dec 2013 12:39:59,769] [main] [INFO] [::] [] Configuration Service started.

              [16 Dec 2013 12:39:59,821] [main] [INFO] [::] [] Loading JNI libaries...

              [16 Dec 2013 12:39:59,837] [main] [INFO] [::] [] Loaded JNI library BlAsJni

              [16 Dec 2013 12:39:59,839] [main] [INFO] [::] [] Loaded JNI library XJNIService

              [16 Dec 2013 12:39:59,840] [main] [INFO] [::] [] Loaded JNI library Atrium Core

              [16 Dec 2013 12:39:59,840] [main] [INFO] [::] [] Initializing JNI Configuration...

              [16 Dec 2013 12:39:59,844] [main] [INFO] [::] [] Initialized JNI library BlAsJni

              [16 Dec 2013 12:39:59,876] [main] [INFO] [::] [] Initialized JNI library XJNIService

              [16 Dec 2013 12:39:59,877] [main] [INFO] [::] [] Initialized JNI library Atrium Core

              [16 Dec 2013 12:39:59,877] [main] [INFO] [::] [] JNI Configuration complete.

              [16 Dec 2013 12:39:59,966] [main] [INFO] [::] [] Starting Model Graph Service...

              [16 Dec 2013 12:40:01,870] [main] [INFO] [::] [] Model Graph Service started.

              [16 Dec 2013 12:40:01,887] [main] [INFO] [::] [] Starting Port Provider...

              [16 Dec 2013 12:40:01,887] [main] [INFO] [::] [] Port Provider started.

              [16 Dec 2013 12:40:01,910] [main] [INFO] [::] [] Starting Sizing Service...

              [16 Dec 2013 12:40:01,911] [main] [INFO] [::] [] Sizing Service started.

              [16 Dec 2013 12:40:01,913] [main] [INFO] [::] [] Starting Caching Service...

              [16 Dec 2013 12:40:01,915] [main] [INFO] [::] [] Caching Service started.

              [16 Dec 2013 12:40:01,918] [main] [INFO] [::] [] Starting Session Service...

              [16 Dec 2013 12:40:01,929] [main] [INFO] [::] [] Session Service started.

              [16 Dec 2013 12:40:01,937] [main] [INFO] [::] [] Starting Task Scheduling Service...

              [16 Dec 2013 12:40:01,943] [main] [INFO] [::] [] Task Scheduling Service started.

              [16 Dec 2013 12:40:01,947] [main] [INFO] [::] [] Starting Directory Service...

              [16 Dec 2013 12:40:01,958] [main] [INFO] [::] [] Starting RMI registry on host: PRIMARYAPPSERVER

              [16 Dec 2013 12:40:01,972] [main] [INFO] [::] [] Directory Service started.

              [16 Dec 2013 12:40:01,974] [main] [INFO] [::] [] Setting client socket factory: com.bladelogic.om.infra.app.service.client.OMClientSocketFactory

              [16 Dec 2013 12:40:01,975] [main] [INFO] [::] [] Setting server socket factory: com.bladelogic.om.infra.app.service.client.ServerSocketFactory

              [16 Dec 2013 12:40:01,975] [main] [INFO] [::] [] Setting authenticator: com.bladelogic.om.infra.app.service.manage.auth.BlSessionServerAuthenticator

              [16 Dec 2013 12:40:01,976] [main] [INFO] [::] [] Starting Management Service ...

              [16 Dec 2013 12:40:02,209] [main] [INFO] [::] [] Management Service started.

              [16 Dec 2013 12:40:02,214] [main] [INFO] [::] [] Starting App Server Data Source...

              [16 Dec 2013 12:40:02,351] [main] [INFO] [::] [] Initialized connection pool General-Connection-Pool with url = jdbc:sqlserver://BP1LCSAP101:1433;DatabaseName=bladelogic;SelectMethod=cursor and user = bladelogic

              [16 Dec 2013 12:40:02,371] [main] [INFO] [::] [] Initialized connection pool Job-Connection-Pool with url = jdbc:sqlserver://BP1LCSAP101:1433;DatabaseName=bladelogic;SelectMethod=cursor and user = bladelogic

              [16 Dec 2013 12:40:02,390] [main] [INFO] [::] [] Initialized connection pool Client-Connection-Pool with url = jdbc:sqlserver://BP1LCSAP101:1433;DatabaseName=bladelogic;SelectMethod=cursor and user = bladelogic

              [16 Dec 2013 12:40:02,391] [main] [INFO] [::] [] App Server Data Source started.

              [16 Dec 2013 12:40:02,421] [main] [INFO] [::] [] Starting Database Service...

              [16 Dec 2013 12:40:02,439] [main] [INFO] [::] [] Loaded D:/Program Files/BMC Software/BladeLogic/NSH/br/deployments/_postmig/sql/sqlmap.properties

              [16 Dec 2013 12:40:02,477] [main] [INFO] [::] [] Loaded D:/Program Files/BMC Software/BladeLogic/NSH/br/deployments/_postmig/sql/streamable_sqlmap.properties

              [16 Dec 2013 12:40:02,478] [main] [INFO] [::] [] Database service loaded 2 mapping files.

              [16 Dec 2013 12:40:02,479] [main] [INFO] [::] [] Database Service started.

              [16 Dec 2013 12:40:02,595] [main] [INFO] [::] [] Starting App Server Service...

              [16 Dec 2013 12:40:02,755] [main] [INFO] [::] [] Server: _postmig; id: 6; RMI Port: 9836

              [16 Dec 2013 12:40:02,770] [main] [INFO] [::] [] App Server Service started.

              [16 Dec 2013 12:40:02,771] [main] [INFO] [::] [] Starting SRP Authentication Service...

              [16 Dec 2013 12:40:02,784] [main] [INFO] [::] [] SRP Authentication Service started.

              [16 Dec 2013 12:40:02,785] [main] [INFO] [::] [] Verifying object deleters...

              [16 Dec 2013 12:40:02,790] [main] [INFO] [::] [] Object deleters verified.

              [16 Dec 2013 12:40:02,790] [main] [INFO] [::] [] Verifying object soft deleters...

              [16 Dec 2013 12:40:02,805] [main] [INFO] [::] [] Object soft deleters verified.

              [16 Dec 2013 12:40:02,806] [main] [INFO] [::] [] Starting Notification Service...

              [16 Dec 2013 12:40:02,813] [main] [INFO] [::] [] Notification Service started.

              [16 Dec 2013 12:40:02,816] [main] [INFO] [::] [] Starting Event Service...

              [16 Dec 2013 12:40:02,826] [Event-Processor-Thread-0] [INFO] [::] [] Event processor thread started.

              [16 Dec 2013 12:40:02,828] [Event-Processor-Thread-4] [INFO] [::] [] Event processor thread started.

              [16 Dec 2013 12:40:02,827] [Event-Processor-Thread-3] [INFO] [::] [] Event processor thread started.

              [16 Dec 2013 12:40:02,826] [Event-Processor-Thread-2] [INFO] [::] [] Event processor thread started.

              [16 Dec 2013 12:40:02,826] [Event-Processor-Thread-1] [INFO] [::] [] Event processor thread started.

              [16 Dec 2013 12:40:02,832] [Event-Transfer-Thread-0] [INFO] [::] [] Event transfer thread started.

              [16 Dec 2013 12:40:02,832] [Event-Transfer-Thread-1] [INFO] [::] [] Event transfer thread started.

              [16 Dec 2013 12:40:02,832] [Event-Transfer-Thread-2] [INFO] [::] [] Event transfer thread started.

              [16 Dec 2013 12:40:02,834] [main] [INFO] [::] [] Event Service started.

              [16 Dec 2013 12:40:02,833] [Event-Transfer-Thread-3] [INFO] [::] [] Event transfer thread started.

              [16 Dec 2013 12:40:02,833] [Event-Transfer-Thread-4] [INFO] [::] [] Event transfer thread started.

              [16 Dec 2013 12:40:02,835] [main] [INFO] [::] [] Starting RBAC User Service...

              [16 Dec 2013 12:40:02,834] [Event-Dispatcher-Thread] [INFO] [::] [] Event dispatcher thread started.

              [16 Dec 2013 12:40:02,836] [main] [INFO] [::] [] RBAC User Service started.

              [16 Dec 2013 12:40:02,837] [main] [INFO] [::] [] Starting RBAC Role Service...

              [16 Dec 2013 12:40:02,838] [main] [INFO] [::] [] RBAC Role Service started.

              [16 Dec 2013 12:40:02,841] [main] [INFO] [::] [] Starting Schedule Service...

              [16 Dec 2013 12:40:02,841] [main] [INFO] [::] [] Schedule Service started.

              [16 Dec 2013 12:40:02,841] [main] [INFO] [::] [] Starting RBAC Service...

              [16 Dec 2013 12:40:02,842] [main] [INFO] [::] [] Registering Security checkers...

              [16 Dec 2013 12:40:02,845] [main] [INFO] [::] [] Security checkers registered.

              [16 Dec 2013 12:40:02,845] [main] [INFO] [::] [] RBAC Service started.

              [16 Dec 2013 12:40:02,846] [main] [INFO] [::] [] Starting Job Schedule Approval Service...

              [16 Dec 2013 12:40:02,855] [Approval-1] [INFO] [::] [] Approval processor thread started.

              [16 Dec 2013 12:40:02,855] [Approval-2] [INFO] [::] [] Approval processor thread started.

              [16 Dec 2013 12:40:02,855] [Approval-0] [INFO] [::] [] Approval processor thread started.

              [16 Dec 2013 12:40:02,858] [main] [INFO] [::] [] Starting File Manager Service...

              [16 Dec 2013 12:40:02,869] [main] [INFO] [::] [] Validating file server host (PRIMARYAPPSERVER)...

              [16 Dec 2013 12:40:05,020] [main] [INFO] [::] [] Validating file server path (//PRIMARYAPPSERVER/E/File_Server_OAT/)...

              [16 Dec 2013 12:40:05,023] [main] [INFO] [::] [] Cleaning up application server temp directory: D:/Program Files/BMC Software/BladeLogic/NSH/tmp/application_server

              [16 Dec 2013 12:40:05,032] [main] [INFO] [::] [] Cleaning up file server temp directory: //PRIMARYAPPSERVER/E/File_Server_OAT/tmp/_postmig

              [16 Dec 2013 12:40:05,034] [main] [INFO] [::] [] Cleaning up temp zip files in: D:\Program Files\BMC Software\BladeLogic\NSH\bin

              [16 Dec 2013 12:40:05,045] [main] [INFO] [::] [] File Manager Service started.

              [16 Dec 2013 12:40:05,047] [main] [INFO] [::] [] Registering remote services...

              [16 Dec 2013 12:40:05,111] [main] [INFO] [::] [] Remote services registered.

              [16 Dec 2013 12:40:05,146] [main] [INFO] [::] [] Registering mbean services...

              [16 Dec 2013 12:40:05,178] [main] [INFO] [::] [] MBean services registered.

              [16 Dec 2013 12:40:05,179] [main] [INFO] [::] [] Performing post-deployment operations...

              [16 Dec 2013 12:40:05,179] [main] [INFO] [::] [] Post-deployment operations completed.

              [16 Dec 2013 12:40:05,180] [main] [INFO] [::] [] Performing post-startup deployment operations...

              [16 Dec 2013 12:40:05,185] [main] [INFO] [::] [] Initializing Advanced File Server support...

              [16 Dec 2013 12:40:05,186] [main] [INFO] [::] [] Advanced File Server support initialized.

              [16 Dec 2013 12:40:05,190] [main] [INFO] [::] [] Post-startup deployment operations complete.

              [16 Dec 2013 12:40:25,195] [main] [INFO] [::] [] Starting post migration process...

              [16 Dec 2013 12:40:26,523] [main] [INFO] [::] [] The Post Migration process was already executed successfully.

              [16 Dec 2013 12:40:26,524] [main] [INFO] [::] [] Post migration process completed.

              [16 Dec 2013 12:40:26,525] [main] [INFO] [::] [] Starting the Post Migration for Updating the SmartGroups

              [16 Dec 2013 12:40:26,529] [main] [INFO] [::] [] The Post Migration process will upgrade the Smart Group in the installation.

              [16 Dec 2013 12:40:27,716] [main] [WARN] [::] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:27,719] [main] [ERROR] [::] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,043] [main] [WARN] [System:BLAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,045] [main] [ERROR] [System:BLAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,136] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,137] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,220] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,222] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,310] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,313] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,429] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,430] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,564] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,566] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getStatement(SQLServerResultSet.java:4263)

                at com.bladelogic.om.infra.shared.db.BlResultSetImpl.getStatement(BlResultSetImpl.java:493)

                at com.bladelogic.om.infra.shared.db.BlDbConnection.releaseOpenResultSets(BlDbConnection.java:420)

                at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.verifyThreadConnectionsReturned(DefaultDatabaseServiceImpl.java:2039)

                at com.bladelogic.om.infra.app.service.session.SessionImpl.cleanup(SessionImpl.java:311)

                at com.bladelogic.om.infra.app.service.session.SessionServiceImpl.removeCurrentSession(SessionServiceImpl.java:324)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.switchToRequiredRoleSession(SmartGroupUtil.java:218)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:153)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.updateSmartGroupQuery(SmartGroupUtil.java:85)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupUtil.migrateAllSmartGroups(SmartGroupUtil.java:40)

                at com.bladelogic.om.infra.model.group.smartgroup.SmartGroupServiceImpl.updateAllSmartGroupQueries(SmartGroupServiceImpl.java:536)

                at com.bladelogic.om.infra.app.service.migration.SmartGroupMigration.migrateAll(SmartGroupMigration.java:71)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.doPostMigration(PostMigration.java:84)

                at com.bladelogic.om.infra.app.service.migration.PostMigration.main(PostMigration.java:40)

              [16 Dec 2013 12:40:28,713] [main] [WARN] [System:RBACAdmins:127.0.0.1] [] User session did not properly release a database connection.

              [16 Dec 2013 12:40:28,714] [main] [ERROR] [System:RBACAdmins:127.0.0.1] [] The result set is closed.

              com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:345)

              • 4. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)
                Bill Robinson

                what do you mean by 'login as a domain user that has rbac permission' ?  when you come in from the OS perspective, there's no association in that direction w/ bsa/rbac...

                 

                i think those messages can be ignored - but you may want to open a support ticket to be sure.

                • 5. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)

                  OK, We have logged to appserver with local admin account and not domain user as this error was reflecting for all the RBAC ROLES we have defined in BSA. I was under an impression that the user which loggin to appserver should be a domain user and also have admin priveleges on the server.

                   

                  Regards

                  • 6. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)
                    Bill Robinson

                    I’m not sure what you mean by ‘this error was reflecting for all the RBAC ROLES we have defined in BSA’ ?

                    • 7. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)

                      Bill,

                       

                      Sorry for not making things clear:

                       

                      1. I have executed the postmigration.exe with local admin account (run as administrator) which is not a part of BLAdmins Role I got the errors which I have posted earlier.

                       

                      2. I have executed the  postmigration.exe with NT account (run as administrator) which is also a part of BLAdmins Role I did not receive these errors which I have posted earlier.

                       

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


                      "this error was reflecting for all the RBAC ROLES we have defined in BSA"


                      We have defined RBAC roles in our environment like PACKAGEROLE, DEPLOYROLE, AUDITROLE, as it is with BLAdmins and RBACAdmins.


                      Please let me know If it's not clear and If my understanding correct.


                      Regards


                      • 8. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)
                        Bill Robinson

                        i'm still not sure what you mean by 'NT accout whic his also part of BLAdmins'.   there is no relationship between an OS user and a BSA role in the context of the OS...

                        • 9. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)
                          John O'Toole

                          Are you still having this problem? It looks like it detected that the main work done by this tool was done already - probably if and when you upgraded from 7.6 at some point:

                           

                          [16 Dec 2013 12:40:25,195] [main] [INFO] [::] [] Starting post migration process...

                          [16 Dec 2013 12:40:26,523] [main] [INFO] [::] [] The Post Migration process was already executed successfully.

                          [16 Dec 2013 12:40:26,524] [main] [INFO] [::] [] Post migration process completed.

                           

                          There is then some new work to be done by this tool around smartgroup conditions and thats when you are hitting this which looks more an issue with DB connections than a user-permission issue:

                           

                          [16 Dec 2013 12:40:26,525] [main] [INFO] [::] [] Starting the Post Migration for Updating the SmartGroups

                          [16 Dec 2013 12:40:26,529] [main] [INFO] [::] [] The Post Migration process will upgrade the Smart Group in the installation.

                          [16 Dec 2013 12:40:27,716] [main] [WARN] [::] [] User session did not properly release a database connection.

                          [16 Dec 2013 12:40:27,719] [main] [ERROR] [::] [] The result set is closed.

                           

                          Can you run the following commands from the NSH\br or NSH\bin dir on that appserver. I want to see what the db info for the postmig deployment looks like:

                           

                          blasadmin -s _postmig show database all

                           

                          blasadmin -s _postmig show file all

                           

                          Thanks,

                           

                          John

                          • 10. Re: Query on Postmigration.exe during the upgrade (8.2 to 8.3)

                            John,

                             

                             

                            Please find below the output,

                             

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

                            D:\Program Files\BMC Software\BladeLogic\NSH\br>blasadmin -s _postmig show database all

                            blasadmin now running against deployment: _postmig

                            [Database]

                            AutoBatchEnabled:true

                            ConnectionString:jdbc:sqlserver://SERVERNAME:1433;DatabaseName=bladelogicdatabase;Selec

                            tMethod=cursor

                            DatabaseInstrumentationFilePath:

                            DatabaseInstrumentationRolloverCount:10

                            DatabaseInstrumentationRolloverSize:10000

                            DatabaseVersion:8.3.00

                            DriverClass:com.microsoft.sqlserver.jdbc.SQLServerDriver

                            FetchSize:100

                            IdleConnectionTestPeriod:600

                            MaxClientConnections:100

                            MaxGeneralConnections:100

                            MaxIdleTime:600

                            MaxJobExecutionConnections:100

                            MaxWaitTime:

                            MinClientConnections:0

                            MinGeneralConnections:0

                            MinJobExecutionConnections:0

                            MinTimeToLog:0

                            Password:KWWXLLOPPTXAWXKMUBZNNWNLTXKWPPTQAVNQQLNUEKAPXVMBLQWNXMVXEPAXXNTO

                            SqlFiles:

                                sql/sqlmap.properties

                                sql/streamable_sqlmap.properties

                            TransactionAttempts:10

                            UserId:bladelogicuser

                             

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

                             

                             

                            Also is there any way to check if the post migration got completed successfully.

                            Regards