Re: 6.02 and Oracle

["Dave Parmer" <dparmer@xxxxxxxxxxxxxxx>]

The Oracle manual says that this happens when a user presses cntrl-c.  This
is unlikely to occur when running BPCS especially when running the GUI
client (the user can't do it from there).  Another possible cause is the
UNIX kill command.  Certain arguments (I think -1) act just like cntrl-c.
If you have ruled this out then it is possible that something in BPCS is
causing this though I doubt it unless it happens every time (it sounds like
an intermittent problem from your post).

These types of problems are very hard to pin down since they do not happen
every time.  It usually ends up being an Oracle or UNIX system setting
(believe it or not).  The best thing to do is call the Helpline in Chicago
armed with as many bpcslog examples as you can get.  They are going to
assume someone is using the kill command.  If you know this is not the case
then be persistent and have them log on to your system and monitor it when
MRP is running.  They might be able to see an Oracle or UNIX resource
problem.
-----Original Message-----
From: Christine Hales <chales@schukra.com>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: Thursday, June 18, 1998 8:22 AM
Subject: 6.02 and Oracle


>
> We are running 6.02 on HP/Oracle.  Frequently, when programs like MRP
>(Master Schedule Generation) and Shop Floor Posting are running, we get
>errors like:
>
> DB Error: mrp500: 15096: 15205: sdbd_fetch_first_read: Fetch Next:
>ORA-01013: user requested cancel of current operation
>
> Then they crash.  Has anyone else run into this?
>
> -Christine
>
>______________________________________
>Christine Hales, System Analyst
>AEA Management
>Phone: (519) 254-4410 Ext. 146
>Fax: (519) 254-6884
>
>
>
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---