Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Voyager
    Ex Libris Knowledge Center

    ANA: Cross Join Error when use ELink Query Subject

    1. Last updated
    2. Save as PDF
    • Product: Voyager

    Symptoms

    • Try to create report using ELink Query Subject and any other Query Subject (Bib Record, MFHD Record, etc) under the Presentation Layer a cross join error is received.
    • Report appears to work when run with no data, but when any data added, limited or all data, error appears. Query Subjects are in the same namespace.

    Error

    RQP-DEF-0103
    Cross joins (between query subjects: ELink Index, ELink Record Type, Bib Record) 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-03-06-12:42:30.801-#3 RQP-DEF-0103 Cross joins (between query subjects: ELink Index, ELink Record Type, Bib Record) 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-03-06-12:42:30.801-#3

    Defect Status

    Issue 16384-5570 / VYG-4699 is resolved for Voyager 9.0.0 and higher.

    Replication Steps

    1. Log on to Analyzer
    2. Query Studio for Cataloging > Choose to run a report with limited or all data
    3. In Presentation Layer, choose any Query Subject under the presentation layer and the Query Subject ‘E-Link’
    4. Receive cross join error.

    Workaround

    Create the report in Report Studio.

    • Article last edited: 12-Jul-2018