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: Error message when running as any format other than HTML

    ANA: Error message when running as any format other than HTML

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Voyager
    • Product Version: 7.2.1

    Description:
    Bug Report Form for Issue 16384-16017

    Module(s): Voyager Analyzer
    Server platform(s) affected: Sun, Linux
    PC OS (if applicable): N/A
    Browser & version (if applicable): N/A

    Expected results:
    Should be able to use Outstanding Charges and Archived charges in the same report and
    Be able to generate all report formats – not just HTML in report CIRC - DJ - Recent charged items

    Actual results: An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'. Seems to happen when using Outstanding Charges and Archived Charges in the same report. Very large result set is returned. Only happens when running report in a format other than HTML

    Workflow implications: May not be able to get report in desired format.

    Replication steps:
    Log in.
    Go to Query Studio.
    Choose Circ package.
    Open Charge Transactions.
    Open Outstanding Charges.
    Drag over Item ID.
    Open Archived Charges. (Yes, this is not the same query subject and ends up giving bad data...but it still GIVES data)
    Drag over Location Code
    Open Outstanding Charges.
    Drag over Charge Date.
    Open Title Details
    Drag over Title.
    Drag over Publisher Date.
    Drag over Display Call No.
    Filter on Location Code.
    Filter on Charge Date.
    Run report in any format other than html.

    Other information:

    Workaround: Use HTML output format

    Resolution:
    Fixed in Analyzer for 8.2.0.

    The solution is to change the processing to “Limited Local” from “Database Only”. This can be done from the Report Studio:

    1. Open the report in Report Studio
    2. Select the query
    3. Under Properties --> Query, change Processing to Limited Local
    4. Save the report


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ANA: Cross Join Error when use query subject Item Barcode
      • Ana: MFHD Update Date filter does not provide date range in Query Studio
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. voy-resolved-8
    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