Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. ANA: Cross Join Error when use query subject Item Barcode

    ANA: Cross Join Error when use query subject Item Barcode

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Symptoms
    2. Defect Status
    3. Replication Steps
    4. Workaround
    • Article Type: General
    • Product: Voyager
    • Product Version: 1

    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ANA: Cross Join Error when use ELink Query Subject
      • ANA: Error message when running as any format other than HTML
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. voy-resolved-9
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved