[OPEN-ILS-DEV] Syrup, OpenSRF 3.0, Evergreen 3.0.12 and JSONDecodeError

[Jason Stephenson]

Yeah, never mind. I see what I did wrong below.

On 10/08/2018 08:14 AM, Jason Stephenson wrote:
> I have more information.  When I try the back end call used by Syrup to
> fetch copy counts with a record from the course that blows up, I get the
> following:
> 
> srfsh# request open-ils.storage
> open-ils.storage.biblio.record_entry.status_copy_location_count.atomic
> [4211388, 160, 0]
> 
> Received Exception:
> Name: osrfMethodException
> Status:  *** Call to
> [open-ils.storage.biblio.record_entry.status_copy_location_count.atomic]
> failed for session [1539000573.516499.153900057325003], thread trace [1]:
> DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer:
> "ARRAY(0xebc67e0)"
> LINE 16:           WHERE cn.record = 'ARRAY(0xebc67e0)'
>                                      ^ [for Statement "
>         SELECT  cp.circ_lib,
>                 CASE WHEN cnp.id > -1 THEN cnp.label ELSE '' END,
>                 cn.label,
>                 CASE WHEN cns.id > -1 THEN cns.label ELSE '' END,
>                 oils_i18n_xlate('asset.copy_location', 'acpl', 'name',
> 'id', cl.id::TEXT, ?),
>                 cp.status,
>                 count(cp.id)
>           FROM  asset.copy cp,
>             asset.call_number cn,
>             asset.call_number_suffix cns,
>             asset.call_number_prefix cnp,
>             asset.copy_location cl,
>             config.copy_status cs,
>             actor.org_unit_descendants(?,?) d
>           WHERE cn.record = ?
>             AND cnp.id = cn.prefix
>             AND cns.id = cn.suffix
>             AND cp.call_number = cn.id
>             AND cp.location = cl.id
>             AND cp.circ_lib = d.id
>             AND cp.status = cs.id
>             AND cl.opac_visible IS TRUE
>             AND cp.opac_visible IS TRUE
>             AND cp.deleted IS FALSE
>             AND cl.deleted IS FALSE
>             AND cs.opac_visible IS TRUE
>           GROUP BY 1,2,3,4,5,6;
> " with ParamValues: 1='en-US', 2='1', 3='0', 4='ARRAY(0xebc67e0)'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
> 
> 
> Status: 500
> ------------------------------------
> Request Completed Successfully
> Request Time in seconds: 0.215329
> ------------------------------------
> 
> So, a database error is definitely not JSON.
> 
> Looks like this one could be headed for Launchpad.
>