Just wondering if someone else has come across a similar issue while upgrading versions of service desk before and may know where I may be going wrong.
For a bit of background...
We're currently using Service Desk v7.6 along with a MS SQL database and are looking to upgrade to v7.7.3. Have downloaded the relevant install media, am following the 773 upgrade document and currently trying to upgrade a development environment as a PoC before looking to upgrade our production environment.
I've run the setup successfully over both the application and web servers as per the documentation, however when it comes to the database upgrade it fails stating that nulls cannot be inserted into pr_title as below.
Firstly I restored the DB, had a look at the column in question and spotted that it is set to accept null values.
I then searched through the MetadataManagerLog.xml as the message states and came across the SQL executed just before the error occurs, which shows that the comlumn is set to not accept null values.
I haven't seen anything that says I need to upgrade to v7.6.1 or similar first before moving onto v7.7.3. Does anyone know if there is an upgrade path I need to follow before or should I be able to upgrade straight to the target version.
Any help would be greatly appreciated!