Error code: -4220 db2

1 resposta
edsilvasp

Bom dia

Procurei em vários lugares a solução para este problema porém não encontrei.
Estou usando o TopLink da IBM e o DB2 como banco .

Segue abaixo o log

14:00:08,030  INFO LazBuilderReportAuto:160 - 22170 - 63088

14:00:08,146 ERROR JobInterceptor:119 - ERRO: LOCAL EXCEPTION STACK:

EXCEPTION [TOPLINK-4002] (TopLink - 9.0.3 (Build 423)): oracle.toplink.exceptions.DatabaseException

EXCEPTION DESCRIPTION: com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob.  Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null

INTERNAL EXCEPTION: com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob.  Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null

ERROR CODE: -4220

at oracle.toplink.exceptions.DatabaseException.sqlException(Unknown Source)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(Unknown Source)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(Unknown Source)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown Source)

at oracle.toplink.publicinterface.Session.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(Unknown Source)

at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(Unknown Source)

at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(Unknown Source)

at oracle.toplink.queryframework.ReadAllQuery.execute(Unknown Source)

at oracle.toplink.queryframework.DatabaseQuery.execute(Unknown Source)

at oracle.toplink.queryframework.ReadQuery.execute(Unknown Source)

at oracle.toplink.publicinterface.Session.internalExecuteQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.readAllObjects(Unknown Source)

at chubb.lazuw.dao.clientworkfolder.proposal.LazInsurableCoverageDao.getInsurableCoverageByCoverageId(LazInsurableCoverageDao.java:21)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.populateBasicInformation(LazBuilderReportAuto.java:191)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.generateRecordPolicy(LazBuilderReportAuto.java:163)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.execute(LazBuilderReportAuto.java:60)

at com.chubb.job.lazuw.TempoAssistJob.execute(TempoAssistJob.java:49)

at com.chubb.job.lazuw.TempoAssistJob$$FastClassByCGLIB$$4597e47c.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)

at com.chubb.job.lazuw.TempoAssistJob$$EnhancerByCGLIB$$3cf598ec.execute()

at com.chubb.job.quartz.job.impl.JobInterceptor.executeInternal(JobInterceptor.java:110)

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)

at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

INTERNAL EXCEPTION STACK:

com.ibm.db2.jcc.am.SqlException: [jcc][1037][12546][3.64.106] Ocorreu uma exceção durante a conversão de clob.  Consulte o Throwable anexado para obter detalhes. ERRORCODE=-4220, SQLSTATE=null

at com.ibm.db2.jcc.am.bd.a(bd.java:663)

at com.ibm.db2.jcc.am.bd.a(bd.java:60)

at com.ibm.db2.jcc.am.bd.a(bd.java:85)

at <a href="http://com.ibm.db2.jcc.am.je">com.ibm.db2.jcc.am.je</a>.(je.java:112)

at com.ibm.db2.jcc.t4.c.b(c.java:1728)

at com.ibm.db2.jcc.am.fc.a(fc.java:994)

at com.ibm.db2.jcc.am.fc.X(fc.java:2718)

at com.ibm.db2.jcc.am.ResultSet.getObjectX(ResultSet.java:1438)

at com.ibm.db2.jcc.am.ResultSet.getObject(ResultSet.java:1413)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(Unknown Source)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(Unknown Source)

at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown Source)

at oracle.toplink.publicinterface.Session.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(Unknown Source)

at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(Unknown Source)

at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(Unknown Source)

at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(Unknown Source)

at oracle.toplink.queryframework.ReadAllQuery.execute(Unknown Source)

at oracle.toplink.queryframework.DatabaseQuery.execute(Unknown Source)

at oracle.toplink.queryframework.ReadQuery.execute(Unknown Source)

at oracle.toplink.publicinterface.Session.internalExecuteQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.executeQuery(Unknown Source)

at oracle.toplink.publicinterface.Session.readAllObjects(Unknown Source)

at chubb.lazuw.dao.clientworkfolder.proposal.LazInsurableCoverageDao.getInsurableCoverageByCoverageId(LazInsurableCoverageDao.java:21)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.populateBasicInformation(LazBuilderReportAuto.java:191)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.generateRecordPolicy(LazBuilderReportAuto.java:163)

at chubb.lazuw.tempo.assist.impli.LazBuilderReportAuto.execute(LazBuilderReportAuto.java:60)

at com.chubb.job.lazuw.TempoAssistJob.execute(TempoAssistJob.java:49)

at com.chubb.job.lazuw.TempoAssistJob$$FastClassByCGLIB$$4597e47c.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)

at com.chubb.job.lazuw.TempoAssistJob$$EnhancerByCGLIB$$3cf598ec.execute()

at com.chubb.job.quartz.job.impl.JobInterceptor.executeInternal(JobInterceptor.java:110)

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)

at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Caused by: java.nio.BufferOverflowException

at com.ibm.db2.jcc.am.r.a(r.java:24)

at <a href="http://com.ibm.db2.jcc.am.je">com.ibm.db2.jcc.am.je</a>.(je.java:104)

 39 more

Caused by: sun.io.ConversionBufferFullException

at sun.io.ByteToCharSingleByte.convert(ByteToCharSingleByte.java:93)

at com.ibm.db2.jcc.am.r.a(r.java:16)

 40 more

14:00:12,458 INFO LazTriggerListener:57 - Job GeraArquivosTempoAssist finalizado.
14:00:12,459 INFO LazTriggerListener:58 - Tempo total de excecução: 3760.493 segundos.

1 Resposta

Paulo_Silveira

Dei uma procurada e é um problema com versão. Baixe o driver mais recente que deve resolver!

Criado 15 de dezembro de 2015
Ultima resposta 16 de dez. de 2015
Respostas 1
Participantes 2