[OPEN-ILS-DEV] void or pay bills error in Evergreen 1.6

[Soulliere, Robert]

Hi All,

I recently upgraded to 1.6.1.4 and am getting some errors when trying to void or pay circulation related bills in Evergreen 1.6.1.4.

When trying to pay bills or void existing bills I am getting errors.

The error in the staff client:

["c3c129304710b2fe3275c0730b79fb0f",92407,92388,90132,90332,90567,90782,90967,91146,91305,91430,91521,91677,91878,92036,92189,92316]
THROWN:
{"payload":[],"debug":"osrfMethodException :  *** Call to [open-ils.circ.money.billing.void] failed for session [1292731037.200278.12927310378978], thread trace [1]:\nCan't use an undefined value as an ARRAY reference at /openils/lib/perl5/OpenILS/Utils/Penalty.pm line 29.\n\n","status":500}
STATUS

The error in the logs:
Caught error from 'run' method: Can't use an undefined value as an ARRAY reference at /openils/lib/perl5/OpenILS/Utils/Penalty.pm line 29.

The most helpful log information comes from the postgresql error log file:
2010-12-18 22:57:17 EST ERROR:  invalid input syntax for integer: "" at character 55
2010-12-18 22:57:17 EST STATEMENT:  SELECT * FROM actor.calculate_system_penalties( '11', '' ) AS "actor.calculate_system_penalties" ;
2010-12-18 22:57:17 EST ERROR:  current transaction is aborted, commands ignored until end of transaction block
2010-12-18 22:57:17 EST STATEMENT:  SELECT  "au".active, "au".alert_message, "au".barred, "au".billing_address, "au".card, "au".claims_returned_count, "au".create_date, "au".credit_forward_balance, "au".day_phone, "au".dob, "au".email, "au".evening_phone, "au".expire_date, "au".family_name, "au".first_given_name, "au".home_ou, "au".id, "au".ident_type, "au".ident_type2, "au".ident_value, "au".ident_value2, "au".last_xact_id, "au".mailing_address, "au".master_account, "au".net_access_level, "au".other_phone, "au".passwd, "au".photo_url, "au".prefix, "au".profile, "au".second_given_name, "au".standing, "au".suffix, "au".super_user, "au".usrgroup, "au".usrname, "au".alias, "au".juvenile, "au".deleted FROM actor.usr AS "au" WHERE "au".id = 11;

It looks like the context_org variable is not getting passed to the calculate_system_penalties function in the database but I am not quite sure yet if this is a bug in the code or an error in the data in our database. Any clues or tips?

If someone can verify it is a bug, I will create a bug report in launchpad, if it is an issue with our data does any have any suspicions of one of the upgrade scripts not completing the necessary transactions.

The bills which I cannot void or pay are booking related overdue bills. I have been able to pay and void grocery bills without error. I have not been able to test with general circulation bills.

Thanks,
Robert



Robert Soulliere, BA (Hons), MLIS
Systems Librarian
Mohawk College Library
robert.soulliere at mohawkcollege.ca
Telephone: 905 575 1212 x3936
Fax: 905 575 2011

This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message.  If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited.  If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.