Hi,
I am trying to print Payment Statements in the AR module from 05/19/2018-05/21/2018 and every time I do that it shows an error that says:
Program: FRM_ARPRNPS.FILLSELECT
LINE: 57
ERROR: 1581
MESSAGE: Field LASINV does not accept null values.
After I click OK the entire PowerChurch Program closes. I am running the newest Maintenance Release v12.
Program Crashing..
Moderators: Moderators, Tech Support
Re: Program Crashing..
It sounds like your database has some issues. I'm going to advise that first you do a REINDEX of the database from the Utilities menu. You have to make sure no one else is on the system when this runs.ngaham wrote:Hi,
I am trying to print Payment Statements in the AR module from 05/19/2018-05/21/2018 and every time I do that it shows an error that says:
Program: FRM_ARPRNPS.FILLSELECT
LINE: 57
ERROR: 1581
MESSAGE: Field LASINV does not accept null values.
After I click OK the entire PowerChurch Program closes. I am running the newest Maintenance Release v12.
It sounds like you have a corruption on a record for some reason as the error (field does not accept null values) reflects a database item that should not be 'null', that is no value assigned to it.
Sometimes a reindex fixes issues like this, but I'm not sure its going to work. That said, its worth a try. If you try again, and have the same issue, give Powerchurch a call directly as this may reflect a bug they don't know about.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Program Crashing..
Just did the reindex and the issue is still present. I'll give them a call. Thanks Neil
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Program Crashing..
I have written this up in a bug report. The developers will have a look!
Re: Program Crashing..
Any update on this? Just wondering if this is a bug or an issue with my system.
Re: Program Crashing..
FWIW .. its a 3 day weekend, you won't get an answer until Tuesday at the earliest.ngaham wrote:Any update on this? Just wondering if this is a bug or an issue with my system.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Program Crashing..
It's a bug and has been written up. You can subscribe to the Maintenance Release announcement e-mails at https://www.powerchurch.com/email or keep an eye out here in the forum in the MR announcement area.