Retain database schema update failure

  • 7023406
  • 01-Oct-2018
  • 01-Oct-2018


Retain 4.6


Unable to log into Retain after upgrading to Retain 4.6 and the RetainServer log contains the following three errors:
1) "SqlExceptionHelper: Unknown column 'uidbase0_.f_mapper' in 'field list'"

2) "could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet"

3) "AbstractEasySoap: getAnyUser
com.gwava.gweasysoap.GWSoapAPIException: Directory Services Data missing , Code: d105"


During the upgrade the f_mapper field is supposed to be added to t_uidbase table and the new table t_mergedqueue is added to the database, but failed in this case. The database schema update needs to run again.

1. Make sure that the database user Retain uses has database owner rights or higher.

2. Stop tomcat.

3. Log into the database and manually lower the Retain database schema with the command:
UPDATE t_dbinfoproperties SET f_propertyvalue = 36 WHERE f_propertyname = 'schemaVersion';

4. Start tomcat. The update will be run again. Tail the log to confirm it happens without error.