Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. Saved complex queries retrieves blank screen

    Saved complex queries retrieves blank screen

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Primo

    Problem Symptoms:
    - A complex query is saved. For example, an "exact search refined by 4 facets.
    - When clicking on the saved query in Internet Explorer browser, and empty page is opened.
    - FE log shows:
    2014-01-13 14:13:54,665 ERROR [t-http-0.0.0.0-1701-208] [c-BaseAction

    Cause:
    A bug

    Resolution:
    Being investigated by development in PRM-20259

    Additional Information

    In some cases it is impossible to save complex queries. After click on "save" nothing happens. The error in the log is the following:
    2014-01-13 14:09:23,815 ERROR [t-http-0.0.0.0-1701-320] [c-JDBCExceptionReporter] - ORA-01400: cannot insert NULL into ("P41_PRM00"."U_SAVED_SEARCH"."URL")
    2014-01-13 14:09:23,815 ERROR [t-http-0.0.0.0-1701-320] [c-AbstractFlushingEventListener] - Could not synchronize database state with session
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)


    • Article last edited: 1/27/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Save query option is missing
      • Save/Mail from OPAC (or OPAC via Primo) not working: doc_number is not filled
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. contype:kba
      2. Prod:Primo
      3. Type:General
    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