API tools faq
paste
Fanadia_Friska

error upload trial balance

Fanadia_Friska
May 18th, 2020
36
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.15 KB | None | 0 0
raw download clone embed print report
  1. ERROR 1 --- [erContainer#0-1] o.s.batch.core.step.AbstractStep : Encountered an error executing step step3 in job genericUploadCsv
  2.  
  3. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  4. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
  5. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  6. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  7. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  8. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  9. at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  10. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:387) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  11. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet.execute(CallFunctionTasklet.java:47) ~[classes!/:na]
  12. at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source) ~[na:na]
  13. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
  14. at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
  15. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  16. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  17. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  18. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  19. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  20. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  21. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  22. at com.sun.proxy.$Proxy83.execute(Unknown Source) ~[na:na]
  23. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  24. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  25. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  26. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  27. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  28. at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  29. at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  30. at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  31. at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  32. at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:203) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  33. at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  34. at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  35. at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  36. at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  37. at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  38. at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:136) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  39. at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:313) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  40. at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:144) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  41. at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50) [spring-core-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  42. at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:137) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  43. at org.jleaf.erp.tools.datauploader.processor.GenericFileProcessor.onMessage(GenericFileProcessor.java:161) [classes!/:na]
  44. at org.springframework.jms.listener.adapter.MessageListenerAdapter.onMessage(MessageListenerAdapter.java:211) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  45. at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:736) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  46. at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:696) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  47. at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  48. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:318) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  49. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:257) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  50. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1189) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  51. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1179) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  52. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1076) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  53. at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212]
  54. Caused by: org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  55. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
  56. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468) ~[postgresql-42.2.6.jar!/:42.2.6]
  57. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211) ~[postgresql-42.2.6.jar!/:42.2.6]
  58. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:309) ~[postgresql-42.2.6.jar!/:42.2.6]
  59. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) ~[postgresql-42.2.6.jar!/:42.2.6]
  60. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) ~[postgresql-42.2.6.jar!/:42.2.6]
  61. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:311) ~[postgresql-42.2.6.jar!/:42.2.6]
  62. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:297) ~[postgresql-42.2.6.jar!/:42.2.6]
  63. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:274) ~[postgresql-42.2.6.jar!/:42.2.6]
  64. at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:225) ~[postgresql-42.2.6.jar!/:42.2.6]
  65. at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) ~[HikariCP-3.4.2.jar!/:na]
  66. at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-3.4.2.jar!/:na]
  67. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet$1.doInStatement(CallFunctionTasklet.java:52) ~[classes!/:na]
  68. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet$1.doInStatement(CallFunctionTasklet.java:47) ~[classes!/:na]
  69. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:375) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  70. ... 43 common frames omitted
  71.  
  72. AFTER JOB : {uploadHeaderId=69, quote=", functionName=ul_upload_trial_balance, delimiter=;, filePath=file:/erp-enterprise/upload/1722ac02088-TemplateImportTrialBalance.csv, tenantId=10, typeName=UploadTrialBalance, uploadTypeId=27, userId=270}
  73. 2020-05-19 09:25:34.016 ERROR 1 --- [erContainer#0-1] o.j.e.t.d.l.GenericJobExecutionListener : Errors : StatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  74. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
  75. 2020-05-19 09:58:53.206 ERROR 1 --- [erContainer#0-1] o.s.batch.core.step.AbstractStep : Encountered an error executing step step3 in job genericUploadCsv
  76.  
  77. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  78. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
  79. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  80. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  81. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  82. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  83. at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  84. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:387) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  85. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet.execute(CallFunctionTasklet.java:47) ~[classes!/:na]
  86. at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source) ~[na:na]
  87. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
  88. at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
  89. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  90. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  91. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  92. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  93. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  94. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  95. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  96. at com.sun.proxy.$Proxy83.execute(Unknown Source) ~[na:na]
  97. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  98. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  99. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  100. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  101. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  102. at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  103. at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  104. at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145) ~[spring-batch-infrastructure-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  105. at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  106. at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:203) ~[spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  107. at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  108. at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  109. at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  110. at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  111. at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  112. at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:136) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  113. at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:313) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  114. at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:144) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  115. at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50) [spring-core-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  116. at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:137) [spring-batch-core-4.1.2.RELEASE.jar!/:4.1.2.RELEASE]
  117. at org.jleaf.erp.tools.datauploader.processor.GenericFileProcessor.onMessage(GenericFileProcessor.java:161) [classes!/:na]
  118. at org.springframework.jms.listener.adapter.MessageListenerAdapter.onMessage(MessageListenerAdapter.java:211) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  119. at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:736) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  120. at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:696) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  121. at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  122. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:318) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  123. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:257) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  124. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1189) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  125. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1179) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  126. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1076) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  127. at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212]
  128. Caused by: org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  129. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
  130. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468) ~[postgresql-42.2.6.jar!/:42.2.6]
  131. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211) ~[postgresql-42.2.6.jar!/:42.2.6]
  132. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:309) ~[postgresql-42.2.6.jar!/:42.2.6]
  133. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) ~[postgresql-42.2.6.jar!/:42.2.6]
  134. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) ~[postgresql-42.2.6.jar!/:42.2.6]
  135. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:311) ~[postgresql-42.2.6.jar!/:42.2.6]
  136. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:297) ~[postgresql-42.2.6.jar!/:42.2.6]
  137. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:274) ~[postgresql-42.2.6.jar!/:42.2.6]
  138. at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:225) ~[postgresql-42.2.6.jar!/:42.2.6]
  139. at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) ~[HikariCP-3.4.2.jar!/:na]
  140. at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-3.4.2.jar!/:na]
  141. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet$1.doInStatement(CallFunctionTasklet.java:52) ~[classes!/:na]
  142. at org.jleaf.erp.tools.datauploader.tasklet.CallFunctionTasklet$1.doInStatement(CallFunctionTasklet.java:47) ~[classes!/:na]
  143. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:375) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  144. ... 43 common frames omitted
  145.  
  146. AFTER JOB : {uploadHeaderId=70, quote=", functionName=ul_upload_trial_balance, delimiter=;, filePath=file:/erp-enterprise/upload/1722adea1f9-TemplateImportTrialBalance.csv, tenantId=10, typeName=UploadTrialBalance, uploadTypeId=27, userId=270}
  147. 2020-05-19 09:58:53.213 ERROR 1 --- [erContainer#0-1] o.j.e.t.d.l.GenericJobExecutionListener : Errors : StatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "vactionerror" does not exist
  148. Where: PL/pgSQL function ul_upload_trial_balance(bigint) line 98 at SQL statement
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!