Re: INV903 question -- BPCS-L

Genyphyr-
First let me start by saying that I have been running this particular
process every month for the last 36 months.  I am the MIS person
responsible.  I don't purge the ITH at month end, but I do run month-end
close from the  GUI menu.  I checked the BMR list - nothing.

The first time it happened I didn't realize it and continued my close
procedure.  It was the following morning when a user informed me that all
her inventory was not rolled up.  I remembered seeing another user signed on
the day before and decided he had caused the file to lock-up.  I have had
that happen before so I wasn't too surprised.   Fortunately  I save the ILI
file as part of the procedure and was able to write a program to roll it up
and back out any transactions for the new period.

The second time it happened I had added a check by running the stock status
summary report.  I spent an hour trying to figure out what was going on.  I
was the only person signed on to the system at the time and I checked for
IIM file locks.  I signed off and signed back on to make sure I didn't cause
it myself.    In fact I even rebooted my PC thinking something there was
messing it up.  Since, I close the period on a Sunday from home I didn't
have the SSA number to call and that was why I ran my own program the second
time - plus there are other jobs  I needed to run.

That Monday I copied the ILI  backup and the IWI and IIM from live to the
test area.  Ran  the INV972 roll ILI to IWI , IIM.  Then ran the month-end
close.  It worked just fine.  I still have no idea what happened, but I am
not looking forward to the next month-end close.

Any other ideas?

Regards,

Wendy DeCair
Country Fresh, LLC
a Suiza Foods Co


"You could be a liar.  You could also be a member of Congress.  But I repeat
myself."  -- Mark Twain












----- Original Message -----
From: Genyphyr Novak <novakg@ssax.com>
To: <BPCS-L@midrange.com>
Sent: Thursday, October 12, 2000 3:05 PM
Subject: Re: INV903 question


> Do yourself or Dennis run this program with Purge ITH records set to *YES?
> If so, try to run it with *NO and see if this works. If it works that way,
> then check for duplicate ITH records, or check for some other job having a
> lock on the IIM file. I see a few past cases of this problem happening due
> to one of these problems.
>
> Why it ends without logging an error is another issue altogether. If
either
> the IIM file lock or duplicate ITH records is the solution to the problem,
I
> suggest you request a BMR be entered against INV903 to at least end the
job
> with some BPCS message saying that it ended abnormally if it encounters
> duplicate records or file locks that prevent it from running. This program
> (INV903B) has not been BMR'd since 1998, according to our system.
>
> Thanks
>
> Genyphyr Novak
> SSA GT
>
> ----- Original Message -----
> From: "Wendy DeCair" <wendy.decair@countryfresh.com>
> To: <BPCS-L@midrange.com>
> Sent: Thursday, October 12, 2000 11:12 AM
> Subject: Re: INV903 question
>
>
> > Hey - I had the same problem. I am on the same version etc.   It ran and
> > updated the parm for month-end but didn't roll anything over.  I changed
> the
> > logging to show what it was doing - no errors.  No files in use, no
> balance
> > in ILI or IWI too high. It hasn't worked since Aug 27 at our shop.  I
> > actually wrote my own program and ran it instead.
> > When I copied files and ran it in test a few days later with the same
ILI
> > etc.  It worked just fine.
> > Help!
> >
> > Regards,
> >
> > Wendy DeCair
> > Country Fresh, LLC
> > a Suiza Foods Co
> >
> > Borrowed from Dean  - good quote.
> > "You could be a liar.  You could also be a member of Congress.  But I
> repeat
> > myself."  -- Mark Twain
> >
> >
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: Dennis Munro <DMunro@badgerminingcorp.com>
> > To: 'BPCS E-Mail List' <BPCS-L@midrange.com>
> > Sent: Thursday, October 12, 2000 10:15 AM
> > Subject: INV903 question
> >
> >
> > > If this appears twice, sorry for the duplication.  I sent it out last
> > night
> > > about 6PM & it hasn't shown up in my e-mail yet this morning but I've
> > gotten
> > > other BPCS e-mails????  So here it is again.
> > >
> > > Running BPCS Ver.6.0.02 plf, Mar'98 cum, full client/server on a 9406
> S20
> > at
> > > V4R4M0 fairly current on "all" ptf's.
> > >
> > > When I ran INV903 at September Month End through my automated process,
> it
> > > didn't run.  I was able to run it manually from BPCS - I think & I
> really
> > > don't remember how I did run it.  But I know it was run.
> > >
> > > I am now running/testing my "automatic" program on my test machine
(same
> > > config as above except it is a 720) & it did not run.  INV903B &
INV903D
> > are
> > > in the BPCSO & BPCSPTF libraries only on both machines.  Nether
machine
> > has
> > > an object named INV903x in my BPCSBMR library.  When running INV903
> > > interactively, I noticed that I don't see the second panel.  I fill
the
> > > parms in on the first panel, click OK, & within a couple of seconds, I
> > have
> > > the menu back.  The second panel has the parm that is checked
"Continue
> > with
> > > Month End Procedure".  At least it did a year or so ago when I wrote
the
> > > computer work instructions & captured screen prints.  I now don't see
> that
> > > panel & I don't remember if it is check by default or not?  Must not
be
> > > because the process stops almost immediately after clicking OK on
panel
> > one.
> > >
> > > Something must have changed & I not sure where to look.  If I changed
> > > something, I don't remember & certainly didn't mean to????  I changed
> all
> > > the BPCS job descriptions to log the CL & nothing jumps out at me when
> > > looking through the job log.  INV903B is called with parms being
passed
> > in,
> > > a bunch of RTVMSG's are executed from CLMSG, then a RCLRSC
LVL(*CALLER)
> > from
> > > line 14 of INV903C & that's that.  I can't RTVCLSRC of INV903C because
> the
> > > source is not available so I have no idea what it is trying to do.
> > >
> > > Looking through the INV903B AS/SET code, I see BMR 6862: "Added call
to
> cl
> > > program INV903C to reclaim resources to alleviate file locks caused by
> SQL
> > > open data paths not being deleted."
> > >
> > > Looking through the INV903D AS/SET code,  INV903B only runs if either
of
> > the
> > > items on the second panel are checked (I can't check them because I
> don't
> > > see that panel) otherwise there is an EXTPGM.
> > >
> > > Looking through OGS I found 23 BMR's listed when searching using
INV903.
> > > None are my situation.
> > >
> > > I've thought about it being a security issue, but why only this one
> > object?
> > > The user profile that runs month end is a BPCS security officer.
> > >
> > > Any clues as to what I'm missing???
> > >
> > > Dennis
> > >
> > > Dennis Munro
> > > Badger Mining Corporation
> > > dmunro@badgerminingcorp.com
> > > www.badgerminingcorp.com
> > > (920) 361-2388
> > > +---
> > > | 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
> > > +---
> > >
> > >
> >
> > +---
> > | 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
> > +---
> >
>
> +---
> | 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
> +---
>

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