Re: BPCS/ERPLX Upload File - Master

Rob wrote
<You could upload 27 items with the same item number.>

We had a similar scenario several years ago. It did not come from a bad
upload, but from a failure in our UPS: power outage, and 400 go down hard.

We discovered the problem when our backup would not run properly ...
something about corruption in an IIM logical file.

BPCS does not check for duplicated index records, just reads the first one
it finds, and depending on how the records being accessed, different
programs might read different ones.

Another data integrity oops ... many files have a sequence # ... read
records in sequence 1 2 3 4 etc. let's suppose you deleted 5 6 7 without
going thru BPCS logic ... many BPCS programs stop at 4 because cannot find
5, do not read to next relevant 8 record. Those sequence #s are not
arbitrary, but interlink to other BPCS files, so when we try to resequence,
we have to know all the other files to update.

Updating BPCS files outside of BPCS logic can put you at grave risk of all
kinds of things going wrong downstream.

In query/400 there is the ability to create a work file of the results of
the query, where you must specify name of work file. If some
idiot/////ignorant user specifies as output, the valid name of some BPCS
file, kaboom, that file could get wiped out. Has not happened to us yet.

Hopefully these memories not off-topic.

-
Al Mac