Issue: Unable to upload files with size over 1MB from Release with DB2 database

Issue

Cannot upload an attachment more than 1MB to a UserInput task.

Logs:

2022-06-20 16:20:56.842 [qtp1489293128-41] {request=/upload/attachment/Folderc68523be35ab4c92ad6
81a00381bb163-Release949a289209444b0ea9aaa38a7285a16f-Phasec5bf5f5734704d2bacd2b6aa53a5a546-
Taske028224947be4119aa087bbd212dfb2e, method=POST, username=admin} ERROR c.x.d.r.m.Unhandled
ExceptionMapper - Unhandled Exception: {}
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT
INTO XLR_ARTIFACTS
(ARTIFACT_ID, CI_UID, ARTIFACT_NAME, CONTENT)
VALUES (?,?,?,?)]; [jcc][t4][102][10040][4.25.13] Batch failure.  The batch was submitted, but
at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229,
SQLSTATE=null; nested exception is com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040]
[4.25.13] Batch failure.  The batch was submitted, but at least one exception occurred on an
individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229,
SQLSTATE=null
.....
.....
Caused by: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.25.13] Batch failure.
The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229,
SQLSTATE=null

Affected Products & Versions

Following Release versions with DB2 database

  • 10.2.0 - 10.2.6
  • 10.3.0

Steps to Recreate

  1. Setup any of the affected versions of Release with DB2 database 
  2. Create a new Template > TASK as below
         Task --> core --> UserInput --> Attachments
  3. Try attaching a file more than 1MB size

Workaround/Resolution Action

Upgrade your Release instance to any of the following versions:

  • 10.2.7 or above
  • 10.3.1 or above
  • 22.x

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.