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
Working Lists and/or Menu Items are missing from User Interface when using Internet Explorer
If you are using Internet Explorer to access Biotics and cannot get any working lists to show up and buttons or menu items are missing or misplaced, it coul...
Thu, 7 Jun, 2018 at 1:59 PM
Drop & recreate sequences when need to decrease value
A sequence can be incremented (see Update sequence when out of synch) but in order to decrease the value of a sequence, it must be dropped and recreated wit...
Thu, 21 Jun, 2018 at 11:21 AM