Bug in /UAI - Usage Audit Inquiry

[CKilgore]

I recently came across this bug in Prelude code.  I'm not sure if this is unique to our setup or not.

When looking up product usage in /UAI (or /PMM > F5 > F7), it throws an error that year 2010 is invalid.  I traced the problem back to the Field Definition for WK.YEAR in the USG.AUDIT.XREF file.

The validation code was:
R:00 TO 09 OR R:2000 TO 2009{[U2]}

I changed the validation code to:
R:01 TO 10 OR R:2001 TO 2010{[U2]}

After making this change, everything began working again.

[Tom Pellitieri]

Hey there!  Welcome!

Field WK.YEAR in USG.AUDIT.XREF was last updated for Version 16.  The validation code change you made will work until you try to enter 2011.

Personally, I would update the limits to 20 and 2020, respectively, and report the bug and temporary fix to Activant.  It will be something to check on the next upgrade to see if it was fixed.

--Tom

[CKilgore]

Tom

Was this same validation code on your system?

Bumping it only a year was just a short term fix.

[Tom Pellitieri]

Yes... the validation code was only for 2000-2009... (sigh)

--Tom

[precisonline]

Someone should post that over to the IPUG.  But then again, that's just me.

[CKilgore]

Someone should post that over to the IPUG.  But then again, that's just me.

I would if I could, but I can't.  I haven't been allowed into that party yet.

[CKilgore]

Prelude is aware of this.

Per Brent:

Chris,
This is a known bug that David is aware of, he asked that all   
cases related to this issue go directly to him to be fixed.   

[davidkyles]

v21 has been fixed... at least until the year 2030.