Activiti

Posting a comment to a task causes an exception (Bad value for type long) (After updating from 5.8 to 5.9)

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 5.9
  • Fix Version/s: 5.11
  • Component/s: Explorer
  • Labels:
  • Environment:
    Debian VM, Tomcat 7, PostgreSQL 8.4
  • Number of attachments :
    3

Description

After upgrading Activiti 5.8 to 5.9 you get an exception when trying to post a comment (in the top right corner) for any task.

This only seems to happen when using a PostgreSQL database. When using H2 this will not happen. I tried both, vanilla.

The Exception (After trying to comment "Hello World"):

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.postgresql.util.PSQLException: Bad value for type long : \x48656c6c6f20
### The error may involve org.activiti.engine.impl.persistence.entity.CommentEntity.selectEventsByTaskId-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: Bad value for type long : \x48656c6c6f20576f726c64.
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
        at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:182)
        at org.activiti.engine.impl.persistence.entity.CommentManager.findEventsByTaskId

Check the attachment for a full stacktrace!

  1. Text File
    20120314_long_task_comment.txt
    15/Mar/12 4:27 AM
    7 kB
    Chris Samulski
  2. Text File
    ACT-1147.patch
    14/May/12 7:29 AM
    2 kB
    Jerome Cavezian
  3. Text File
    ACT-1147-5.10.patch
    02/Oct/12 3:13 AM
    2 kB
    Jerome Cavezian

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Jerome Cavezian added a comment - - edited

my small contribution to help things go forward.
this solve the problem.
see ACT-1147.patch

Show
Jerome Cavezian added a comment - - edited my small contribution to help things go forward. this solve the problem. see ACT-1147 .patch
Jerome Cavezian made changes -
Field Original Value New Value
Attachment ACT-1147.patch [ 59916 ]
Hide
Permalink
Jerome Cavezian added a comment -

Patch for 5.10

Show
Jerome Cavezian added a comment - Patch for 5.10
Jerome Cavezian made changes -
Attachment ACT-1147-5.10.patch [ 61522 ]
Joram Barrez made changes -
Assignee Joram Barrez [ jbarrez ]
Hide
Permalink
Joram Barrez added a comment -

Thanks!

Show
Joram Barrez added a comment - Thanks!
Joram Barrez made changes -
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 5.11 [ 18342 ]
Resolution Fixed [ 1 ]

People

  • Assignee:
    Joram Barrez
    Reporter:
    Chris Samulski
Vote (2)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: