Environment
Service Desk 7 Upgrade
Situation
MFSD v7.4 with embedded database.
Start Service Desk migration.
Start Service Desk migration.
After step 5 where migration is successful and attempting to connect to the new server console.
An attempt to connect to the database Step 9 (version 7.4) but connection fails.
An attempt to connect to the database Step 9 (version 7.4) but connection fails.
Resolution
Verify the configuration in the hibernate.properties (database configuration).
File Location:
hibernate.connection.host=127.0.0.1
File Location:
MFSD v7.4 - /opt/novell/nsd/servicedesk/Server/webapps/LiveTime/WEB-INF/LiveTime.woa/Contents/Resources/hibernate.properties
MFSD v7.5 - /opt/novell/servicedesk/server/webapps/LiveTime/WEB-INF/LiveTime.woa/Contents/Resources/hibernate.properties
MFSD v7.5 - /opt/novell/servicedesk/server/webapps/LiveTime/WEB-INF/LiveTime.woa/Contents/Resources/hibernate.properties
Cause
MFSD Server holding the local database may be configured with the local IP address instead of local host address 127.0.0.1 (stored in the hibernate.properties file).
The system will function in normal conditions but fail will the migration.
The migration looks at this file and if the hibernate.connection.host configuration doesn't have 127.0.0.1 then the process presumes migration from an external database and fails to connect to the local database.
The system will function in normal conditions but fail will the migration.
The migration looks at this file and if the hibernate.connection.host configuration doesn't have 127.0.0.1 then the process presumes migration from an external database and fails to connect to the local database.
Additional Information
This may occur on MFSD Server with embedded database.
For MFSD v7.5 systems documented link Step 7 will fail.