After importing a database dump of our live system to a test system we are stuck with errors when opening any of the projects.
2023-08-16 11:46:33,920 ERROR http-nio-8080-exec-10 [testdbname] [c841ec] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - PROCEDURE [testdbname].WITH_EMULATOR does not exist2023-08-16 11:46:33,922 WARN http-nio-8080-exec-10 [testdbname] [c841ec] [com.jamasoftware.contour.search.dwr.impl.DwrSmartFilterServiceImpl] - Can't parse filter.org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)[...]
Did anyone encountered such an issue as well? Jama version is 8.66.1 (live), 8.66.2 (test)
The error is not only logged in correlation with filters, but also with single items.
The filter called on the screenshot does definitely not have over one million items ...
Thanks, best regardsSandra
Another screenshot of our dashboard on test system
In order to get a full understanding of what's prompting those errors, I'd recommend partnering with our Support team -- this would allow us to dig in deeper and discuss information specific to your instance. To do so, please file Support ticket HERE, including both a link to this thread for context and HAR files plus support bundle (if possible).
This issue can be closed. After clearing the cache and using the "Fix URL" feature in admin portal everything works properly.
HEADQUARTERS|135 SW Taylor Suite 200, Portland, Oregon, 97204