Running SQL " eq_query_adm.set_sys_admin_param" Returns Error "ORA-01402: view WITH CHECK OPTION where-clause violation" (Doc ID 2098625.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 to 11.2.2.2.0
Information in this document applies to any platform.

Symptoms

On : SES 11.2.2.2.0 version, Admin Front End

Running the commands in document 1596251.1 to configure Peoplesoft and SES.

The command failed,

 alter system set events '30579 trace name context forever, level 1610612736';

with the error

ORA-01031: insufficient privileges

To fix this the command was run as a different user, sys as sysdba.

After this the next command fails,

SQL> exec eq_query_adm.set_sys_admin_param('INFOSOURCE_EXTRACT_MODE','DISABLED',1);
BEGIN eq_query_adm.set_sys_admin_param('INFOSOURCE_EXTRACT_MODE','DISABLED',1); END;

*
ERROR at line 1:
ORA-01402: view WITH CHECK OPTION where-clause violation
ORA-06512: at "SEARCHSYS.EQ_QUERY_ADM", line 136
ORA-06512: at line 1
 

ERROR
-----------------------
ERROR at line 1:
ORA-01402: view WITH CHECK OPTION where-clause violation
ORA-06512: at "SEARCHSYS.EQ_QUERY_ADM", line 136
ORA-06512: at line 1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the SQL commands from document 1596251.1 to configure SES and Peolesoft.
2. The alter system command fails with insufficient privileges.
3. Login using sys as sysdba and run the alter system command again.
4. Login as searchsys to complete the last command and it fails.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms