Errors and other messages

Meaning of some messages

"Service Unavailable" message received after Grant/Refresh Database Privileges
The first time you use "Grant/Refresh Database Privileges" after adding/changing a view or table, you may see the message below. However, the proc...
Fri, 20 Jun, 2014 at 2:28 PM
Required codec not installed for viewing recorded Biotics 5 sessions
When you try to view trainings and webinars recorded using GoToMeeting or GoToWebinar, you may get the following message: "Windows Media Player c...
Mon, 25 Aug, 2014 at 1:44 PM
ORA-00001: unique constraint BIOTICS_USER.[table_name]_PK violated
NOTE: This explanation only applies when the error message specifies "_PK"! CAUSE: Biotics is trying to assign a primary key (PK) that h...
Fri, 2 Dec, 2016 at 1:19 PM
Get error when running FIX_NEXT_SEQ stored procedure
Description: When running the FIX_NEXT_SEQ stored procedure to identify and fix out-of-whack sequences, you might encounter this error: ERROR at line 1: OR...
Tue, 27 Dec, 2016 at 9:45 AM
Update syntax to avoid trigger error: ORA-01400: cannot insert NULL into ("BIOTICS_USER"."AUDIT_LOG"."USER_NAME")
When trying to execute the update query in SQL+ you will see the following error. update shape set has_shape_ind = 'N' where shape_id = 16285   ...
Tue, 4 Nov, 2014 at 8:39 AM
ORA-24372 Invalid Object for describe
To resolve this, run Grant/Refresh Database Privileges.
Wed, 5 Nov, 2014 at 10:01 AM
Error upon trying to delete a working list - ORA-02292: integrity constraint (..SEC_USR_WL_WL_ID_FK) violated - child record found
PROBLEM: A working list cannot be deleted if it is assigned as a User's Restricted Access Working List.  Trying to delete such a working list will r...
Thu, 3 Mar, 2016 at 7:55 AM
ORA-04063: view "xxxxx" has errors
If a view has errors, the way to determine what is causing the error is to run the following syntax: show errors view VIEW_NAME; The result will ind...
Thu, 3 Mar, 2016 at 1:29 PM