Re: BPCS 6.0.4 GUI - order entry locks on an order during maintenan ce

Based on the SQL message, sounds like you might have duplicate records
in your ECH file. To check whether that is the case:

Type STRSQL and enter the following statement:

select * from ech where hord = xxxxxx

where xxxxxx is your order number.  There should only be one record in
ECH.  If more than one, you should delete one of them.

Regards,

Boris Goldenberg




---"Hancock, Teri" <THANCOCK@accuridecorp.com> wrote:
>
> 
> Experiencing problems with an order during maintenance in GUI. 
Here's a
> strange one that I'm trying to track down.
> 
> The user is trying to maintain an order in GUI.  When he selects
"accept" or
> "validate", his device seems to get stuck in its tracks.  Using
CTL/ALT/DLT
> we can see that his session is "not responding".  So far, we have
just had
> to  end the task and then cancel his GUI session. The order is
simply not
> maintainable in GUI at this time.
> 
> Does anyone have a clue what would cause an order to do this?  When I
> display the log it tells me that the "result of Select Into or
subquery more
> than 1 row.  Error type 1".  As you know, we cannot change or view
the GUI
> programs.  This is not a new order and we haven't changed the GUI
programs.
> 
> Thanks for any suggestions..
> 
> 
> Teri
> 
> 
> 
> +---
> | 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
> +---
> 

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---