Web client reporter: connection between Circulation (& co.) and Simple Record Extracts Broken

[Chris Sharp]

In the web client reporter, building a template from Circulation or Combined Aged and Active Circulations fails when attempting to get to Simple Record Extracts (Circulation -> Bib Record -> Simple Record Extracts) fails with the following:

DBD::Pg::st execute failed: ERROR: column 09d67bc7876bdbcaa9eb5fd5f6a7b4be.simple_record does not exist
LINE 6: ..._record AS "a79681f6d18a7689b2dfed2923939952" ON ("09d67bc78...
                                                             ^ at /openils/bin/clark-kent.pl line 255.

(full error message attached)

Evergreen 3.0.2+
OpenSRF 3.0.1
PostgreSQL 9.5
Ubuntu 16.04

[Beth Willis (willis-a)]

I could not replicate this problem. I created a template using the Combined Aged and Active Circulations Source as my initial source. I was able to link to the Bib Record and Simple Record Extracts sources and to run the report successfully.

I have attached the report SQL highlighting one difference from Chris' SQL where the join between reporter.materialized_simple_record and biblio.record_entry included a reference to a "simple_record" field:

 INNER JOIN reporter.materialized_simple_record AS "a79681f6d18a7689b2dfed2923939952" ON ("09d67bc7876bdbcaa9eb5fd5f6a7b4be"."simple_record" = "a79681f6d18a7689b2dfed2923939952"."id")

EG 3.2-beta 1

[Chris Sharp (chrissharp123)]

Marking High priority because it's affecting multiple PINES users. I'll see if I can replicate it on stock Evergreen.

[Chris Sharp (chrissharp123)]

Okay, I can confirm Beth's finding that the problem is not present on a server running recent stock Evergreen master. I will work to discover the difference between the two. Sigh...