Datahub - Data truncation: Data too long for column 'integrationkey' at row 1

[mainroad]

Hello, we need your help.

We are getting this error in our Datahub production environment and we are not able to generate IDOCs ORDERS in SAP ECC 2019-10-01 17:41:23,485 7359577286 [DataHubActorSystem-akka.actor.default-dispatcher-20] ERROR akka.actor.OneForOneStrategy - PreparedStatementCallback; SQL [INSERT INTO CanonicalItem(modifiedtime,itemtype,compositionaction,datapool,id,creationtime,compositionstatusdetail,version,integrationkey,status,typecode,schemaless_attrs,batchid,traceid,documentid,uuid) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Data truncation: Data too long for column 'integrationkey' at row 1; nested exception is java.sql.BatchUpdateException: Data truncation: Data too long for column 'integrationkey' at row 1 2019-10-01 17:41:23,917 7359577718 [defaultTaskExecutor-1] ERROR c.h.d.s.c.i.AbstractCompositionActionHandler - Error during composition with action id: 2631085 We need your support to fix this issue.

After an update on hybri side, now we are getting this error.

Any help will be appreciated.

Regards

[former_member254774]

Solution: update 'integrationkey' column in database and set length to a bigger value. Fortunately it has worked.