DRAFT: Datameer 7.5 failed to start because of Unknown name value [VARIABLES_READ] exception

Problem

After the upgrade to version 7.5.x, Datameer fails to start with the following exception.

stderrout.log

2020-01-05 11:23:43.622:WARN:oejw.WebAppContext:main: Failed startup of context o.e.j.w.WebAppContext@7225790e{/,file:/datameer/Datameer-7.5.4-hdp-2.6.0/webapps/conductor/,STARTING}{/conductor}
java.lang.IllegalArgumentException: Unknown name value [VARIABLES_READ] for enum class [datameer.dap.sdk.usermanagement.Capability]
 at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
 at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
 at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
 at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:127)
 at org.hibernate.persister.collection.AbstractCollectionPersister.readElement(AbstractCollectionPersister.java:811)

conductor.log (may or may not occur) 

[anonymous] WARN [2020-01-05 11:23:43.622] [ldap-cache-update-operation] - role with role_id 2, capability VARIABLES_READ can not be converted to Capability object, skipping it.

Cause 

This is related to the updates made to the 7.5 SDK. Role capability VARIABLES_READ has been removed. Please refer to Important API and SDK Changes for Developers section of Datameer documentation for more details.

There is the upgrade script upgrade-7.5.0-DAP_38522.sql, that should be executed as part of the Datameer database schema upgrade. It deletes all occurrences of the role capability VARIABLES_READ.

Solution

In case the mentioned upgrade script hasn't been executed for some reason, it is possible to manually remove the role capability VARIABLES_READ.

Execute the following query against the Datameer database. If the script has run, the query should not return any record. In this case, please get in touch with Datameer support for further investigation.

SELECT * FROM role_capability WHERE capability = 'VARIABLES_READ';

If the query returns any response:

• Stop Datameer.
• Take the database dump.
• Execute the following query.
  

  DELETE FROM role_capability WHERE capability = 'VARIABLES_READ';

• Start Datameer.