API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2019
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.83 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ____ ____ ____ __ __ _
  3. / ___| / ___| _ \ \ \ / /__ _ __| | _____ _ __
  4. \___ \| | _| |_) | _____ \ \ /\ / / _ \| '__| |/ / _ \ '__|
  5. ___) | |_| | _ < |_____| \ V V / (_) | | | < __/ |
  6. |____/ \____|_| \_\ \_/\_/ \___/|_| |_|\_\___|_|
  7.  
  8. by Tribo Inovação
  9.  
  10. 2019-01-23 15:15:58.352 INFO 16404 --- [ main] br.com.conductor.sgr.Worker : Starting Worker v4.7.0 on NJP004388 with PID 16404 (C:\Users\diomar.neto\.m2\repository\br\com\conductor\sgr-core\4.7.0\sgr-core-4.7.0.jar started by diomar.neto in C:\Ambiente\workspace-sgr\sgr-plugin-pagseguro-securitizacao)
  11. 2019-01-23 15:15:58.360 INFO 16404 --- [ main] br.com.conductor.sgr.Worker : The following profiles are active: worker,sgr-core
  12. 2019-01-23 15:16:03.120 INFO 16404 --- [ main] ro.fortsoft.pf4j.DefaultPluginManager : PF4J version 1.1.0 in 'deployment' mode
  13. 2019-01-23 15:16:03.147 INFO 16404 --- [ main] r.f.pf4j.DefaultPluginStatusProvider : Enabled plugins: []
  14. 2019-01-23 15:16:03.149 INFO 16404 --- [ main] r.f.pf4j.DefaultPluginStatusProvider : Disabled plugins: []
  15. 2019-01-23 15:16:21.311 WARN 16404 --- [ main] com.zaxxer.hikari.HikariConfig : idleTimeout is less than 10000ms, setting to default 600000ms.
  16. 2019-01-23 15:16:21.317 INFO 16404 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-0 - is starting.
  17. 2019-01-23 15:16:21.942 INFO 16404 --- [ main] b.c.c.sgr.config.ds.DataSourceSGRConfig : Releasing Liquibase Locks
  18. 2019-01-23 15:16:23.078 INFO 16404 --- [ main] b.c.c.sgr.config.ds.DataSourceSGRConfig : Clear Liquibase ChecksSums
  19. 2019-01-23 15:16:23.221 INFO 16404 --- [ main] liquibase : Liquibase did not run because 'shouldRun' property was set to false on liquibase Liquibase Spring bean.
  20. 2019-01-23 15:16:23.403 INFO 16404 --- [ main] com.mchange.v2.log.MLog : MLog clients using log4j logging.
  21. 2019-01-23 15:16:23.916 INFO 16404 --- [ main] com.mchange.v2.c3p0.C3P0Registry : Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10]
  22. 2019-01-23 15:16:23.966 INFO 16404 --- [ main] org.quartz.impl.StdSchedulerFactory : Using default implementation for ThreadExecutor
  23. 2019-01-23 15:16:24.049 INFO 16404 --- [ main] org.quartz.core.SchedulerSignalerImpl : Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  24. 2019-01-23 15:16:24.052 INFO 16404 --- [ main] org.quartz.core.QuartzScheduler : Quartz Scheduler v.2.2.1 created.
  25. 2019-01-23 15:16:24.090 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Using thread monitor-based data access locking (synchronization).
  26. 2019-01-23 15:16:24.096 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : JobStoreTX initialized.
  27. 2019-01-23 15:16:24.103 INFO 16404 --- [ main] org.quartz.core.QuartzScheduler : Scheduler meta-data: Quartz Scheduler (v2.2.1) 'schedulerFactoryBean' with instanceId 'NJP004388'
  28. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  29. NOT STARTED.
  30. Currently in standby mode.
  31. Number of jobs executed: 0
  32. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 25 threads.
  33. Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is not clustered.
  34.  
  35. 2019-01-23 15:16:24.103 INFO 16404 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance.
  36. 2019-01-23 15:16:24.104 INFO 16404 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler version: 2.2.1
  37. 2019-01-23 15:16:24.106 INFO 16404 --- [ main] org.quartz.core.QuartzScheduler : JobFactory set to: br.com.conductor.sgr.quartz.QuartzJobFactory@3ddc5a75
  38. 2019-01-23 15:16:29.100 INFO 16404 --- [ main] c.m.v.c.i.AbstractPoolBackedDataSource : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 2rwcn5a0ydvjpn712cd3|6c9e7af2, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2rwcn5a0ydvjpn712cd3|6c9e7af2, idleConnectionTestPeriod -> 50, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://10.19.20.21:1433;databaseName=SGR_CORE_DEV;appName=SGR_CORE_QUARTZ, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 120, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT 1, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
  39. 2019-01-23 15:16:30.181 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Freed 0 triggers from 'acquired' / 'blocked' state.
  40. 2019-01-23 15:16:30.432 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Recovering 0 jobs that were in-progress at the time of the last shut-down.
  41. 2019-01-23 15:16:30.432 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Recovery complete.
  42. 2019-01-23 15:16:30.556 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Removed 0 'complete' triggers.
  43. 2019-01-23 15:16:30.685 INFO 16404 --- [ main] org.quartz.impl.jdbcjobstore.JobStoreTX : Removed 0 stale fired job entries.
  44. 2019-01-23 15:16:30.812 INFO 16404 --- [ main] org.quartz.core.QuartzScheduler : Scheduler schedulerFactoryBean_$_NJP004388 started.
  45. 2019-01-23 15:16:31.178 INFO 16404 --- [ main] br.com.conductor.sgr.Worker : Started Worker in 35.398 seconds (JVM running for 36.84)
  46. 2019-01-23 15:16:31.185 INFO 16404 --- [ main] b.c.c.sgr.config.plugin.PluginService : Carregando todos os plugins
  47. 2019-01-23 15:16:31.190 INFO 16404 --- [ main] ro.fortsoft.pf4j.DefaultPluginManager : No plugins
  48. 2019-01-23 15:16:31.609 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  49.  
  50. ____ ____ ____ __ __ _
  51. / ___| / ___|| _ \ \ \ / / ___ _ __ | | __ ___ _ __
  52. \___ \ | | _ | |_) | _____ \ \ /\ / / / _ \ | '__|| |/ / / _ \| '__|
  53. ___) || |_| || _ < |_____| \ V V / | (_) || | | < | __/| |
  54. |____/ \____||_| \_\ \_/\_/ \___/ |_| |_|\_\ \___||_|
  55.  
  56.  
  57. 2019-01-23 15:16:31.630 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  58. +-------------------------------------------------+------------------------------------------------------+
  59. | JOBS | FILAS |
  60. +-------------------------------------------------+------------------------------------------------------+
  61. | JobImportacaoArquivoPontosDigital | QUEUE_PROCESSAR_PROTOCOLO_RETORNO_PAGAMENTO_BRADESCO |
  62. | JobProcessamentoPontosDigital | QUEUE_FATURAS_V6 |
  63. | JobImportacaoArquivoCnab | QUEUE_FATURAS_EMAIL_V6 |
  64. | JobProtocoloRetornoPagamento | QUEUE_PONTOS_DIGITAL |
  65. | JobProcessamentoFaturaSabeV6 | QUEUE_IMPORTACAO_ARQUIVO_CNAB |
  66. | JobProcessamentoFaturaSabeEmailV6 | QUEUE_IMPORTACAO_ARQUIVO_PONTOS |
  67. | JobProcessamentoEspelhoFaturaSabeV6 | QUEUE_ESPELHO_FATURAS_V6 |
  68. | JobProcessamentoCadastroFull | QUEUE_CADASTRO_FULL |
  69. | JobProcedureExecution | QUEUE_PROCEDURE_PONTOS_DIGITAL |
  70. | JobProcessamentoFullAutorizacoes | QUEUE_FULL_AUTORIZACOES |
  71. | JobProcessamentoParcelamentoFatura | QUEUE_PARCELAMENTO_FATURA |
  72. | JobProcessamentoAnaliticoFraude | QUEUE_ANALITICO_FRAUDE |
  73. | JobProcessamentoArquivoRemessaBancaria | QUEUE_ARQUIVO_REMESSA_BANCARIA |
  74. | JobExecutando | QUEUE_IMPORTACAO_ARQUIVO_HRC |
  75. | JobArquivoHabilitacaoRedecompras | QUEUE_ARQUIVO_CREDENCIAMENTO_REDECOMPRAS |
  76. | JobImportacaoArquivoRetHabilitacaoRC | QUEUE_ARQUIVO_CONCILIACAO |
  77. | JobImportacaoArquivoConciliacao | QUEUE_ARQUIVO_EO2 |
  78. | JobProcessamentoLancamentosContabeis | QUEUE_LANCAMENTOS_CONTABEIS |
  79. | JobProcessamentoRazaoDiarioAuxiliar | QUEUE_RAZAO_DIARIO_AUXILIAR |
  80. | JobProcessamentoInterfaceContabil | QUEUE_INTERFACE_CONTABIL |
  81. | JobProcessamentoRazaoDiarioAuxiliarCBSS | QUEUE_RAZAO_DIARIO_AUXILIAR_CBSS |
  82. | JobImportacaoPANVAS | QUEUE_IMPORTACAO_PANVAS |
  83. | JobExportacaoPANVAS | QUEUE_EXPORTACAO_PANVAS |
  84. | JobArquivoBacenDoc3040 | QUEUE_CARGA_ARQUIVO_CADOC3040 |
  85. | JobImportacaoCaixa | QUEUE_GERA_ARQUIVO_XML_CADOC3040 |
  86. | JobExportArquivoResc | QUEUE_IMPORTACAO_CAIXA |
  87. | JobExportacaoArquivo5816 | QUEUE_EXPORT_RESC |
  88. | JobProcessamentoFaturaSabeV3 | QUEUE_EXPORTACAO_ARQUIVO_5816 |
  89. | JobGenerico | QUEUE_FATURAS_V3 |
  90. | JobExemplo | QUEUE_ARQUIVO_GENERICO |
  91. | JobGeraXmlCadastroPositivo | QUEUE_ARQUIVO_EXEMPLO |
  92. | JobImportacaoCorrespondenciasDevolvidas | QUEUE_CADASTRO_POSITIVO |
  93. | JobProcedureExecutionCorrespondenciasDevolvidas | QUEUE_IMPORTACAO_CORRESPONDENCIAS_DEVOLVIDAS |
  94. | JobParaRodarScript | QUEUE_PROCEDURE_CORRESPONDENCIAS_DEVOLVIDAS |
  95. | BuilderSecuritizacao | QUEUE_RODAR_SCRIPT |
  96. | JobSecuritizacao | QUEUE_BUILDER_SECURITIZACAO |
  97. | BuilderSecuritizacao | QUEUE_PROCESSAMENTO_SECURITIZACAO |
  98. | JobSecuritizacao | QUEUE_BUILDER_SECURITIZACAO |
  99. | | QUEUE_PROCESSAMENTO_SECURITIZACAO |
  100. +-------------------------------------------------+------------------------------------------------------+
  101.  
  102. 2019-01-23 15:16:31.631 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  103. Esperando Job...
  104. 2019-01-23 15:19:01.589 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.sgr.config.ds.CarregarDataSource : Carregando do Data Source Pagseguro Securitizacao
  105. 2019-01-23 15:19:01.736 WARN 16404 --- [-2.0.2: RUNNING] com.zaxxer.hikari.HikariConfig : idleTimeout is less than 10000ms, setting to default 600000ms.
  106. 2019-01-23 15:19:01.737 INFO 16404 --- [-2.0.2: RUNNING] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - is starting.
  107. 2019-01-23 15:19:03.105 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.sgr.config.ds.CarregarDataSource : Data Source 'Pagseguro Securitizacao' carregado. (DataSource [id=20081, nome=Pagseguro Securitizacao, host=10.70.33.30, domain=null, databaseName=P180357, usuario=UserPier, chave=null, socketTimeout=900000, loginTimeout=900000, aplicacaoId=14, active=true, failedAttempts=0])
  108. 2019-01-23 15:19:05.291 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.s.p.ps.jobs.BuilderSecuritizacao : Enfileirando 1 job(s)
  109. 2019-01-23 15:19:06.230 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  110.  
  111. ____ ____ ____ __ __ _
  112. / ___| / ___|| _ \ \ \ / / ___ _ __ | | __ ___ _ __
  113. \___ \ | | _ | |_) | _____ \ \ /\ / / / _ \ | '__|| |/ / / _ \| '__|
  114. ___) || |_| || _ < |_____| \ V V / | (_) || | | < | __/| |
  115. |____/ \____||_| \_\ \_/\_/ \___/ |_| |_|\_\ \___||_|
  116.  
  117.  
  118. 2019-01-23 15:19:06.237 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  119. +-------------------------------------------------+------------------------------------------------------+
  120. | JOBS | FILAS |
  121. +-------------------------------------------------+------------------------------------------------------+
  122. | JobImportacaoArquivoPontosDigital | QUEUE_PROCESSAMENTO_SECURITIZACAO |
  123. | JobProcessamentoPontosDigital | QUEUE_BUILDER_SECURITIZACAO |
  124. | JobImportacaoArquivoCnab | QUEUE_PROCESSAMENTO_SECURITIZACAO |
  125. | JobProtocoloRetornoPagamento | QUEUE_PROCESSAR_PROTOCOLO_RETORNO_PAGAMENTO_BRADESCO |
  126. | JobProcessamentoFaturaSabeV6 | QUEUE_FATURAS_V6 |
  127. | JobProcessamentoFaturaSabeEmailV6 | QUEUE_FATURAS_EMAIL_V6 |
  128. | JobProcessamentoEspelhoFaturaSabeV6 | QUEUE_PONTOS_DIGITAL |
  129. | JobProcessamentoCadastroFull | QUEUE_IMPORTACAO_ARQUIVO_CNAB |
  130. | JobProcedureExecution | QUEUE_IMPORTACAO_ARQUIVO_PONTOS |
  131. | JobProcessamentoFullAutorizacoes | QUEUE_ESPELHO_FATURAS_V6 |
  132. | JobProcessamentoParcelamentoFatura | QUEUE_CADASTRO_FULL |
  133. | JobProcessamentoAnaliticoFraude | QUEUE_PROCEDURE_PONTOS_DIGITAL |
  134. | JobProcessamentoArquivoRemessaBancaria | QUEUE_FULL_AUTORIZACOES |
  135. | JobExecutando | QUEUE_PARCELAMENTO_FATURA |
  136. | JobArquivoHabilitacaoRedecompras | QUEUE_ANALITICO_FRAUDE |
  137. | JobImportacaoArquivoRetHabilitacaoRC | QUEUE_ARQUIVO_REMESSA_BANCARIA |
  138. | JobImportacaoArquivoConciliacao | QUEUE_IMPORTACAO_ARQUIVO_HRC |
  139. | JobProcessamentoLancamentosContabeis | QUEUE_ARQUIVO_CREDENCIAMENTO_REDECOMPRAS |
  140. | JobProcessamentoRazaoDiarioAuxiliar | QUEUE_ARQUIVO_CONCILIACAO |
  141. | JobProcessamentoInterfaceContabil | QUEUE_ARQUIVO_EO2 |
  142. | JobProcessamentoRazaoDiarioAuxiliarCBSS | QUEUE_LANCAMENTOS_CONTABEIS |
  143. | JobImportacaoPANVAS | QUEUE_RAZAO_DIARIO_AUXILIAR |
  144. | JobExportacaoPANVAS | QUEUE_INTERFACE_CONTABIL |
  145. | JobArquivoBacenDoc3040 | QUEUE_RAZAO_DIARIO_AUXILIAR_CBSS |
  146. | JobImportacaoCaixa | QUEUE_IMPORTACAO_PANVAS |
  147. | JobExportArquivoResc | QUEUE_EXPORTACAO_PANVAS |
  148. | JobExportacaoArquivo5816 | QUEUE_CARGA_ARQUIVO_CADOC3040 |
  149. | JobProcessamentoFaturaSabeV3 | QUEUE_GERA_ARQUIVO_XML_CADOC3040 |
  150. | JobGenerico | QUEUE_IMPORTACAO_CAIXA |
  151. | JobExemplo | QUEUE_EXPORT_RESC |
  152. | JobGeraXmlCadastroPositivo | QUEUE_EXPORTACAO_ARQUIVO_5816 |
  153. | JobImportacaoCorrespondenciasDevolvidas | QUEUE_FATURAS_V3 |
  154. | JobProcedureExecutionCorrespondenciasDevolvidas | QUEUE_ARQUIVO_GENERICO |
  155. | JobParaRodarScript | QUEUE_ARQUIVO_EXEMPLO |
  156. | BuilderSecuritizacao | QUEUE_CADASTRO_POSITIVO |
  157. | JobSecuritizacao | QUEUE_IMPORTACAO_CORRESPONDENCIAS_DEVOLVIDAS |
  158. | BuilderSecuritizacao | QUEUE_PROCEDURE_CORRESPONDENCIAS_DEVOLVIDAS |
  159. | JobSecuritizacao | QUEUE_RODAR_SCRIPT |
  160. | | QUEUE_BUILDER_SECURITIZACAO |
  161. +-------------------------------------------------+------------------------------------------------------+
  162.  
  163. 2019-01-23 15:19:06.238 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  164. Esperando Job...
  165. 2019-01-23 15:19:24.586 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.s.plugin.ps.jobs.JobSecuritizacao : Buscando pagamentos para 1 contas
  166. 2019-01-23 15:20:34.338 INFO 16404 --- [-2.0.2: RUNNING] b.c.c.s.plugin.ps.jobs.JobSecuritizacao : Buscando parcelamentos para 1 pagamentos
  167. 2019-01-23 15:20:50.872 ERROR 16404 --- [-2.0.2: RUNNING] jdbc.audit : 15. PreparedStatement.executeQuery() SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento;
  168.  
  169. java.sql.SQLException: The executeQuery method must return a result set.
  170. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:516) ~[jtds-1.3.1.jar:1.3.1]
  171. at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) ~[jtds-1.3.1.jar:1.3.1]
  172. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.4.3.jar:na]
  173. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.3.jar:na]
  174. at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735) ~[log4jdbc-remix-0.2.7.jar:na]
  175. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  176. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  177. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  178. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  179. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  180. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  181. at br.com.conductor.processador.utils.repositorios.JdbcRepository.query(JdbcRepository.java:575) [sgr-core-4.7.0.jar:4.7.0]
  182. at br.com.conductor.sgr.plugin.ps.repositorios.RepositorioParcelamentoImpl.findParcelamentos(RepositorioParcelamentoImpl.java:35) [classes/:na]
  183. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
  184. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  185. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  186. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_201]
  187. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  188. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  189. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  190. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  191. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  192. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  193. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  194. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  195. at com.sun.proxy.$Proxy93.findParcelamentos(Unknown Source) [na:na]
  196. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.lambda$run$0(JobSecuritizacao.java:80) [classes/:na]
  197. at java.util.ArrayList.forEach(Unknown Source) ~[na:1.8.0_201]
  198. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:79) [classes/:na]
  199. at br.com.conductor.processador.workers.utils.WorkerImplCustom.execute(WorkerImplCustom.java:81) ~[sgr-core-4.7.0.jar:4.7.0]
  200. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:562) ~[jesque-2.0.2.jar:na]
  201. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428) ~[jesque-2.0.2.jar:na]
  202. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212) ~[jesque-2.0.2.jar:na]
  203. at java.lang.Thread.run(Unknown Source) ~[na:1.8.0_201]
  204.  
  205. 2019-01-23 15:20:53.972 ERROR 16404 --- [-2.0.2: RUNNING] jdbc.sqlonly : 15. PreparedStatement.executeQuery() SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento;
  206.  
  207. java.sql.SQLException: The executeQuery method must return a result set.
  208. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:516) ~[jtds-1.3.1.jar:1.3.1]
  209. at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) ~[jtds-1.3.1.jar:1.3.1]
  210. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.4.3.jar:na]
  211. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.3.jar:na]
  212. at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735) ~[log4jdbc-remix-0.2.7.jar:na]
  213. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  214. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  215. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  216. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  217. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  218. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  219. at br.com.conductor.processador.utils.repositorios.JdbcRepository.query(JdbcRepository.java:575) [sgr-core-4.7.0.jar:4.7.0]
  220. at br.com.conductor.sgr.plugin.ps.repositorios.RepositorioParcelamentoImpl.findParcelamentos(RepositorioParcelamentoImpl.java:35) [classes/:na]
  221. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
  222. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  223. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  224. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_201]
  225. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  226. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  227. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  228. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  229. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  230. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  231. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  232. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  233. at com.sun.proxy.$Proxy93.findParcelamentos(Unknown Source) [na:na]
  234. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.lambda$run$0(JobSecuritizacao.java:80) [classes/:na]
  235. at java.util.ArrayList.forEach(Unknown Source) ~[na:1.8.0_201]
  236. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:79) [classes/:na]
  237. at br.com.conductor.processador.workers.utils.WorkerImplCustom.execute(WorkerImplCustom.java:81) ~[sgr-core-4.7.0.jar:4.7.0]
  238. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:562) ~[jesque-2.0.2.jar:na]
  239. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428) ~[jesque-2.0.2.jar:na]
  240. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212) ~[jesque-2.0.2.jar:na]
  241. at java.lang.Thread.run(Unknown Source) ~[na:1.8.0_201]
  242.  
  243. 2019-01-23 15:20:54.021 ERROR 16404 --- [-2.0.2: RUNNING] jdbc.sqltiming : 15. PreparedStatement.executeQuery() FAILED! SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento; {FAILED after 421 msec}
  244.  
  245. java.sql.SQLException: The executeQuery method must return a result set.
  246. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:516) ~[jtds-1.3.1.jar:1.3.1]
  247. at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) ~[jtds-1.3.1.jar:1.3.1]
  248. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.4.3.jar:na]
  249. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.3.jar:na]
  250. at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735) ~[log4jdbc-remix-0.2.7.jar:na]
  251. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  252. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  253. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  254. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  255. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  256. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) [spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  257. at br.com.conductor.processador.utils.repositorios.JdbcRepository.query(JdbcRepository.java:575) [sgr-core-4.7.0.jar:4.7.0]
  258. at br.com.conductor.sgr.plugin.ps.repositorios.RepositorioParcelamentoImpl.findParcelamentos(RepositorioParcelamentoImpl.java:35) [classes/:na]
  259. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
  260. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  261. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  262. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_201]
  263. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  264. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  265. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  266. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  267. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  268. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  269. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  270. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  271. at com.sun.proxy.$Proxy93.findParcelamentos(Unknown Source) [na:na]
  272. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.lambda$run$0(JobSecuritizacao.java:80) [classes/:na]
  273. at java.util.ArrayList.forEach(Unknown Source) ~[na:1.8.0_201]
  274. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:79) [classes/:na]
  275. at br.com.conductor.processador.workers.utils.WorkerImplCustom.execute(WorkerImplCustom.java:81) ~[sgr-core-4.7.0.jar:4.7.0]
  276. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:562) ~[jesque-2.0.2.jar:na]
  277. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428) ~[jesque-2.0.2.jar:na]
  278. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212) ~[jesque-2.0.2.jar:na]
  279. at java.lang.Thread.run(Unknown Source) ~[na:1.8.0_201]
  280.  
  281. 2019-01-23 15:21:20.121 ERROR 16404 --- [-2.0.2: RUNNING] b.c.c.p.workers.utils.WorkerApplication :
  282.  
  283. java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento; ]; SQL state [24000]; error code [0]; The executeQuery method must return a result set.; nested exception is java.sql.SQLException: The executeQuery method must return a result set.
  284. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:109) ~[classes/:na]
  285. at br.com.conductor.processador.workers.utils.WorkerImplCustom.execute(WorkerImplCustom.java:81) ~[sgr-core-4.7.0.jar:4.7.0]
  286. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:562) [jesque-2.0.2.jar:na]
  287. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428) [jesque-2.0.2.jar:na]
  288. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212) [jesque-2.0.2.jar:na]
  289. at java.lang.Thread.run(Unknown Source) [na:1.8.0_201]
  290. Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento; ]; SQL state [24000]; error code [0]; The executeQuery method must return a result set.; nested exception is java.sql.SQLException: The executeQuery method must return a result set.
  291. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  292. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  293. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  294. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  295. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  296. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  297. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  298. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  299. at br.com.conductor.processador.utils.repositorios.JdbcRepository.query(JdbcRepository.java:575) ~[sgr-core-4.7.0.jar:4.7.0]
  300. at br.com.conductor.sgr.plugin.ps.repositorios.RepositorioParcelamentoImpl.findParcelamentos(RepositorioParcelamentoImpl.java:35) ~[classes/:na]
  301. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
  302. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  303. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_201]
  304. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_201]
  305. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  306. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  307. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  308. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  309. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  310. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  311. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  312. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  313. at com.sun.proxy.$Proxy93.findParcelamentos(Unknown Source) ~[na:na]
  314. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.lambda$run$0(JobSecuritizacao.java:80) ~[classes/:na]
  315. at java.util.ArrayList.forEach(Unknown Source) ~[na:1.8.0_201]
  316. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:79) ~[classes/:na]
  317. ... 5 common frames omitted
  318. Caused by: java.sql.SQLException: The executeQuery method must return a result set.
  319. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:516) ~[jtds-1.3.1.jar:1.3.1]
  320. at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) ~[jtds-1.3.1.jar:1.3.1]
  321. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.4.3.jar:na]
  322. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.4.3.jar:na]
  323. at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735) ~[log4jdbc-remix-0.2.7.jar:na]
  324. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  325. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) ~[spring-jdbc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
  326. ... 27 common frames omitted
  327.  
  328. java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento; ]; SQL state [24000]; error code [0]; The executeQuery method must return a result set.; nested exception is java.sql.SQLException: The executeQuery method must return a result set.
  329. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:109)
  330. at br.com.conductor.processador.workers.utils.WorkerImplCustom.execute(WorkerImplCustom.java:81)
  331. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:562)
  332. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428)
  333. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212)
  334. at java.lang.Thread.run(Unknown Source)
  335. Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SET NOCOUNT ON IF Object_id(N'tempdb..#detalhamento_parcelamento') IS NOT NULL BEGIN DROP TABLE #detalhamento_parcelamento END CREATE TABLE #detalhamento_parcelamento ( idcontrato INT ,tipocontrato VARCHAR(255) ,valor MONEY ,valorentrada MONEY ,qtdparcelascontratadas INT ,parcelaatual INT ,valortotalcontrato MONEY ,dataadesao SMALLDATETIME ,id_eventocompra INT ); INSERT INTO #detalhamento_parcelamento SELECT pa.id_parcelamento AS idcontrato ,st.descricao AS tipocontrato ,pa.valorparcela AS valor ,pa.valorentrada AS valorentrada ,pa.quantidadeparcelas AS qtdparcelascontratadas ,0 AS parcelaatual ,pa.valortotalrefinanciamento AS valortotalcontrato ,pa.dataprocessamentoadesao AS dataadesao ,r.id_eventocompra FROM parcelamentos pa WITH (NOLOCK) INNER JOIN servicoselegiveis se WITH (NOLOCK) ON se.id_servicoelegivel = pa.id_servicoelegivel INNER JOIN servicostipos st WITH (NOLOCK) ON st.id_servicotipo = se.id_servicotipo INNER JOIN refinanciamento r WITH (NOLOCK) ON r.id_conta = se.id_conta AND pa.valortotalrefinanciamento = r.totalrefinanciado AND pa.valorparcela = r.valorparcela LEFT JOIN debitosdiversos dd WITH (NOLOCK) ON dd.id_conta = se.id_conta AND dd.id_eventocompra = r.id_eventocompra WHERE pa.statusadesao = 3 --AND dd.parcelapedida <= dd.quantidadeparcelas AND pa.dataprocessamentoadesao IS NOT NULL AND se.dataexecucao IS NOT NULL AND se.id_conta = :idConta AND r.datarefinanciamento <= :dataPagamento AND ( r.STATUS = 0 OR dd.id_operacao IN ( SELECT id_operacao FROM tiposoperacoes tpos WITH (NOLOCK) WHERE tpos.nomeoperacao LIKE '%refinanciamento com juros%' OR tpos.nomeoperacao LIKE '%parcelamento de fatura rotativo%' OR tpos.nomeoperacao LIKE '%financiamento automatico de minimo%' ) ) ORDER BY pa.id_parcelamento DESC UPDATE dp SET dp.parcelaatual = tc.parcela FROM #detalhamento_parcelamento dp INNER JOIN ( SELECT tc.id_eventoexterno ,Max(tc.parcela) AS parcela FROM transacoescorrentes tc WITH (NOLOCK) GROUP BY tc.id_eventoexterno ,tc.id_conta ,tc.datavencimentoreal ,tc.id_tipotransacao HAVING tc.id_conta = :idConta AND tc.id_tipotransacao IN ( SELECT id_tipotransacao FROM tipostransacoes WITH (NOLOCK) WHERE nome LIKE '%parcelarefinanciamentojuros%' OR nome LIKE '%parcela de fatura rotativo%' OR nome LIKE '%parcela de fatura do financiamento do valor minimo%' ) AND tc.datavencimentoreal IN ( SELECT hc.datavencimentoreal FROM historicoscorrentes hc WITH (NOLOCK) INNER JOIN controlevencimentos cv WITH (NOLOCK) ON cv.datavencimento = CONVERT(SMALLDATETIME, hc.datavencimentopadrao, 103) WHERE hc.id_conta = :idConta AND CONVERT(SMALLDATETIME, :dataReferencia, 103) BETWEEN cv.dataprevistafaturamento AND Dateadd(day, - 1, hc.datafechamentoproxfatura) ) ) tc ON dp.id_eventocompra = tc.id_eventoexterno SELECT idcontrato ,tipocontrato ,valor ,valorentrada ,qtdparcelascontratadas ,parcelaatual ,valortotalcontrato ,dataadesao FROM #detalhamento_parcelamento; ]; SQL state [24000]; error code [0]; The executeQuery method must return a result set.; nested exception is java.sql.SQLException: The executeQuery method must return a result set.
  336. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  337. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  338. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  339. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
  340. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
  341. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707)
  342. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)
  343. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
  344. at br.com.conductor.processador.utils.repositorios.JdbcRepository.query(JdbcRepository.java:575)
  345. at br.com.conductor.sgr.plugin.ps.repositorios.RepositorioParcelamentoImpl.findParcelamentos(RepositorioParcelamentoImpl.java:35)
  346. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  347. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  348. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  349. at java.lang.reflect.Method.invoke(Unknown Source)
  350. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
  351. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  352. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  353. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
  354. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  355. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  356. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  357. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
  358. at com.sun.proxy.$Proxy93.findParcelamentos(Unknown Source)
  359. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.lambda$run$0(JobSecuritizacao.java:80)
  360. at java.util.ArrayList.forEach(Unknown Source)
  361. at br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao.run(JobSecuritizacao.java:79)
  362. ... 5 more
  363. Caused by: java.sql.SQLException: The executeQuery method must return a result set.
  364. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:516)
  365. at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
  366. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  367. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  368. at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
  369. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688)
  370. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
  371. ... 27 more
  372. 2019-01-23 15:21:20.136 ERROR 16404 --- [-2.0.2: RUNNING] n.g.j.worker.WorkerListenerDelegate : Failure executing listener br.com.conductor.processador.workers.utils.WorkerListenersFactory$3@6b438782 for event JOB_FAILURE from queue QUEUE_PROCESSAMENTO_SECURITIZACAO on worker diomar.neto:worker:NJP004388:16404-0:WORKER_NORMAL,QUEUE_PROCESSAR_PROTOCOLO_RETORNO_PAGAMENTO_BRADESCO,QUEUE_FATURAS_V6,QUEUE_FATURAS_EMAIL_V6,QUEUE_PONTOS_DIGITAL,QUEUE_IMPORTACAO_ARQUIVO_CNAB,QUEUE_IMPORTACAO_ARQUIVO_PONTOS,QUEUE_ESPELHO_FATURAS_V6,QUEUE_CADASTRO_FULL,QUEUE_PROCEDURE_PONTOS_DIGITAL,QUEUE_FULL_AUTORIZACOES,QUEUE_PARCELAMENTO_FATURA,QUEUE_ANALITICO_FRAUDE,QUEUE_ARQUIVO_REMESSA_BANCARIA,QUEUE_IMPORTACAO_ARQUIVO_HRC,QUEUE_ARQUIVO_CREDENCIAMENTO_REDECOMPRAS,QUEUE_ARQUIVO_CONCILIACAO,QUEUE_ARQUIVO_EO2,QUEUE_LANCAMENTOS_CONTABEIS,QUEUE_RAZAO_DIARIO_AUXILIAR,QUEUE_INTERFACE_CONTABIL,QUEUE_RAZAO_DIARIO_AUXILIAR_CBSS,QUEUE_IMPORTACAO_PANVAS,QUEUE_EXPORTACAO_PANVAS,QUEUE_CARGA_ARQUIVO_CADOC3040,QUEUE_GERA_ARQUIVO_XML_CADOC3040,QUEUE_IMPORTACAO_CAIXA,QUEUE_EXPORT_RESC,QUEUE_EXPORTACAO_ARQUIVO_5816,QUEUE_FATURAS_V3,QUEUE_ARQUIVO_GENERICO,QUEUE_ARQUIVO_EXEMPLO,QUEUE_CADASTRO_POSITIVO,QUEUE_IMPORTACAO_CORRESPONDENCIAS_DEVOLVIDAS,QUEUE_PROCEDURE_CORRESPONDENCIAS_DEVOLVIDAS,QUEUE_RODAR_SCRIPT,QUEUE_BUILDER_SECURITIZACAO,QUEUE_PROCESSAMENTO_SECURITIZACAO,QUEUE_BUILDER_SECURITIZACAO,QUEUE_PROCESSAMENTO_SECURITIZACAO
  373.  
  374. java.lang.RuntimeException: java.lang.ClassCastException: br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao cannot be cast to br.com.conductor.processador.workers.jobs.JobAbstract
  375. at br.com.conductor.processador.workers.utils.WorkerListenersFactory$3.onEvent(WorkerListenersFactory.java:78) ~[sgr-core-4.7.0.jar:4.7.0]
  376. at net.greghaines.jesque.worker.WorkerListenerDelegate.fireEvent(WorkerListenerDelegate.java:150) ~[jesque-2.0.2.jar:na]
  377. at net.greghaines.jesque.worker.WorkerImpl.failure(WorkerImpl.java:661) [jesque-2.0.2.jar:na]
  378. at net.greghaines.jesque.worker.WorkerImpl.process(WorkerImpl.java:565) [jesque-2.0.2.jar:na]
  379. at net.greghaines.jesque.worker.WorkerImpl.poll(WorkerImpl.java:428) [jesque-2.0.2.jar:na]
  380. at net.greghaines.jesque.worker.WorkerImpl.run(WorkerImpl.java:212) [jesque-2.0.2.jar:na]
  381. at java.lang.Thread.run(Unknown Source) [na:1.8.0_201]
  382. Caused by: java.lang.ClassCastException: br.com.conductor.sgr.plugin.ps.jobs.JobSecuritizacao cannot be cast to br.com.conductor.processador.workers.jobs.JobAbstract
  383. at br.com.conductor.processador.workers.utils.WorkerListenersFactory$3.onEvent(WorkerListenersFactory.java:75) ~[sgr-core-4.7.0.jar:4.7.0]
  384. ... 6 common frames omitted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!