ANA:RQP-DEF-0103 Cross joins are not permitted for the user

Symptoms

Users receive error RQP-DEF-0103 when adding related items from two different areas of the Presentation layer to a query.

Defect Status

Issue 16384-9297 / VYG-4449 is currently in Development.

Replication Steps

1. Analyzer>Query Studio>Acquisitions Package
2. Create a query that has data from Presentation Layer>Purchase Orders>PO Line Item Copy Funds > PO Line Item Copy Funds and make sure some of the data is PO specific (PO Number, PO Type, PO Status, etc.)
3. Add a different PO data item from Presentation Layer> Purchase Orders>Purchase Order>Purchase Order. You will receive the following Cross Join Error.

RQP-DEF-0103

Cross joins (between query subjects: Purchase Order (PO), PO Line Item Copy Funds) are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Voyager Analyzer Acq Technical Author, Voyager Analyzer Media Technical Author, Voyager Analyzer UB Technical Author, Voyager Analyzer DB Model Technical Author, Voyager Analyzer SysAdmin Technical Author, Voyager Analyzer Opac Technical Author, Voyager Analyzer sup653db DB Model Technical Author, Voyager Analyzer sup653db SysAdmin Technical Author, Voyager Analyzer sup653db Cat Technical Author, Voyager Analyzer sup653db Acq Technical Author, Voyager Analyzer sup653db Circ Technical Author, Voyager Analyzer sup653db Media Technical Author, Voyager Analyzer sup653db Opac Technical Author, Voyager Analyzer sup653db Remote Storage Technical Author, Voyager Analyzer sup653db UB Technical Author, Voyager Analyzer Remote Storage 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, Voyager Analyzer Technical Author Remote storage, Voyager Analyzer Technical Author Universal Borrowing}'.

Workaround

Be sure all of the query items are from the same path in the presentation layer.

• Article last edited: 08-Oct-2013