Issue with egive-persistence service to save data in the database

[nsrivastava2]

egove-persistence service is there to save data into the database.

Issue/Steps
While creating a vendor data after port forwarding the request is success , but eventually got failed while saving data in to the table using egov-persistence service

Our persister service ran into a problme with the "fsm-persister.yaml" file. The team suggested a quick fix by removing it for now while they look into the issue. After removing the file, everything seems to be back on track. Now, they recommend creating a vendor from the API, but we're facing some challenges. Could you please take a peek at the persisted logs for more insights?

Error:

[10:17 pm, 09/11/2023] Narendra: org.springframework.kafka.listener.ListenerExecutionFailedException: Listener failed; nested exception is com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
[10:18 pm, 09/11/2023] Narendra: org.springframework.kafka.listener.ListenerExecutionFailedException: Listener failed; nested exception is com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.decorateException(KafkaMessageListenerContainer.java:1790)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeErrorHandler(KafkaMessageListenerContainer.java:1779)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeRecordListener(KafkaMessageListenerContainer.java:1692)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeWithRecords(KafkaMessageListenerContainer.java:1618)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeRecordListener(KafkaMessageListenerContainer.java:1521)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeListener(KafkaMessageListenerContainer.java:1262)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.pollAndInvoke(KafkaMessageListenerContainer.java:1009)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.run(KafkaMessageListenerContainer.java:929)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
        at com.jayway.jsonpath.internal.path.EvaluationContextImpl.getValue(EvaluationContextImpl.java:133)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:187)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:164)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:147)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:488)
        at org.egov.infra.persist.repository.PersistRepository.getRows(PersistRepository.java:132)
        at org.egov.infra.persist.repository.PersistRepository.persist(PersistRepository.java:52)
        at org.egov.infra.persist.repository.PersistRepository$$FastClassBySpringCGLIB$$77cf0bad.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
        at org.egov.infra.persist.repository.PersistRepository$$EnhancerBySpringCGLIB$$7adf06a8.persist(<generated>)
        at org.egov.infra.persist.service.PersistService.persist(PersistService.java:48)
        at org.egov.infra.persist.service.PersistService$$FastClassBySpringCGLIB$$620e222d.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
        at org.egov.infra.persist.service.PersistService$$EnhancerBySpringCGLIB$$14c5ba5f.persist(<generated>)
        at org.egov.infra.persist.consumer.PersisterMessageListener.onMessage(PersisterMessageListener.java:33)
        at org.egov.infra.persist.consumer.PersisterMessageListener.onMessage(PersisterMessageListener.java:14)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeOnMessage(KafkaMessageListenerContainer.java:1756)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeOnMessage(KafkaMessageListenerContainer.java:1724)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeRecordListener(KafkaMessageListenerContainer.java:1679)
        ... 8 common frames omitted

[support-upyog]

egove-persistence service is there to save data into the database.

Issue/Steps While creating a vendor data after port forwarding the request is success , but eventually got failed while saving data in to the table using egov-persistence service

Our persister service ran into a problme with the "fsm-persister.yaml" file. The team suggested a quick fix by removing it for now while they look into the issue. After removing the file, everything seems to be back on track. Now, they recommend creating a vendor from the API, but we're facing some challenges. Could you please take a peek at the persisted logs for more insights?

Error:

[10:17 pm, 09/11/2023] Narendra: org.springframework.kafka.listener.ListenerExecutionFailedException: Listener failed; nested exception is com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
[10:18 pm, 09/11/2023] Narendra: org.springframework.kafka.listener.ListenerExecutionFailedException: Listener failed; nested exception is com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.decorateException(KafkaMessageListenerContainer.java:1790)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeErrorHandler(KafkaMessageListenerContainer.java:1779)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeRecordListener(KafkaMessageListenerContainer.java:1692)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeWithRecords(KafkaMessageListenerContainer.java:1618)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeRecordListener(KafkaMessageListenerContainer.java:1521)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeListener(KafkaMessageListenerContainer.java:1262)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.pollAndInvoke(KafkaMessageListenerContainer.java:1009)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.run(KafkaMessageListenerContainer.java:929)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.jayway.jsonpath.PathNotFoundException: No results for path: $['vendor']['agencyType']
        at com.jayway.jsonpath.internal.path.EvaluationContextImpl.getValue(EvaluationContextImpl.java:133)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:187)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:164)
        at com.jayway.jsonpath.internal.JsonContext.read(JsonContext.java:147)
        at com.jayway.jsonpath.JsonPath.read(JsonPath.java:488)
        at org.egov.infra.persist.repository.PersistRepository.getRows(PersistRepository.java:132)
        at org.egov.infra.persist.repository.PersistRepository.persist(PersistRepository.java:52)
        at org.egov.infra.persist.repository.PersistRepository$$FastClassBySpringCGLIB$$77cf0bad.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
        at org.egov.infra.persist.repository.PersistRepository$$EnhancerBySpringCGLIB$$7adf06a8.persist(<generated>)
        at org.egov.infra.persist.service.PersistService.persist(PersistService.java:48)
        at org.egov.infra.persist.service.PersistService$$FastClassBySpringCGLIB$$620e222d.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
        at org.egov.infra.persist.service.PersistService$$EnhancerBySpringCGLIB$$14c5ba5f.persist(<generated>)
        at org.egov.infra.persist.consumer.PersisterMessageListener.onMessage(PersisterMessageListener.java:33)
        at org.egov.infra.persist.consumer.PersisterMessageListener.onMessage(PersisterMessageListener.java:14)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeOnMessage(KafkaMessageListenerContainer.java:1756)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeOnMessage(KafkaMessageListenerContainer.java:1724)
        at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeRecordListener(KafkaMessageListenerContainer.java:1679)
        ... 8 common frames omitted

JIRA Ticket NUDM-190 has been booked for the same.

[support-upyog]

It seems that your JSON path is wrong. Kindly check the path.

[nsrivastava2]

We do not have JIRA access.

[support-upyog]

Please check your JSON path.