|
> Turns out that, when SSA put the SQL in to delete planned orders, they
left in
> the DOW loop for deleting them
natively (yes, proves your point again) --
> although the SQL deleted all necessary records on the first pass, it kept
> trying again and again for the same records (fixed with a BMR).
>
Forgive me for being obtuse - but is this refering to the CST900 - Shop
Order close program? Same exact problem - and I'd love to know that there
is a BMR out there for it! It takes us approximately 6+ hours to run,
slowing the system and locking records like crazy (and we've only been live
for a few months). We have been in contact with SSA Toronto over this -
they are leaning towards writing a mod for us.
-Christine
_____________________________________
Christine Hales, System Analyst
AEA Management
PH: (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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.