IBM Business Automation Community Come for answers. Stay for best practices. All we’re missing is you. Join / Log in Ask a question
After running through the normal process for upgrading the software, it is currently stuck trying to update the database schema. After opening the software in a browser window and clicking "Update Schema", the button text changes to "Updating ..." before showing an error message:
"Database error. A user's default schema must be set to 'dbo'. Currently, it is set to guest. Before you can use the database, change its default schema."
I have installed and previously updated the software without error or needing to change a users' default schema. I have rechecked the default schema of the user in question and can see it is being reported as 'dbo'.
To assist in determining what the error might be:
Again, previous versions of the software were installed and upgraded successfully without issue. I can uninstall the software, and I have a backup of the database. But if the issue is repeated it will prevent future upgrades of the software.
What is the version of ILMT?
Please follow the suggestions from this technote:
Thank you for the response.
Following the instructions on the provided link resolved the issue. In searching IBMs support again, taking out error message showed a result that indeed linked to the provided tech note.
Thank you for responding.
I was upgrading from 9.2.27 to 9.2.28 (having deferred it due to some resourcing issues). I assume my initial searching was too verbose when including part of the error message. I have noticed v9.2.29 of the tool has been release. Though will likely need to defer upgrading again (partly to hopefully see any issue being flushed out first).