Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    ANA: Cross Join Error when use ELink Query Subject

    • Article Type: General
    • Product: Voyager
    • Product Version: 1

    Description:
    Bug Report Form for Issue 16384-5570 / VYG-4699
    Module(s): Analyzer
    Server platform(s) affected: all
    PC OS (if applicable): n/a
    Browser & version (if applicable): IE 7

    Release(s) replicated in:
    Last version without bug (if applicable): n/a

    Expected results:
    In the Cataloging Package for Query Studio under the Presentation Layer any query subject (Bib Record, MFHD Record, etc) + ELink query subject will result in a report being produced.

    Actual results:
    When one tries to create a report using the ELink Query Subject and any other Query Subject (Bib Record, MFHD Record, etc) under the Presentation Layer a cross join error is received.
    The report appears to work when you run it with no data, but when any data is added limited or all data the error appears. The Query Subjects are in the same namespace. This shouldn’t get a cross join error.


    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


    Workflow implications: Librarians are unable to create reports using the Query Subject ‘E-Link’ in Query Studio.

    Replication steps: Log on to Analyzer, Go to Query Studio for Cataloging, Choose to run a report with limited or all data, Go to the Presentation Layer and choose any Query Subject under the presentation layer and the Query Subject ‘E-Link’. Receive a cross join error.

    Workaround: Create the report in Report Studio.

    Resolution:
    VYG-4699 is resolved in Voyager 9.0.0 and higher.


    • Article last edited: 3/18/2014
    //doorbell.io feedback widged