Surely, all of them ran when i checked from the community-app expect for
one job i.e "Update Non Performing Assets" below is the error thread.
*org.springframework.dao.DeadlockLoserDataAccessException:
StatementCallback; SQL [update m_loan loan left join m_loan_arrears_aging
laa on laa.loan_id = loan.id inner join m_product_loan mpl on mpl.id =
loan.product_id and mpl.overdue_days_for_npa is not null set loan.is_npa =
0 where loan.loan_status_id = 300 and
mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
(mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
laa.overdue_since_date_derived is null)]; Deadlock found when trying to get
lock; try restarting transaction; nested exception is
java.sql.SQLTransactionRollbackException: Deadlock found when trying to get
lock; try restarting transaction at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(263)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(73)
at org.springframework.jdbc.core.JdbcTemplate.execute(413) at
org.springframework.jdbc.core.JdbcTemplate.update(546) at
org.apache.fineract.scheduledjobs.service.ScheduledJobRunnerServiceImpl.updateNPA(268)
at sun.reflect.NativeMethodAccessorImpl.invoke0(-2) at
sun.reflect.NativeMethodAccessorImpl.invoke(62) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(43) at
java.lang.reflect.Method.invoke(498) at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(98)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(262)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(95)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(207) at
com.sun.proxy.$Proxy224.updateNPA(-1) at
sun.reflect.NativeMethodAccessorImpl.invoke0(-2) at
sun.reflect.NativeMethodAccessorImpl.invoke(62) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(43) at
java.lang.reflect.Method.invoke(498) at
org.springframework.util.MethodInvoker.invoke(269) at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(322)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(112) at
org.quartz.core.JobRunShell.run(213) at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(557)*Thanks
Ippez
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
