× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: BPCS 6.0.4 GUI - order entry locks on an order during maintenan ce
  • From: Boris Goldenberg <bpcsguru@xxxxxxxxx>
  • Date: Mon, 15 Mar 1999 14:46:21 -0800 (PST)

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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.