3 Replies Latest reply: Mar 20, 2013 9:12 PM by user4889882 RSS

    Exception while polling class java.lang.String could not be converted

    user4889882
      SOA Suite 11.1.1.6.0

      Hi,

      I create a Bpel process for polling with DB Adapter and polling strategy ExternalSequencingPollingStrategy. When reading DB exception is rised:

      <20/03/2013 06:05:15 PM CST> <Error> <oracle.soa.adapter> <BEA-000000> <Database
      Adapter GetInstUpdate <oracle.tip.adapter.db.InboundWork handleException> Encou
      ntered a fatal exception while polling. Will continue polling but with minimal
      logging. Please investigate the fault and manually stop polling from the consol
      e if in development and this appears to be a modeling mistake. BINDING.JCA-1162
      4
      Excepci¾n de sondeo de DBActivationSpec.
      Nombre de consulta: [getInstallationSelect], nombre de descriptor: [getInstallat
      ion.Service]. Sondeando la base de datos en busca de eventos con fallos en esta
      iteraci¾n.
      Causado por: Exception [EclipseLink-3002] (Eclipse Persistence Services - 2.3.1.
      v20111018-r10243): org.eclipse.persistence.exceptions.ConversionException
      Exception Description: The object [type], of class [class java.lang.String], fro
      m mapping [org.eclipse.persistence.mappings.DirectToFieldMapping[type-->service.
      type]] with descriptor [ObjectRelationalDataTypeDescriptor(getInstallation.Servi
      ce --> [DatabaseTable(service)])], could not be converted to [class java.math.Bi
      gDecimal].
      Internal Exception: java.lang.NumberFormatException.
      Esta excepci¾n se considera no recuperable, probablemente debido a un error de
      modelado. Se cerrarß este proceso de sondeo, a menos que el fallo estÚ relacio
      nado con el procesamiento de una fila concreta, en cuyo caso el sondeo continuar
      ß aunque se rechazarß la fila (con fallo).

      at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriab
      leException(DBResourceException.java:690)
      at oracle.tip.adapter.db.exceptions.DBResourceException.createEISExcepti
      on(DBResourceException.java:656)
      at oracle.tip.adapter.db.exceptions.DBResourceException.inboundReadExcep
      tion(DBResourceException.java:491)
      at oracle.tip.adapter.db.InboundWork.handleException(InboundWork.java:98
      3)
      at oracle.tip.adapter.db.InboundWork.runOnce(InboundWork.java:887)
      at oracle.tip.adapter.db.InboundWork.run(InboundWork.java:620)
      at oracle.tip.adapter.db.inbound.InboundWorkWrapper.run(InboundWorkWrapp
      er.java:43)
      at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run
      (WorkManagerExecutor.java:120)
      at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManag
      er.java:184)
      at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
      Caused by: Exception [EclipseLink-3002] (Eclipse Persistence Services - 2.3.1.v2
      0111018-r10243): org.eclipse.persistence.exceptions.ConversionException
      Exception Description: The object [type], of class [class java.lang.String], fro
      m mapping [org.eclipse.persistence.mappings.DirectToFieldMapping[type-->service.
      type]] with descriptor [ObjectRelationalDataTypeDescriptor(getInstallation.Servi
      ce --> [DatabaseTable(service)])], could not be converted to [class java.math.Bi
      gDecimal].
      Internal Exception: java.lang.NumberFormatException
      at org.eclipse.persistence.exceptions.ConversionException.couldNotBeConv
      erted(ConversionException.java:79)
      at org.eclipse.persistence.internal.helper.ConversionManager.convertObje
      ctToBigDecimal(ConversionManager.java:199)
      at org.eclipse.persistence.internal.helper.ConversionManager.convertObje
      ct(ConversionManager.java:127)
      at oracle.tip.adapter.db.ox.CustomConversionManager.convertObject(Custom
      ConversionManager.java:129)
      at org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.co
      nvertObject(DatasourcePlatform.java:160)
      at org.eclipse.persistence.platform.database.oracle.Oracle9Platform.conv
      ertObject(Oracle9Platform.java:368)
      at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.get
      AttributeValue(AbstractDirectMapping.java:704)
      at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.val
      ueFromRow(AbstractDirectMapping.java:1299)
      at org.eclipse.persistence.mappings.DatabaseMapping.readFromRowIntoObjec
      t(DatabaseMapping.java:1326)
      at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildAttri
      butesIntoObject(ObjectBuilder.java:445)
      at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjec
      t(ObjectBuilder.java:798)
      at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjec
      t(ObjectBuilder.java:603)
      at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjec
      t(ObjectBuilder.java:560)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObject(Obje
      ctLevelReadQuery.java:717)
      at org.eclipse.persistence.queries.Cursor.buildAndRegisterObject(Cursor.
      java:310)
      at org.eclipse.persistence.queries.CursoredStream.retrieveNextObject(Cur
      soredStream.java:425)
      at org.eclipse.persistence.queries.CursoredStream.setLimits(CursoredStre
      am.java:462)
      at org.eclipse.persistence.queries.CursoredStream.<init>(CursoredStream.
      java:58)
      at org.eclipse.persistence.queries.CursoredStreamPolicy.execute(Cursored
      StreamPolicy.java:67)
      at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQu
      ery(ReadAllQuery.java:408)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQ
      uery(ObjectLevelReadQuery.java:1081)
      at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.j
      ava:844)
      at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLe
      velReadQuery.java:1040)
      at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.jav
      a:392)
      at org.eclipse.persistence.internal.sessions.AbstractSession.internalExe
      cuteQuery(AbstractSession.java:2831)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuer
      y(AbstractSession.java:1516)
      at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuer
      y(AbstractSession.java:1498)
      at oracle.tip.adapter.db.inbound.AbstractSequencingPollingStrategy.poll(
      AbstractSequencingPollingStrategy.java:610)
      at oracle.tip.adapter.db.InboundWork.runOnce(InboundWork.java:747)
      ... 5 more
      Caused by: java.lang.NumberFormatException
      at java.math.BigDecimal.<init>(BigDecimal.java:459)
      at java.math.BigDecimal.<init>(BigDecimal.java:728)
      at org.eclipse.persistence.internal.helper.ConversionManager.convertObje
      ctToBigDecimal(ConversionManager.java:181)
      ... 32 more