Weird report run
Bruce Easton
bruce at stn.com
Wed Sep 13 12:31:18 PDT 2006
Is index scan turned on and do you have an index built on that one-byte flag
field that's in the selection set? Then that index could be corrupted.
Bruce
Bruce Easton
STN, Inc.
Joe Chasan wrote on Wednesday, September 13, 2006 3:06 PM
>
> i specifically avoid giving users access for selection sets and
> sort screens
> for reports simply to avoid times like this when one wonders what happened
> and the system provides no controls or logs.
>
> those were just my first guesses. there are certainly a bunch more
> possibilities (corrupt index, faulty programming, multi-user access
> issues, etc) that are possible but i don't think we know enough about
> your system to get any deeper.
>
> -joe
>
> On Wed, Sep 13, 2006 at 02:38:04PM -0400, Boaz Bezborodko wrote:
> > In this case the selection set is based on a 1 character wide flag-type
> > field. The sort and form-breaks were done on the Vendor name in the
> > sort table for the form. So while the selection might have been played
> > with the sort and printout should still have broken out OK. Except that
> > that's not what happened.
> >
> > The user assures me that they used the system to select only the one
> > invoice, but the system selected a bunch or other, seemingly random,
> > invoices and put them on the same form even as it generated new check
> > records for them.
> >
> > As I said, generating the checks would not have been strange if it
> > wasn't for the user swearing that they weren't selected (and I believe
> > him). But to select them erroneously, properly process them, and then
> > put them on the same form without the form-breaks just seems
> very strange.
> >
> > Boaz
> >
> > Joe Chasan wrote:
> >
> > >On Wed, Sep 13, 2006 at 01:49:32PM -0400, Boaz Bezborodko wrote:
> > >
> > >
> > >>Knowing the user I would seriously doubt that either of these were
> > >>played with. In any case it wouldn't explain the other weird behavior
> > >>of why the output didn't break into separate forms.
> > >>
> > >>
> > >
> > >yes, it could.
> > >
> > >take the below example.
> > >
> > >vendor number field is of length 6. you sort/subtotal by that field
> > >number.
> > >
> > >report selects data for vendor #100001, 100002, 100003.
> > >
> > >if sort is of length 6, these will appear in different
> subtotal groupings
> > >and/or pages depending on how you have set this up - all well and good.
> > >
> > >lets say, however,that the sort length is of a number less than 6 - for
> > >the above 3 data items, a length 0, 1, 2, 3, 4, or 5 will all put these
> > >items in the same grouping as the first X (where X is
> 0/1/2/3/4/5 per above)
> > >number of characters of those fields are the same.
> > >
> > >-joe
> > >
> > >
> > >
> > >>Joe Chasan wrote:
> > >>
> > >>
> > >>
> > >>>if the user has access to modify either the selection set or the sort
> > >>>criteria, i'd look at those as possible causes.
> > >>>
> > >>>-joe
> > >>>
> > >>>On Wed, Sep 13, 2006 at 01:31:13PM -0400, Boaz Bezborodko wrote:
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>Through a selection set. (Looking for a "Y" in a particular field.)
> > >>>>
> > >>>>GCC Consulting wrote:
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>>-----Original Message-----
> > >>>>>>From:
> > >>>>>>filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> > >>>>>>.com
> > >>>>>>[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> > >>>>>>elestial.com] On Behalf Of Boaz Bezborodko
> > >>>>>>Sent: Wednesday, September 13, 2006 1:11 PM
> > >>>>>>To: filepro-list at lists.celestial.com
> > >>>>>>Subject: Weird report run
> > >>>>>>
> > >>>>>>A user ran a report that had a very weird result and I need
> > >>>>>>help trying to figure out why. This is a report that has
> > >>>>>>been running fine for a long time.
> > >>>>>>
> > >>>>>>The report picks out invoices to pay and then generates
> > >>>>>>checks for them. Each invoice is a line on the report and
> > >>>>>>the sort order is by vendor with a new form being generated
> > >>>>>>for each new vendor. When it does so it generates a new
> > >>>>>>check number and creates a new record for this check in the
> > >>>>>>checks file.
> > >>>>>>
> > >>>>>>The weird thing on this run was that on this run they were
> > >>>>>>only generating one check, but a bunch o invoices that should
> > >>>>>>not have been selected, from different vendors, were chosen
> > >>>>>>and they were printed all on the first form for the original
> > >>>>>>check. They should not have been selected, but they were.
> > >>>>>>They should not have shown up on the first form as part of
> > >>>>>>the one check that was supposed to have run, but they did.
> > >>>>>>And they should not have generated their own checks, but they
> > >>>>>>did. That last part was the one part that was consistent
> > >>>>>>with their being printed even though they shouldn't have
> > >>>>>>because they didn't conform to the selection criteria.
> > >>>>>>
> > >>>>>>I've reviewed the code and can't find any reason why this
> > >>>>>>should have happened. Any suggestions as to why the errant
> > >>>>>>selection and sort behavior?
> > >>>>>>
> > >>>>>>Note: I'm using FP 4.8 on Windows.
> > >>>>>>
> > >>>>>>Boaz
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>What is the criteria that you are using to select invoice to pay?
> > >>>>>
> > >>>>>Is this through -v processing or a selection set?
> > >>>>>
> > >>>>>Richard Kreiss
> > >>>>>GCC Consulting
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>_______________________________________________
> > >>>>Filepro-list mailing list
> > >>>>Filepro-list at lists.celestial.com
> > >>>>http://mailman.celestial.com/mailman/listinfo/filepro-list
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>--- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - ---
> > >>>-Joe Chasan- Magnatech Business Systems, Inc.
> > >>>joe at magnatechonline.com Hicksville, NY - USA
> > >>>http://www.MagnatechOnline.com Tel.(516)
> 931-4444/Fax.(516) 931-1264
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
> > >-Joe Chasan- Magnatech Business Systems, Inc.
> > >joe at magnatechonline.com Hicksville, NY - USA
> > >http://www.MagnatechOnline.com Tel.(516) 931-4444/Fax.(516) 931-1264
> > >
> > >
> > >
>
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
> -Joe Chasan- Magnatech Business Systems, Inc.
> joe at magnatechonline.com Hicksville, NY - USA
> http://www.MagnatechOnline.com Tel.(516) 931-4444/Fax.(516) 931-1264
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
More information about the Filepro-list
mailing list