Skip to main content
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