This content has been marked as final. Show 4 replies
What version is this?
I'm not familiar with the Quartz scheduler, but do you have the SQL or PL/SQL command(s) that you're running from the scheduler?
Are you running the sync as the index owner?
to be able to run ctx_ddl.sync_index as a database job it is necessary to have explicit grants for ctx_ddl, the inheritance via the role ctxapp does not suffice.
SQL> grant execute on ctxsys.ctx_ddl to <user_submitting_the_job>;
Are you calling sync_index without providing an index name?
The manual states:
When idx_name is null, all CONTEXT, CTXRULE, and
CTXXPATH indexes that have pending changes are synchronized. You
must be connected as ctxsys to perform this operation ...
The issue was that the index name and partition name of the sync index were passed with the NULL values and it got fixed now. Thanks for the support.