Troubleshooting DBUpgradeTool
You may encounter issues during DBUT execution for database upgrade purposes.
- Execution is interrupted
-
If the DBUT suddenly dies, it results in a hanging database upgrade logged in to the database. All other attempts to upgrade will fail since only one upgrade process is permitted to run at a time.
To force an undo of a hanging update, execute DBUT then select and your current project.
-
Current user
isourcewarnings -
The following warnings can occur in DBUT:
WARNING: The current user "isource" does not have permission to disable the standard database job for InfoShare.WARNING: The current user "isource" does not have permission to install the standard database job for InfoShare. Ask a System Administrator to manually execute ISH_CreateStandardInfoShareJob.sql and ISH_EnableStandardInfoShareJob.Sql to create and enable the standard InfoShare job!WARNING: The current user "isource" does not have permission to enable the standard database job for InfoShare.
These warnings are returned when the user executing DBUT has not enough rights to access/create database jobs.- Creating a database job requires a database administrator to execute CD-Package\Database\InfoshareCM\Common\<SQLServerVersion>\Create\ISH_CreateStandardInfoShareJob.sql and
CD-Package\Database\InfoshareAM\Common\<SQLServerVersion>\Create\ISH_CreateStandardInfoShareJob.sql - Enabling a database job requires a database administrator to execute CD-Package\Database\InfoshareCM\Common\<SQLServerVersion>\Create\ISH_EnableStandardInfoShareJob.Sql and
CD-Package\Database\InfoshareAM\Common\<SQLServerVersion>\Create\ISH_EnableStandardInfoShareJob.Sql
- Requesting assistance
-
In case you need to request assistance, you need to provide the following information:
- A screenshot of the failed execution of DBUpgradeTool.
- The log file: \App\Setup\DBUpgradeTool\DBUpgradeTool.log