Highlighted

Test Form Data Model throwing error

Avatar

Avatar

Ashish23

Avatar

Ashish23

Ashish23

11-05-2020

I am using MySQL Workbench with AEM Forms in AEM 6.5.

After installing bundle mysql-connector-java-8.0.20.jar, able to fetch table in Form Data Model.

But when I try to test get/insert service, error message.

error1.PNG

I am getting below error in erro.log:

 

11.05.2020 14:59:36.792 *ERROR* [0:0:0:0:0:0:0:1 [1589189376783] POST /content/dam/formsanddocuments-fdm/xyz/test.executeDermisQuery.json HTTP/1.1] com.adobe.aem.dermis.core.servlet.DermisBridgeServlet Encountered an error while executing operation

 

I would appreciate if someone shares the solution.

Replies

Highlighted

Avatar

Avatar

Mayank_Gandhi

Employee

Avatar

Mayank_Gandhi

Employee

Mayank_Gandhi
Employee

11-05-2020

Looks like connection to DB is slow or breaking in between the call. Check SQL workbench if its able to execute the query

Highlighted

Avatar

Avatar

Ashish23

Avatar

Ashish23

Ashish23

11-05-2020

SQL workbench is working fine. I executed insert, update, create queries. All executed fine. Getting this issue always, although I can see tables in AEM form data model. Issue is while testing get/insertservices.
Highlighted

Avatar

Avatar

Mayank_Gandhi

Employee

Avatar

Mayank_Gandhi

Employee

Mayank_Gandhi
Employee

11-05-2020

Try to insert same values as DATA model from workbench.