Support

Hi

After importing a database dump of our live system to a test system we are stuck with errors when opening any of the projects.

From log:

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 exist
2023-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 regards
Sandra

Another screenshot of our dashboard on test system

Hi

After importing a database dump of our live system to a test system we are stuck with errors when opening any of the projects.

From log:

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 exist
2023-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 regards
Sandra

Hi Sandra, 

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).  

Thanks!

Another screenshot of our dashboard on test system

Hi

After importing a database dump of our live system to a test system we are stuck with errors when opening any of the projects.

From log:

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 exist
2023-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 regards
Sandra