Documentation Center

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 Maintenance > Terminate and your current project.

Current user isource warnings
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