Error on EU instance when loading API services

Jorg_Beyer · September 19, 2024, 8:40am

Hi team,

when loading the backend console I encounter the following:

Application ID: 66C2DBD4-189A-7377-FF95-915D98235700
Error UID: 97112703-9712-47E0-BA92-458FCDDFC7E0

Backendless encountered an error while handling the request. An internal trouble ticket with ID bl-server:97112703-9712-47E0-BA92-458FCDDFC7E0 has been created and we will be investigating the issue.
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at com.backendless.datamodel.application.dao.LocalServiceDao.lambda$findAll$11(LocalServiceDao.java:182)
	at com.backendless.datamodel.application.dao.AppJpaContext.executeSync(AppJpaContext.java:228)
	at com.backendless.datamodel.application.dao.AppJpaContext.execute(AppJpaContext.java:60)
	at com.backendless.datamodel.application.dao.LocalServiceDao.findAll(LocalServiceDao.java:174)
	at com.backendless.management.servercode.service.CustomServiceManagement.lambda$getLocalServices$5(CustomServiceManagement.java:230)
	at com.backendless.datamodel.application.dao.AppJpaContext.executeSync(AppJpaContext.java:228)
	at com.backendless.datamodel.application.dao.AppJpaContext.lambda$execute$0(AppJpaContext.java:54)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
	at com.backendless.async.BackendlessExecutorService.lambda$execute$2(BackendlessExecutorService.java:159)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:840)
	Suppressed: java.util.concurrent.ExecutionException: java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
		at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
		at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
		at com.backendless.async.AsyncUtils.safeGet(AsyncUtils.java:68)
		at com.backendless.management.servercode.service.CustomServiceManagement.getLocalServices(CustomServiceManagement.java:229)
		at controllers.console.CustomServiceController.lambda$getLocalServices$0(CustomServiceController.java:144)
		at com.backendless.async.BackendlessExecutorService.lambda$submit$0(BackendlessExecutorService.java:83)
		... 3 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarExc

Problem description

When loading API services in Backendless the error occurs right away

Steps to reproduce

Please describe steps to reproduce starting from the first action.

Open Backendless
Click on API Services

Nikita_Fedorishchev · September 19, 2024, 9:26am

Hello, @Jorg_Beyer.

Thank you for you report.
Our developers are currently investigating this problem.

Regards, Nikita.

Jorg_Beyer · September 19, 2024, 9:03pm

Hello,

do you finde the problem and have a solution at hand? My backend is kind of unusable, many timer are not running, hence, many data are not updated.

Regards, Joerg

mark-piller · September 19, 2024, 9:11pm

Hi Joerg,

We found the problem, but a solution is not available right now. We’re still working on it. It will be fixed as soon as humanly possible, this is our top priority.

Regards,
Mark

Jorg_Beyer · September 19, 2024, 9:15pm

Hi Mark,

thank you for letting me know the status.

Regards, Joerg

Jorg_Beyer · September 20, 2024, 8:00am

Hi,

it seems to be fixed now, thank you for that.
But, how can I restart a timer that does not run on its schedule today?

Regards, Joerg

Volodymyr_Ialovyi · September 20, 2024, 9:53am

Hello @Jorg_Beyer

Try moving the toggle to the disable position opposite the timer you want to restart, and then to the enable position again.

Regards,
Volodymyr