Question

Org.hibernate.exception.SQLGrammarException - Cannot Login

  • 6 December 2022
  • 3 replies
  • 548 views

Userlevel 1
Badge +8

I cannot explain this long enough but all the service are running, we did nothing to the account and somehow we got this error saying “Org.hibernate.exception.SQLGrammarException”

I posted the full error, why is this happening? and why can’t i open old question related to this?

 


3 replies

Userlevel 7
Badge +13

Hi @David Jansen ,

 

APeople forum has been shifted to the all-new Pathfinder community and currently the access to older stuffs is restricted.

 

By seeing the error code “SQLGrammarException” indicates that the SQL sent to the database was invalid. It could be due to a syntax error or an invalid object reference. Or the Drive hosting DB transaction logs in SQL might be full for which you may involve your DBA team. Check below link for further on this.

https://apeople.automationanywhere.com/s/article/Error-org-hibernate-exception-SQLGrammarException-could-not-execute-batch

Userlevel 6
Badge +16

Hi @David Jansen 

If you have access to database HDD which stores transactions logs, check whether the space is full. If not please get in touch with your Database Admin team.

Userlevel 5
Badge +9

Hi @David Jansen ,

Please share us the control-room version.

Check the follow KBs. 

Drive hosting DB transaction logs in SQL might be full.

https://apeople.automationanywhere.com/s/article/Error-org-hibernate-exception-SQLGrammarException-could-not-execute-batch

Verify if you can navigate to Devices section.

https://apeople.automationanywhere.com/s/article/A2019-My-devices

HTH

Regards

Reply