[
https://jira.jboss.org/jira/browse/JBPM-2057?page=com.atlassian.jira.plug...
]
jarkko Lietolahti commented on JBPM-2057:
-----------------------------------------
This issue troubles other dbs and fields also;
This is from h2 which is like hsqldb but more strict when it comes to SQL-correctness;
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column EXCEPTION_:
STRINGDECODE('org.mvel.CompileException: unable to resolve property: products\n\tat
org.mvel.optimizers.impl.refl.ReflectiveAccessorOptimizer.compileGetChain(ReflectiveAccessorOptimizer.java:289)\n\tat
org.mvel.optimizers.impl.refl.ReflectiveAccessorOptimizer.optimizeAccessor(ReflectiveAccessorOptimizer.java:110)\n\tat
org.mvel.optimizers.impl.refl.ReflectiveAccessorOptimizer.get(ReflectiveAccessorOptimizer.java:94)\n\tat
org.mvel.MVEL.getProperty(MVEL.java:572)\n\tat
org.jboss.soa.esb.services.jbpm.JBpmObjectMapper.setOnEsbMessage(JBpmObjectMapper.java:140)\n\tat
org.jboss.soa.esb.services.jbpm.JBpmObjectMapper.mapFromJBpmToEsbMessage(JBpmObjectMapper.java:81)\n\tat
org.jboss.soa.esb.services.jbpm.actionhandlers.EsbNotifier.execute(EsbNotifier.java:103)\n\tat
org.jbpm.graph.def.Action.execute(Action.java:129)\n\tat
org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:284)\n\tat
org.jbpm.graph.def.GraphElement.executeActions(GraphElement.java:241)\n\tat
org.jbpm.graph.def.GraphElement.fireAndPropagateEvent(GraphElement.java:213)\n\tat
org.jbpm.graph.def.GraphElement.fireEvent(GraphElement.java:196)\n\tat
org.jbpm.graph.def.Node.enter(Node.java:371)\n\tat
sun.reflect.GeneratedMethodAccessor250.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.graph.def.Node$$EnhancerByCGLIB$$a739a6d1.enter(<generated>)\n\tat
org.jbpm.graph.def.Transition.take(Transition.java:167)\n\tat
org.jbpm.graph.def.Node.leave(Node.java:479)\n\tat
sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.graph.def.Node$$EnhancerByCGLIB$$a739a6d1.leave(<generated>)\n\tat
org.jbpm.graph.exe.Token.signal(Token.java:223)\n\tat
org.jbpm.graph.exe.Token.signal(Token.java:150)\n\tat
sun.reflect.GeneratedMethodAccessor245.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.graph.exe.Token$$EnhancerByCGLIB$$d693144d.signal(<generated>)\n\tat
org.jbpm.command.SignalCommand.execute(SignalCommand.java:100)\n\tat
org.jboss.soa.esb.services.jbpm.cmd.AsyncProcessSignal$AsyncSignalAction.execute(AsyncProcessSignal.java:300)\n\tat
org.jbpm.graph.def.Action.execute(Action.java:129)\n\tat
sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.graph.def.Action$$EnhancerByCGLIB$$a0a3a02d.execute(<generated>)\n\tat
org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:284)\n\tat
sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.graph.def.Node$$EnhancerByCGLIB$$a739a6d1.executeAction(<generated>)\n\tat
org.jbpm.job.ExecuteActionJob.execute(ExecuteActionJob.java:37)\n\tat
sun.reflect.GeneratedMethodAccessor239.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat
java.lang.reflect.Method.invoke(Method.java:597)\n\tat
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:157)\n\tat
org.jbpm.job.Job$$EnhancerByCGLIB$$16f1af8a.execute(<generated>)\n\tat
org.jbpm.job.executor.JobExecutorThread.executeJob(JobExecutorThread.java:166)\n\tat
org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:60)\nCaused by:
org.mvel.PropertyAccessException: unable to resolve property: products\n\tat
org.mvel.optimizers.impl.refl.ReflectiveAccessorOptimizer.getBeanProperty(ReflectiveAccessorOptimizer.java:383)\n\tat
org.mvel.optimizers.impl.refl.ReflectiveAccessorOptimizer.compileGetChain(ReflectiveAccessorOptimizer.java:258)\n\t...
53 more\n') [90005-68]
at org.h2.message.Message.getSQLException(Message.java:91)
at org.h2.message.Message.getSQLException(Message.java:95)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:248)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:468)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:197)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 62 more
Do not truncate long messages/exceptions
----------------------------------------
Key: JBPM-2057
URL:
https://jira.jboss.org/jira/browse/JBPM-2057
Project: JBoss jBPM
Issue Type: Bug
Environment: Sybase/DB2
Reporter: Ryan Campbell
Assignee: Thomas Diesler
Fix For: jBPM-3.2.5.SP2, jBPM 3.2.6 GA
For sybase, a "text" column should be used instead of the current
varchar(4000)
This will prevent the truncation of stack traces.
Do to data migration issues we cannot change the mapping of existing db columns. Instead
the issue should be resolved by adding additional "text" columns.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira