ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to 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
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
Comments
-
Another screenshot of our dashboard on test system
------------------------------
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
-------------------------------------------
Original Message:
Sent: 08-16-2023 05:13
From: Sandra Wiegratz
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemHi
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
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
0 -
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!
------------------------------
Carly Rossi // she/her/hers
Community Program Manager // Jama Software
Portland, OR
------------------------------
-------------------------------------------
Original Message:
Sent: 08-16-2023 05:16
From: Sandra Wiegratz
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemAnother screenshot of our dashboard on test system
------------------------------
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
Original Message:
Sent: 08-16-2023 05:13
From: Sandra Wiegratz
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemHi
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
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
0 -
This issue can be closed. After clearing the cache and using the "Fix URL" feature in admin portal everything works properly.
------------------------------
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
-------------------------------------------
Original Message:
Sent: 08-16-2023 08:49
From: Carly Rossi
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemHi 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!
------------------------------
Carly Rossi // she/her/hers
Community Program Manager // Jama Software
Portland, OR
------------------------------
Original Message:
Sent: 08-16-2023 05:16
From: Sandra Wiegratz
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemAnother screenshot of our dashboard on test system
------------------------------
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
Original Message:
Sent: 08-16-2023 05:13
From: Sandra Wiegratz
Subject: ERROR: PROCEDURE [dbname].WITH_EMULATOR after import of (live) database to test systemHi
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
Sandra Wiegratz
MeVis BreastCare GmbH & Co. KG
------------------------------
0
![[Deleted User]](https://w5.vanillicon.com/v2/50cd6d7991a75ded6036af665a40e288.svg)