000025595 - Error 'SVR-00012-W: Unable to save because a required attribute is missing. Details: sirrus.util.db.exception.RequiredAttributeException: ORA-01400: cannot insert NULL into ('CT_OWNER'.'APP'.'TYPE')' in RSA ClearTrust Entitlements Manager

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000025595
Applies ToRSA ClearTrust 4.6.1.1
RSA ClearTrust Entitlements Manager (Admin GUI)
Oracle 8.1.6
IssueError "SVR-00012-W: Unable to save because a required attribute is missing. Details: sirrus.util.db.exception.RequiredAttributeException: ORA-01400: cannot insert NULL into ("CT_OWNER"."APP"."TYPE")" in RSA ClearTrust Entitlements Manager
CauseThe Oracle database schema was not updated to RSA ClearTrust 4.6.1.1. Because of this there is a column called "TYPE" with a value of "NOT_NULL" which the Entitlements Manager is not populating when a new Application is added.
ResolutionObtain the "migrate_4.5_to_4.6.sql" script and run against the database from within SQL. Restart your ClearTrust services for the change to take effect.

NOTE: It is strongly recommended that you back up your database prior to running this script
WorkaroundUpgraded from RSA ClearTrust 4.5.x to 4.6.1.x
Legacy Article IDa9546

Attachments

    Outcomes