Fill the form details from the database based on the input from the author | Community
Skip to main content
ShaileshBassi
Community Advisor
Community Advisor
July 1, 2022

Fill the form details from the database based on the input from the author

  • July 1, 2022
  • 2 replies
  • 941 views

Input from the Author- Employee Id

Expectation - Prefill the rest of the fields in the form after getting the result related to that employee id from MySQL Server
Form Model Used - FDM

FDM Details:

Rule Editor Config:

 

Error coming up in the logs.

 

01.07.2022 17:12:30.777 *ERROR* [[0:0:0:0:0:0:0:1] [1656675750770] POST /content/forms/af/training/af-with-input-for-fdm-employee-association-beneficiary/jcr:content/guideContainer.af.dermis HTTP/1.1] com.adobe.aemds.guide.addon.expeditor.servlet.ExpEditorServiceManager Error while making web service related call com.adobe.aem.dermis.exception.DermisException: AEM-FDM-001-012: Missing input for required argument - empID. at com.adobe.aem.dermis.core.service.QueryParser.autoCoerceInputAndSetDataInDataContext(QueryParser.java:226) [aem-dermis-core:3.0.182] at com.adobe.aem.dermis.core.bridge.impl.DermisBridge.executeOperation(DermisBridge.java:168) [aem-dermis-core:3.0.182] at com.adobe.aemds.guide.addon.expeditor.servlet.ExpEditorServiceManager.invokeFDMOperation(ExpEditorServiceManager.java:466) [com.adobe.aemds.guide.aemds-guide-addon-impl:6.0.388] at com.adobe.aemds.guide.addon.expeditor.servlet.ExpEditorServiceManager.doPost(ExpEditorServiceManager.java:486) [com.adobe.aemds.guide.aemds-guide-addon-impl:6.0.388] at org.apache.sling.api.servlets.SlingAllMethodsServlet.mayService(SlingAllMethodsServlet.java:146) [org.apache.sling.api:2.22.0] at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:342) [org.apache.sling.api:2.22.0] at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:374) [org.apache.sling.api:2.22.0] at org.apache.sling.engine.impl.request.RequestData.service(RequestData.java:574) [org.apache.sling.engine:2.7.8] at org.apache.sling.engine.impl.filter.SlingComponentFilterChain.render(SlingComponentFilterChain.java:45) [org.apache.sling.engine:2.7.8] at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:88) [org.apache.sling.engine:2.7.8] at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilterWithErrorHandling(WCMDebugFilter.java:192) [com.day.cq.wcm.cq-wcm-core:5.12.198]

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Mayank_Gandhi
Adobe Employee
Adobe Employee
July 1, 2022

@shaileshbassi is this working via test UI? Can you test UI Request object vs request via forms

Level 4
July 4, 2022

That error looks similar to the one in your previous post, where you weren't seeing the empID in stdlog.out

 

Can you provide more detail on what you have done?

 

Are you using the same form, based on template FDMDemo?

I cannot see the url on the screenshot of your rendered form. Are you passing empID?

 

Also, did you create a new Service or trying to use the default get service?