Symptom
Oracle ORA-00904 Error Invalid identifier
After upgrading to OnGuard 5.12.012 with Oracle 10g, an ORA-00904 error may occur during a cardholder search in System Administration. The cardholders returned in the search are missing information and only cardholder photos appear.
Resolution
This error occurs due to the presence of a default user in the Oracle database, called "Scott."To prevent this error from occurring, delete the Scott user and all schemas owned by Scott from the database.
Applies To
OnGuard 2006 (5.12.012)Oracle 10g
