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 Jennifer Durina
Appian Employee
over 9 years ago

Appian text fields don't have data caps anymore, but Siki is right--it's an issue with writing it to the database. If this was a database that Appian created in MySQL (using a CDT), then text defaults are 255. However, you can adjust the table constraint on the actual database. For new columns, you can increase the number of characters using the JPA annotaiton @Column(columnDefinition="varchar(4000)") or some other character size. For more information on the JPA annotations, the Custom Data Types from XSD page has a lot of good info.

forum.appian.com/.../Custom_Data_Types_from_XSD.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jennifer Durina
Appian Employee
over 9 years ago

Appian text fields don't have data caps anymore, but Siki is right--it's an issue with writing it to the database. If this was a database that Appian created in MySQL (using a CDT), then text defaults are 255. However, you can adjust the table constraint on the actual database. For new columns, you can increase the number of characters using the JPA annotaiton @Column(columnDefinition="varchar(4000)") or some other character size. For more information on the JPA annotations, the Custom Data Types from XSD page has a lot of good info.

forum.appian.com/.../Custom_Data_Types_from_XSD.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data