Re: ORACLE CONTEXT DML-RSS.

Do you have logging turned on?
If so, check logs; if not, turn on logging.

But perhaps in the mean time, I'd suggest using ctxsrv -user ctxsys/ctxsys -log mylog.txt
If you don't write an NT service, you will have to dedicate a workstation for indexing.

Tim

"Robert Silver" <rss_at_ddsc.com> wrote in message news:259cff91.0110020659.47b85555_at_posting.google.com...
> In an effort top fix some problems we experienced on the server
> yesterday I came accross this:
>
> it is exactly how Oracle recomends that you do it. Even to the point
> of
> truncating those tables. If you submitted this job as a batch job
> through
> the Context Admin utility you also need to execute dbms_job.delete to
> delete
> the job otherwise it will forever stay in the job cue and will never
> stop
> running.
>
>
> The context server needs to be better understood. Obviously the
> stalling problem we have with PPXCASE is local to that
>
> Here is why I think maybe a step or two was missed:
>
> Hindy if you are out there please reply! Anyone else would be welcome
> as well.
>
> Again on an NT/Oracle 8.05 server the context engine server DML
> stalled on
> a queued job. What would cause such a stall and how do possibly
> resolve it.
> Is there any special diagnostics anyone can suggest??
> Any help here would be appreciated. Also How do I know I cleaned out
> all the garbage are the folowing tables all that are involved:
> drq_pending
> drq_batches
> drq_batchno
> ctx_policies
> I do not understand the roll the following two play??
> ctx_svcq
> drq_waiting
>
> Any help in debuging this problem would be greatly appreciated
> If anyone is aware of any character sequences or characters that cause
> this
> stalling please let me know as well.
> I would be willing to pay for a good answer to this problem myself. I
> am being
> abused by users please help!
>
> They have nasty fangs and sharp teeth!!
Received on Tue Oct 02 2001 - 10:54:20 CDT