帮忙分析报错原因:PROD Synchronization Error!
IP: 10.199.57.249
Exception information: PROD Synchronization Products Table Error
Caught an ClientException, which means the client encountered
a serious internal problem while trying to communicate with Synchronization,
such as not being able to access the network
Error Message: StatementCallback; SQL [select tt.co, tt.plancode, tt.planname, s.SalesChannels, tt.EffectiveDate, tt.ExpireDate, tt.status, tt.flag from ( select t.co, t.plancode, t.planname, t.SalesChannels, t.EffectiveDate, t.ExpireDate, t.status, t.flag, (row_number() over(partition by t.co, t.plancode, t.planname order by t.rownum)) as id from ( select * from ( select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, 'All' as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '1' as rownum from nbrplan nco inner join NBRCURCODE c on nco.orgid = c.orgid and nco.curcode = c.curcode left join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid <> 'AAAAAA' union select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, 'All' as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '2' as rownum from nbrplan nco inner join NBRCURCODE c on nco.curcode = c.curcode left join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid = 'AAAAAA' ) order by plancode, co, rownum ) t ) tt left join (select 'Agency' as SalesChannels from sysibm.sysdummy1 union select 'Bank' as SalesChannels from sysibm.sysdummy1 union select 'All' as SalesChannels from sysibm.sysdummy1) s on 1=1 where tt.id = 1 and not exists ( select 1 from ( select co, plancode, planname, SalesChannels, EffectiveDate, ExpireDate, status, flag from ( select t.co, t.plancode, t.planname, t.SalesChannels, t.EffectiveDate, t.ExpireDate, t.status, t.flag, (row_number() over(partition by t.co, t.plancode, t.planname, t.SalesChannels order by t.rownum)) as id from ( select * from ( select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, case when ltrim(rtrim(s.agttype)) = 'A' then 'Agency' when ltrim(rtrim(s.agttype)) in ('B','P','X') then 'Bank' when ltrim(rtrim(s.agttype)) = 'E' then 'E-Biz' when ltrim(rtrim(s.agttype)) = 'I' then 'StaffAgent' when ltrim(rtrim(s.agttype)) = 'K' then 'Broker' when ltrim(rtrim(s.agttype)) = 'W' then 'HNW' when ltrim(rtrim(s.agttype)) = 'S' then 'DM' else s.agttype end as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '1' as rownum from nbrplanexp nco inner join NBRCURCODE c on nco.orgid = c.orgid and nco.curcode = c.curcode inner join NBRSALCHNL s on s.orgid = 'AAAAAA' and (nco.chanlcode = s.chanlcode) and s.agttype in ('A','B','P','X') inner join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid <> 'AAAAAA' union select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, case when s.agttype = 'A' then 'Agency' when s.agttype in ('B','P','X') then 'Bank' when s.agttype = 'E' then 'E-Biz' when s.agttype = 'I' then 'StaffAgent' when s.agttype = 'K' then 'Broker' when s.agttype = 'W' then 'HNW' when s.agttype = 'S' then 'DM' else s.agttype end as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '2' as rownum from nbrplanexp nco inner join NBRCURCODE c on nco.curcode = c.curcode inner join NBRSALCHNL s on (nco.chanlcode = s.chanlcode) and s.agttype in ('A','B','P','X') inner join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid = 'AAAAAA' ) order by plancode, co, rownum ) t ) where id = 1 ) ttt where tt.co = ttt.co and tt.plancode = ttt.plancode and s.SalesChannels = ttt.SalesChannels)]; The connection does not exist.; nested exception is java.sql.SQLException: The connection does not exist.
The Exception information of the program has been sent as follows, please deal with it in time.
Exception generation time: 2025-08-04 06:00:00
org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [select tt.co, tt.plancode, tt.planname, s.SalesChannels, tt.EffectiveDate, tt.ExpireDate, tt.status, tt.flag from ( select t.co, t.plancode, t.planname, t.SalesChannels, t.EffectiveDate, t.ExpireDate, t.status, t.flag, (row_number() over(partition by t.co, t.plancode, t.planname order by t.rownum)) as id from ( select * from ( select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, 'All' as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '1' as rownum from nbrplan nco inner join NBRCURCODE c on nco.orgid = c.orgid and nco.curcode = c.curcode left join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid <> 'AAAAAA' union select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, 'All' as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '2' as rownum from nbrplan nco inner join NBRCURCODE c on nco.curcode = c.curcode left join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid = 'AAAAAA' ) order by plancode, co, rownum ) t ) tt left join (select 'Agency' as SalesChannels from sysibm.sysdummy1 union select 'Bank' as SalesChannels from sysibm.sysdummy1 union select 'All' as SalesChannels from sysibm.sysdummy1) s on 1=1 where tt.id = 1 and not exists ( select 1 from ( select co, plancode, planname, SalesChannels, EffectiveDate, ExpireDate, status, flag from ( select t.co, t.plancode, t.planname, t.SalesChannels, t.EffectiveDate, t.ExpireDate, t.status, t.flag, (row_number() over(partition by t.co, t.plancode, t.planname, t.SalesChannels order by t.rownum)) as id from ( select * from ( select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, case when ltrim(rtrim(s.agttype)) = 'A' then 'Agency' when ltrim(rtrim(s.agttype)) in ('B','P','X') then 'Bank' when ltrim(rtrim(s.agttype)) = 'E' then 'E-Biz' when ltrim(rtrim(s.agttype)) = 'I' then 'StaffAgent' when ltrim(rtrim(s.agttype)) = 'K' then 'Broker' when ltrim(rtrim(s.agttype)) = 'W' then 'HNW' when ltrim(rtrim(s.agttype)) = 'S' then 'DM' else s.agttype end as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '1' as rownum from nbrplanexp nco inner join NBRCURCODE c on nco.orgid = c.orgid and nco.curcode = c.curcode inner join NBRSALCHNL s on s.orgid = 'AAAAAA' and (nco.chanlcode = s.chanlcode) and s.agttype in ('A','B','P','X') inner join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid <> 'AAAAAA' union select distinct c.co, ltrim(rtrim(nco.plancode)) as plancode, ltrim(rtrim(pa.planname)) as planname, case when s.agttype = 'A' then 'Agency' when s.agttype in ('B','P','X') then 'Bank' when s.agttype = 'E' then 'E-Biz' when s.agttype = 'I' then 'StaffAgent' when s.agttype = 'K' then 'Broker' when s.agttype = 'W' then 'HNW' when s.agttype = 'S' then 'DM' else s.agttype end as SalesChannels, nco.effdate as EffectiveDate, nco.expdate as ExpireDate, nco.status, '暂停销售' as flag, '2' as rownum from nbrplanexp nco inner join NBRCURCODE c on nco.curcode = c.curcode inner join NBRSALCHNL s on (nco.chanlcode = s.chanlcode) and s.agttype in ('A','B','P','X') inner join nladpa pa on (pa.planco = c.co or pa.planco = '0086') and ltrim(rtrim(nco.plancode)) = ltrim(rtrim(pa.plancode)) where 1=1 and nco.orgid = 'AAAAAA' ) order by plancode, co, rownum ) t ) where id = 1 ) ttt where tt.co = ttt.co and tt.plancode = ttt.plancode and s.SalesChannels = ttt.SalesChannels)]; The connection does not exist.; nested exception is java.sql.SQLException: The connection does not exist. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:506) at com.eastrobot.robotdev.service.ProductSyncService.searchPauseProduct1(ProductSyncService.java:273) at com.eastrobot.robotdev.service.ProductSyncService.sync(ProductSyncService.java:55) at com.eastrobot.robotdev.job.ProductSyncTask.sync(ProductSyncTask.java:71) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.sql.SQLException: The connection does not exist. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415) at com.ibm.as400.access.AS400JDBCConnection.checkOpen(AS400JDBCConnection.java:459) at com.ibm.as400.access.AS400JDBCConnection.createStatement(AS400JDBCConnection.java:762) at com.ibm.as400.access.AS400JDBCConnection.createStatement(AS400JDBCConnection.java:680) at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:70) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) at com.sun.proxy.$Proxy109.createStatement(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:398) ... 20 more