Welcome, Guest. Please Login.
05/19/25 at 16:14:39
News:
Home Help Search Login


Pages: 1
Send Topic Print
SO-N problem after 12/14 download (Read 1932 times)
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
SO-N problem after 12/14 download
01/11/05 at 07:20:12
 
We processed the 12/14/04 download yesterday.  Went into SO-N to convert the sales order to a work order.  This was a single sales order with one item on it.  An error message came up "CANNOT PROCESS SO: 6695 SINCE THE WORK ORDER SUFFIX GENERATED WILL SURPASS 999.  PLEASE CHANGE THE INCREMENT"
 
Pressed ok, and the same message came up for another sales order.  This went on through our whole open sales order file, then it created the work order we requested.  
 
1) our increments are set at 10
2) We generally only have one or two items per sales order.
3) We requested only 1 sales order for release, but it went through the whole file.
 
Please advise.
 
Thanks
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: SO-N problem after 12/14 download
Reply #1 - 01/11/05 at 09:21:34
 
Can I make a general suggestion to ALL based upon this?
 
When dealing with ANY business critical IS application and looking at either upgrading the software or the hardware upon which the software sits OR the operating system OR any major driver or other software that significantly interoperates with the OS, you ALWAYS:
 
1) Set-up a "test box" and copy all data and program files to said box to create as close as possible a duplicate of the live "production" environment.
 
2) You then perform your updates (Hardware, OS, Drivers, Software) as desired and then TEST, TEST, TEST to make sure that AT LEAST you main day-to-day business functions will operate as required and expected.
 
3) Once you have confirmed this, THEN you repeat the actions, according to the written plan and notes you will have from 1 & 2, in your live production environment.
 
These simple steps will ensure you do not run aground of situations like this.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Danimal
Member
**




Posts: 59
Gender: male
Re: SO-N problem after 12/14 download
Reply #2 - 01/13/05 at 08:16:45
 
Quote from aricon   on 01/11/05 at 09:21:34:
These simple steps will ensure you do not run aground of situations like this.

I'm sorry, but sounds like you are placing the responsibility of the programming team upon its users.  Standard debugging procedures will solve the majority of problems encountered during the programming process... as you say, TEST, TEST, TEST what has been changed to ensure something else didn't break.
 
It's not like we have a second server sitting around, nor have the time, to troubleshoot problems from what I expect, as should others, to be rudimentary upgrades.  Karen isn't the only person who has been burned by surprises like this, and I'm sure won't be the last.  I'll get down from the soap box now.
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: SO-N problem after 12/14 download
Reply #3 - 01/13/05 at 08:36:48
 
While we don't by any stretch claim to be perfect, we do a lot of testing and, in this case, (SO-N), even with Karen's description of the issue I can't duplicate and have had no other reports and SO-N is a very commonly used program.    
 
As cautious as Lorne's advice may be, even if you did that, as soon as you go "live" inevitably some user does something you didn't anticipate.  At some point along the line, you need to go for it.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: SO-N problem after 12/14 download
Reply #4 - 01/13/05 at 09:48:07
 
Dan,
 
The simple fact is that it is YOUR installation at the end of the day. It is YOUR business. It is YOU that suffers if there is something that doesn't work correctly that affects your ability to smoothly conduct business.
 
That is why in Enterprise systems implementations and in development projects and so on, when dealing with important or critical business systems, the user site has final responsibility to sign-off acceptance (AFTER testing) for upgrades, enhancements and patches.
 
Yes, it is the responsibility of the software developer or the development project PM or QA manager in the case of a custom development, to test as much as they REASONABLY can based upon what they consider to be the most likely and/or common configurations and usage scenarios. However, the fact is that any particular site may NOT conform to these testing standards and therefore things will be missed.
 
Also, as Lynn stated "we don't by any stretch claim to be perfect, we do a lot of testing".  
 
If you bough a new piece of critical machinery for the shop, would you just drop it on the floor, turn it on, and start running a critical and very expensive job for your largest customer through it? Or would you test it fairly extensively to make as sure as you could that it was set-up and calibrated correctly 1st??
 
Same thing
 
OK, done....Smiley
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: SO-N problem after 12/14 download
Reply #5 - 01/13/05 at 10:08:29
 
Quote from aricon   on 01/13/05 at 09:48:07:
If you bough a new piece of critical machinery for the shop, would you just drop it on the floor, turn it on, and start running a critical and very expensive job for your largest customer through it?

No. But I fail to see the relevance.
 
This is more like taking your car to the dealership and they tell you there's a recall notice on the lug bolts (this happened to me on my last trip to the dealer). Now to me, lug bolts are pretty mission critical. What you are suggesting seems more akin to telling them "Well, I'd like to have you do that on my spare car, and I'll send one of my drivers to the test track with it and see how it goes before you do it on my daily driver."
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: SO-N problem after 12/14 download
Reply #6 - 01/13/05 at 10:47:25
 
Sorry David, not the same.
 
Reality is: software is not perfect!! Sorry for the bad news, but there it is...Smiley
 
AND as software gets more and more complicated to try to meet the demands placed upon it, in particular the demands of more and more user configurability and "customization" and "personaliztion", there comes to be more and more and more different configurations to test. If you are prepared to pay the cost for a mid-range or higher solution to enable bigger budgets for the software company to do even more extensive testing then you can reduce the likliehood of significant problems.
 
However, DBA and EVO-ERP as a dirivitive, certainly do NOT fall into that budget category, so there is a very real limit to the amount of testing that can be realistically performed.
 
Additionally, the simple fact is that this software is written in an old line-editor code. It also does not have the "protection" from possible coding mistakes that a true relational database can provide (admitedly that is not a HUGE factor, but it can prevent some mistakes), and therefore it is somewhat easier for code in program A to have a negative impact upon the functionality of code in program T wayyyyy down the line, and the limited programming resources can only stretch just so far.
 
For your analogy of the lug bolts, well, simple fact is I have yet to hear of such a thing as a "user-defined lug bolt configuration". The technology of the lug bolt is VERY standardized, straightforward and pretty static therefore it is a more reasonable expectation to have it function pretty much the same for everyone ALL the time. And I would bet that the recall had nothing to do with the testing of the basic lug bolt, it was probably a manufacturing error.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: SO-N problem after 12/14 download
Reply #7 - 01/13/05 at 12:15:34
 
In an ideal environment, it would be nice to have a second server box sitting around to 'dry run' various upgrades.
 
However, except for the consultants or large manufacturing  environments, this is just not realistic.
 
There is an inexpensive option that I use for DBA Upgrades.  Put a Larger Hard drive in your server and setup another drive letter as a mirrored live DBA environment.  
 
I have two different shares on my server.  On 'my' client machine, I have two different drive letters, one is the live system, and one is the test system.  Only the people around here that I use to verify an upgrade have access to this 'test' system.
 
To make this work correctly, the DBA file locations (UT-D) need to be relative paths instead of absolute.   For example, instead of a location of 'N:\dbamfg\default\', it would read '.\default\'  .
 
Before any DBA upgrade, I take a snapshot of all files in the Live system and copy them to the Test system. (If you really want to protect yourself from accidentally copying the files from the Test system to the Live system, then login to your operating system under a user that does not have write privileges to the Live system)
 
After I have a fresh copy of all the current data files, I then apply the upgrade to my 'test' drive.  I can do all the testing and verification that I want before I apply the upgrade to the live system.  If I do this on the weekend, then I can just copy the test system over the top
Of the live system when I am satisfied.
 
For us, I only need a couple of gig to have a complete test configuration
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: SO-N problem after 12/14 download
Reply #8 - 01/13/05 at 12:24:43
 
Now THAT'S what I'm talking about.... Grin
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Pages: 1
Send Topic Print