Hi
please help me
what multiline.pattern is good for my log?
My log contains blank line in the middle.
Thanks a lot.
2021-12-08 01:00:00.020 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.s.d.InputService :] : archiveDataAndDelete ...
2021-12-08 01:00:00.021 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.d.d.d.DbOperationRepository :] : archiveData
2021-12-08 01:00:00.021 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.d.d.d.DbOperationRepository :] : run insert into PCK.ARCH_PCK(tx_id, fin_txn, actn_dt, amnt, bnc_chq, brnch_cd, chnl_typ, cshr_bank_cd, cshr_brnch_cd, cshg_amnt, chq_sts, chq_typ, crdt_bic, crdt_iban, agnt_bic, dbt_bic, dbt_brnch_cd, dbt_iban, due_dt, isu_dt, mdia, rcpt_dt, req_typ, sayad_id, trnsfr_dt, tx_dsc) SELECT tx_id, fin_txn, actn_dt, amnt, bnc_chq, brnch_cd, chnl_typ, cshr_bank_cd, cshr_brnch_cd, cshg_amnt, chq_sts, chq_typ, crdt_bic, crdt_iban, agnt_bic, dbt_bic, dbt_brnch_cd, dbt_iban, due_dt, isu_dt, mdia, rcpt_dt, req_typ, sayad_id, trnsfr_dt, tx_dsc FROM FRD_DAILY.TEMP_PCK where rej_sts != 1 and rcpt_dt >= to_date('2021-12-04', 'yyyy-MM-dd') and rcpt_dt < to_date('2021-12-05', 'yyyy-MM-dd')
2021-12-08 01:00:00.280 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.d.d.d.DbOperationRepository :] : run insert into PCK.ARCH_PCK_PRSN(id, id_typ, id_cd, id_nm, shb_id, prsn_typ, tx_id, rcpt_dt) SELECT t1.id, t1.id_typ, t1.id_cd, t1.id_nm, t1.shb_id, t1.prsn_typ, t1.tx_id, t1.rcpt_dt FROM FRD_DAILY.TEMP_PCK_PRSN t1 join FRD_DAILY.TEMP_PCK t0 on t1.tx_id=t0.tx_id where t0.rej_sts != 1 and t0.rcpt_dt >= to_date('2021-12-04', 'yyyy-MM-dd') and t0.rcpt_dt < to_date('2021-12-05', 'yyyy-MM-dd')
2021-12-08 01:00:00.327 ERROR --- [TaskScheduler-1] [c.i.f.g.c.c.e.InternalExceptionHandler :] : خطای سیستمی
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:261) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:503) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) ~[common-1.4.3-RELEASE.jar:?]
at com.isc.fmg.gs.core.schedule.SchedulerLogger.registerUserActivity(SchedulerLogger.java:101) ~[classes/:?]
at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[common-1.4.3-RELEASE.jar:?]
at com.isc.fmg.gs.core.schedule.Scheduler$$EnhancerBySpringCGLIB$$90e7e3b3.endOfDay(<generated>) ~[classes/:?]
at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191]
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) ~[common-1.4.3-RELEASE.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_191]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_191]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_191]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_191]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_191]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:194) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:405) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:61) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.runNativeUpdate(DbOperationRepository.java:195) ~[classes/:?]
at java.util.ArrayList.forEach(ArrayList.java:1257) ~[?:1.8.0_191]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.archiveData(DbOperationRepository.java:110) ~[classes/:?]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository$$FastClassBySpringCGLIB$$873cbd0c.invoke(<generated>) ~[classes/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.3.13.RELEASE.jar:4.3.13.RELEASE]
... 54 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "RCPT_DT": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) ~[jdbc-8.jar:12.2.0.1.0]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.23.jar:?]
at com.sun.proxy.$Proxy187.executeUpdate(Unknown Source) ~[?:?]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:194) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:405) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:61) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.runNativeUpdate(DbOperationRepository.java:195) ~[classes/:?]
at java.util.ArrayList.forEach(ArrayList.java:1257) ~[?:1.8.0_191]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.archiveData(DbOperationRepository.java:110) ~[classes/:?]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository$$FastClassBySpringCGLIB$$873cbd0c.invoke(<generated>) ~[classes/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.3.13.RELEASE.jar:4.3.13.RELEASE]
... 54 more
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "RCPT_DT": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) ~[jdbc-8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061) ~[jdbc-8.jar:12.2.0.1.0]
at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_191]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_191]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.23.jar:?]
at com.sun.proxy.$Proxy187.executeUpdate(Unknown Source) ~[?:?]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:194) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:373) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:405) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:61) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.runNativeUpdate(DbOperationRepository.java:195) ~[classes/:?]
at java.util.ArrayList.forEach(ArrayList.java:1257) ~[?:1.8.0_191]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository.archiveData(DbOperationRepository.java:110) ~[classes/:?]
at com.isc.fmg.gs.core.domain.dao.db.DbOperationRepository$$FastClassBySpringCGLIB$$873cbd0c.invoke(<generated>) ~[classes/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[common-1.4.3-RELEASE.jar:?]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.3.13.RELEASE.jar:4.3.13.RELEASE]
... 54 more
2021-12-08 01:03:00.001 DEBUG --- [TaskScheduler-2] [c.i.f.g.c.s.SchedulerLogger :] : begin scheduler logger: 1638912780001
2021-12-08 01:03:00.011 DEBUG --- [TaskScheduler-2] [c.i.f.g.c.c.c.CacheManager :] : Loading current date ...
2021-12-08 01:03:00.068 INFO --- [TaskScheduler-2] [c.i.f.g.c.c.c.CacheManager :] : Current date is loaded. Sun Dec 05 00:00:00 IRST 2021
2021-12-08 01:03:00.080 DEBUG --- [TaskScheduler-2] [c.i.f.g.c.s.SchedulerLogger :] : end scheduler logger: 1638912780080
2021-12-08 01:03:00.080 DEBUG --- [TaskScheduler-2] [c.i.f.g.c.s.SchedulerLogger :] : begin scheduler logger: 1638912780080
2021-12-08 01:25:00.001 DEBUG --- [TaskScheduler-5] [c.i.f.g.c.s.SchedulerLogger :] : begin scheduler logger: 1638914100001
2021-12-08 01:25:00.011 DEBUG --- [TaskScheduler-5] [c.i.f.g.c.s.l.LearningService :] : loadTempBehaviors ...
2021-12-08 01:25:00.012 INFO --- [TaskScheduler-5] [c.i.f.g.c.s.l.LearningService :] : behaviors temps are loaded.1
2021-12-08 01:25:00.017 DEBUG --- [TaskScheduler-5] [c.i.f.g.c.s.SchedulerLogger :] : end scheduler logger: 1638914100017
2021-12-08 22:00:00.001 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.s.SchedulerLogger :] : begin scheduler logger: 1638988200001
2021-12-08 22:00:00.059 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.s.ScheduleFacade :] : start sync data ...
2021-12-08 22:00:00.059 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.a.m.PckAdaptor :] : getSyncDataModel...
2021-12-08 22:00:00.084 DEBUG --- [TaskScheduler-1] [c.i.f.g.c.s.SchedulerLogger :] : end scheduler logger: 1638988200084