Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Test Form Data Model throwing error

Avatar

Avatar
Ignite 1
Level 1
Ashish23
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Give Back
View profile

Avatar
Ignite 1
Level 1
Ashish23
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Give Back
View profile
Ashish23
Level 1

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

Avatar

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct Reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct Reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile
Mayank_Gandhi
Level 10

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

Avatar

Avatar
Ignite 1
Level 1
Ashish23
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Give Back
View profile

Avatar
Ignite 1
Level 1
Ashish23
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Give Back
View profile
Ashish23
Level 1

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.

Avatar

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct Reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct Reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile
Mayank_Gandhi
Level 10

11-05-2020

Try to insert same values as DATA model from workbench.