10-02-2019 8:06 AM - edited 02-03-2024 5:09 PM
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
Solution: update 'integrationkey' column in database and set length to a bigger value. Fortunately it has worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.