000016660 - AxM 6.0 to 6.1 upgrade with Oracle datastore: Unable to login to axm-admin-gui  'Unexpected Exception'

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

Article Content

Article Number000016660
IssueAxM 6.0 to 6.1 upgrade with Oracle datastore: Unable to login to axm-admin-gui, "Unexpected Exception"
When attempting to login to axm-admin-gui after upgrading from 6.0 to 6.1 when Oracle is in use, the following error is thrown by the eserver when running in debug mode:

012/10/19 13:27:40:284 [*] [APIClientProxy-0 (sirrus.da.sql.util.SQLExceptionHelper.getErrorMessage)] - Database Exception Message : SQLException : Code:904;TextORA-00904: "U"."AUDIT_ADMIN": invalid identifier
2012/10/19 13:27:40:284 [dal_conn] [APIClientProxy-0 (sirrus.da.util.ConnectionManager.returnConnection)] - Returned connection. Now free = 10, leased = 0
2012/10/19 13:27:40:285 [*] [APIClientProxy-0 (sirrus.api.command.APICmdStrategy.executeCmd)] - Thread requesting stream.
sirrus.da.exception.DataStoreException: SQLException : Code:904;TextORA-00904: "U"."AUDIT_ADMIN": invalid identifier
CauseWhile it is technically possible to upgrade from 6.0 to 6.1 without a schema update on ldap server *if* you do not wish to use the optional self service console, it is not possible to do so on sql servers.  The AUDIT_ADMIN table entry was added in 6.1 for Oracle, and must be present to log in to axm-admin-gui.
ResolutionPerform the schema upgrade to Oracle as documented in the I&C upgrade guide for AxM 6.1.  This will correct this issue.
Legacy Article IDa59971