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

    Saved complex queries retrieves blank screen

    • 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