Joel Santana

[Guilherme.Sautner]

I'm facing the following problem. :(

Stack trace showed below.(EOMsg)

We have Oracle persistence enabled.
This error occurs after execution some activities, and I don't know why
this is happening.

I have this post about similar issue:
http://theblasfrompas.blogspot.com/2007/07/ora-01461-from-jdbc-program-t
rying-to.html

Do you have some other ideas?

Thanks in advance.
--sautner
[phone] R. 797

Stack:
BPCOR-6149: failed while executing SQL statement UPDATE SIMPLEVARIABLE
SET stringvalue = ? WHERE stateid = ? AND varid = ? AND scopeguid = ?
java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for
insert into a LONG column
        at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError
.java:342)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedSt
atement.java:10656)
        at
com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.batchU
pdate(AbstractDBConnection.java:476)
        at
com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.update
(AbstractDBConnection.java:232)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performD
BOperationForDBOs(StateManagerImpl.java:792)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performD
BTransactionForDBOs(StateManagerImpl.java:598)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.updateSt
ate(StateManagerImpl.java:445)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.persistS
tate(StateManagerImpl.java:393)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.
doXA(PersistenceManager.java:340)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.
endXA(PersistenceManager.java:325)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.proc
ess(InvokeUnitImpl.java:707)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.doAc
tion(InvokeUnitImpl.java:182)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BP
ELInterpreter.java:162)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.e
xecute(BusinessProcessInstanceThread.java:98)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.pro
cess(BPELProcessManagerImpl.java:1031)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineI
mpl.java:289)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineI
mpl.java:1291)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.processResponse(BPELSEInOutThr
ead.java:488)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread
.java:264)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:183
)
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01461: can bind a LONG value only for insert into a LONG column
BPJBI-6001: Sending ERROR status (Service Name =
{http://enterprise.netbeans.org/bpel/Admissao/Admissao}PendencyPartnerLi
nk, Endpoint Name = PendencyManagerRole_partnerRole, Operation Name =
{http://services.senior.com.br}createSGIPendency, Message Exchange Id =
269562694349408-1328-134742320359280188)
 Error properties
  com.sun.jbi.crl.faultcode = Server
  com.sun.jbi.crl.faultstring = BPCOR-6079: Exception thrown while
processing transaction type XAEnd
  com.sun.jbi.crl.faultactor = sun-bpel-engine
  com.sun.jbi.crl.faultdetail =
   BPCOR-6079: Exception thrown while processing transaction type XAEnd
   Caused by: ORA-01461: can bind a LONG value only for insert into a
LONG column
BPCOR-6151: The process instance has been terminated because a fault was
not handled; Fault Name is
{http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHand
ling}systemFault; Fault Data is <?xml version="1.0"
encoding="UTF-8"?><jbi:message
xmlns:sxeh="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtensio
n/ErrorHandling" type="sxeh:faultMessage" version="1.0"
xmlns:jbi="http://java.sun.com/xml/ns/jbi/wsdl-11-wrapper"><jbi:part>BPC
OR-6079: Exception thrown while processing transaction type
XAEnd</jbi:part></jbi:message>
com.sun.jbi.engine.bpel.core.bpel.exception.SystemException: BPCOR-7131:
A fatal exception has occurred
BPCOR-6129: Line Number is 505
BPCOR-6130: Activity Name is CriaPendenciaChefe(It's a Invoke Activity)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.createVirt
ualFaultUnit(BPELInterpreter.java:263)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BP
ELInterpreter.java:218)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.e
xecute(BusinessProcessInstanceThread.java:98)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.pro
cess(BPELProcessManagerImpl.java:1031)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineI
mpl.java:289)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineI
mpl.java:1291)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.processResponse(BPELSEInOutThr
ead.java:488)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread
.java:264)
        at
com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:183
)
Caused by: java.lang.RuntimeException: BPCOR-6079: Exception thrown
while processing transaction type XAEnd
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performD
BTransactionForDBOs(StateManagerImpl.java:638)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.updateSt
ate(StateManagerImpl.java:445)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.persistS
tate(StateManagerImpl.java:393)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.
doXA(PersistenceManager.java:340)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.
endXA(PersistenceManager.java:325)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.proc
ess(InvokeUnitImpl.java:707)
        at
com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.doAc
tion(InvokeUnitImpl.java:182)
        at
com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BP
ELInterpreter.java:162)
        ... 7 more
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG
value only for insert into a LONG column
        at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError
.java:342)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedSt
atement.java:10656)
        at
com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.batchU
pdate(AbstractDBConnection.java:476)
        at
com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.update
(AbstractDBConnection.java:232)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performD
BOperationForDBOs(StateManagerImpl.java:792)
        at
com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performD
BTransactionForDBOs(StateManagerImpl.java:598)
        ... 14 more

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]