Removal of "Balance Owed" from Patron Bills Results in Blank Display

[Robert J Jackson]

3.2 of webclient

To reproduce bring up a patron account that has bills then select the Bills Tab. Next, In the column picker deselect Balance Owed. Any bills that were displayed are now not visible on the screen. Using the Developer's Toolkit in Chrome we see the following error:

Toolkit error follows:

vendor.bundle.js:6 Possibly unhandled rejection: error calling method open-ils.fielder.flattened_search : 500 : *** Call to [open-ils.fielder.flattened_search] failed for session [0.xxxxxxxxxxxxxxxxxxxxxxxxx], thread trace [0]:
Can't locate object method "content" via package "OpenSRF::DomainObject::oilsMethodException" at /usr/local/share/perl/5.18.2/OpenILS/Application/Fielder.pm line 276.

Log Error follows:

2019-03-11 07:56:39 app7-prod open-ils.fielder: [INFO:2338:Application.pm:159:155230536453101] CALL: open-ils.fielder open-ils.fielder.flattened_search XXXXXXXXXXXXXXXXXXXXXXXXXXX, mbt, HASH(0x55562f0), HASH(0x5556608), HASH(0x555b930)
2019-03-11 07:56:39 app7-prod open-ils.auth: [INFO:2147:osrf_application.c:1075:155230536453101] CALL: open-ils.auth open-ils.auth.session.retrieve "XXXXXXXXXXXXXXXXXXXXXXXXXXX",1
2019-03-11 07:56:39 app7-prod open-ils.auth: [INFO:2147:oils_event.c:46:155230536453101] Creating new event: SUCCESS
2019-03-11 07:56:39 app7-prod open-ils.auth: [INFO:2147:osrf_app_session.c:1177:155230536453101] [open-ils.auth] sent 821 bytes of data to <email address hidden>/open-ils.fielder_drone_at_app7-prod.evergreen.lib.in.us_2338
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [INFO:2501:osrf_application.c:1075:155230536453101] CALL: open-ils.pcrud open-ils.pcrud.search.mbt "XXXXXXXXXXXXXXXXXXXXXXXXXXX",{"xact_finish":null,"usr":"16334","summary.balance_owed":{"<>":0}},{"join":{"__mbts_1":{"class":"mbts","field":"id","fkey":"id","type":"left"},"__mg_1":{"class":"mg","type":"left","field":"id","join":{"__aou_2":{"class":"aou","type":"left","field":"id","fkey":"billing_location"}},"fkey":"id"},"__circ_1":{"type":"left","join":{"__aou_3":{"class":"aou","field":"id","fkey":"circ_lib","type":"left"},"__acp_1":{"fkey":"target_copy","field":"id","join":{"__acpl_1":{"class":"acpl","type":"left","field":"id","fkey":"location"},"__acn_1":{"join":{"__bre_1":{"class":"bre","join":{"__rmsr_1":{"fkey":"id","field":"id","type":"left","class":"rmsr"}},"field":"id","fkey":"record","type":"left"},"__aou_1":{"type":"left","field":"id","fkey":"owning_lib","class":"aou"}},"fkey":"call_number","field":"id","type":"left","class":"acn"}},"type":"left","class":"acp"}},"fkey":"id","field":"id","class":"circ"}},"flesh":5,"order_by":[{"field":"xact_start","class":"mbt","direction":"asc"}],"limit":25,"flesh_fields":{"mbt":["summary","circulation","grocery"],"circ":["target_copy","circ_lib"],"mg":["billing_location"],"acn":["owning_lib","record"],"acp":["call_number","location"],"bre":["simple_record"]},"offset":0}
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [ERR :2501:oils_sql.c:3816:155230536453101] open-ils.pcrud: Attempt to reference non-existent column "summary.balance_owed" on money.billable_xact (mbt)
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [INFO:2501:osrf_app_session.c:1177:155230536453101] [open-ils.pcrud] sent 227 bytes of data to <email address hidden>/open-ils.fielder_drone_at_app7-prod.evergreen.lib.in.us_2338
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [INFO:2501:osrf_app_session.c:1177:155230536453101] [open-ils.pcrud] sent 189 bytes of data to <email address hidden>/open-ils.fielder_drone_at_app7-prod.evergreen.lib.in.us_2338
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [WARN:2501:osrf_application.c:855:155230536453101] Returning method exception with message: An unknown server error occurred
2019-03-11 07:56:39 app7-prod open-ils.pcrud: [INFO:2501:osrf_app_session.c:1177:155230536453101] [open-ils.pcrud] sent 207 bytes of data to <email address hidden>/open-ils.fielder_drone_at_app7-prod.evergreen.lib.in.us_2338
2019-03-11 07:58:59 app7-prod open-ils.fielder: [INFO:2338:XMPPReader.pm:383:155230536453101] flushing data from socket... OpenSRF::Transport::SlimJabber::XMPPMessage=HASH(0x5573e98)

[Jennifer Pringle (jpringle-u)]

We're seeing this in 3.3.4 as well.

[Jennifer Pringle (jpringle-u)]

This continues to be an issue in 3.5

[Jennifer Pringle (jpringle-u)]

Confirmed this issue is still present in 3.7

[Jennifer Pringle (jpringle-u)]

Bills continue to disappear from view when the Balanced Owed column is de-selected in 3.9

[Gina Monti (gmonti90)]

Finding that in 3.6 on that if you make the field 'required hidden' in code to take it off checked by default, it does fix the display problem. Temporary solution but works for me so far.

[Michele Morgan (mmorgan)]

I'm not able to reproduce this issue in either our 3.10.3 production server or 3.12.3 test server.

I am able to deselect Balance Owed in both the angularjs and Angular patron bills screen, but still see rows for the billings with data in the grids.

[Jennifer Pringle (jpringle-u)]

I can't reproduce this in angularjs our 3.11.1 server either.

[Andrea Neiman (aneiman)]

Marking won't fix on the basis of comments #6 and #7