I am getting the error below when trying to save a long text input to the databa

greggl over 9 years ago

I am getting the error below when trying to save a long text input to the database using the Write to Data Store Entity Smart Service. Does anyone know what the max length allowed for a paragraph text field is when saving to the database?

And why is that max allowed length not part of the paragraph field documentation in Appian Docs or the write to data store documentation in Appian Docs?

Thanks,
Gregg

There is a problem with task “Create Active Contract in App Datastore” in the process “Contracting: IT Contract Request initiated by Gregg Lipson”. An error occurred while trying to write to the entity “contracts” [id=182d6f12-e7a0-4433-8e64-c78058a874b9@15546, type=CMcontract (id=3150)] (data store: contractManagerDatastore). Details: org.hibernate.exception.DataException: could not insert: [CMcontractDT1719]: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'contractdescription' at row 1 Data: TypedValue[it=3150,v={<...

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 9 years ago

@greggl Hi, one of the prime causes for this error is, trying to insert the data of length which is beyond the capacity of column. Let's say 'contractdescription' column can hold only 10 characters and if we try to insert a value which has 11 characters, then the write operation fails by throwing "com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column" error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@greggl Hi, one of the prime causes for this error is, trying to insert the data of length which is beyond the capacity of column. Let's say 'contractdescription' column can hold only 10 characters and if we try to insert a value which has 11 characters, then the write operation fails by throwing "com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column" error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data