ANA: Cross Join Error when use query subject Item Barcode

Symptoms

• Create report using Charge Transactions Namespace and the Query Subjects "Item Barcode" and "All Charges" and receive cross join error even though Query Subjects are in same namespace
• Same errors with any Query Subjects linked to Item Barcode

Error:
RQP-DEF-0103
Cross joins (between query subjects: Item_Barcode, All Charges) are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Voyager Analyzer yyydb DB Model Technical Author, Voyager Analyzer yyydb SysAdmin Technical Author, Voyager Analyzer yyydb Cat Technical Author, Voyager Analyzer yyydb Acq Technical Author, Voyager Analyzer yyydb Circ Technical Author, Voyager Analyzer yyydb Media Technical Author, Voyager Analyzer yyydb Opac Technical Author, Voyager Analyzer Acq Technical Author, Voyager Analyzer Media Technical Author, Voyager Analyzer DB Model Technical Author, Voyager Analyzer SysAdmin Technical Author, Voyager Analyzer Opac Technical Author, Voyager Analyzer Cat Technical Author, Voyager Analyzer Circ Technical Author, Voyager Analyzer Technical Author Database Model, Voyager Analyzer Technical Author System Administration, Voyager Analyzer Technical Author Cataloging, Voyager Analyzer Technical Author Acquisitions/Serials, Voyager Analyzer Technical Author Circulation and Call Slip, Voyager Analyzer Technical Author Media Scheduling, Voyager Analyzer Technical Author OPAC}'.

Details:
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-01-16-14:32:07.451-#7 RQP-DEF-0103 Cross joins (between query subjects: Item_Barcode, All Charges) are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Voyager Analyzer yyydb DB Model Technical Author, Voyager Analyzer yyydb SysAdmin Technical Author, Voyager Analyzer yyydb Cat Technical Author, Voyager Analyzer yyydb Acq Technical Author, Voyager Analyzer yyydb Circ Technical Author, Voyager Analyzer yyydb Media Technical Author, Voyager Analyzer yyydb Opac Technical Author, Voyager Analyzer Acq Technical Author, Voyager Analyzer Media Technical Author, Voyager Analyzer DB Model Technical Author, Voyager Analyzer SysAdmin Technical Author, Voyager Analyzer Opac Technical Author, Voyager Analyzer Cat Technical Author, Voyager Analyzer Circ Technical Author, Voyager Analyzer Technical Author Database Model, Voyager Analyzer Technical Author System Administration, Voyager Analyzer Technical Author Cataloging, Voyager Analyzer Technical Author Acquisitions/Serials, Voyager Analyzer Technical Author Circulation and Call Slip, Voyager Analyzer Technical Author Media Scheduling, Voyager Analyzer Technical Author OPAC}'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-01-16-14:32:07.451-#7

Defect Status

VYG-4686 is resolved in Voyager 9.0.0 and higher.

Replication Steps

1. Log on to Analyzer
2. Go to Query Studio for Circulation and Call Slips
3. Choose to run a report with limited or all data
4. Go to the namespace Charge Transactions and choose the Query Subjects All Charges and Item Barcode.
5. Receive cross join error

Workaround

Create the report in Report Studio.

• Article last edited: 18-Mar-2014