on Jun 14, 2016Article Content
| Article Number | 000016660 |
| Issue | AxM 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 |
| Cause | While 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. |
| Resolution | Perform the schema upgrade to Oracle as documented in the I&C upgrade guide for AxM 6.1. This will correct this issue. |
| Legacy Article ID | a59971 |