• State Not Answered
  • Replies 5 replies
  • Subscribers 6 subscribers
  • Views 5824 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Process

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

greggl
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={<...

OriginalPostID-163783

OriginalPostID-163783

  Discussion posts and replies are publicly visible

Parents
  • 0
    ...null>,,2015-08-24 19:46:08.45,,<null>,,glipson,<null>,333,testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description ,3.3333333E7,Bike,2015-08-03,2015-08-03,333,333,glipson,glipson,<null>,,,[Folder:22137],Bike New,,<null>}]
    Problem: An error occurred in executing an Activity Class.
    Recommended Action: Examine the activity class to correct the error and then resume.
    Priority of this problem: High Priority
    View the Process for this Task.
Reply
  • 0
    ...null>,,2015-08-24 19:46:08.45,,<null>,,glipson,<null>,333,testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description testing long description ,3.3333333E7,Bike,2015-08-03,2015-08-03,333,333,glipson,glipson,<null>,,,[Folder:22137],Bike New,,<null>}]
    Problem: An error occurred in executing an Activity Class.
    Recommended Action: Examine the activity class to correct the error and then resume.
    Priority of this problem: High Priority
    View the Process for this Task.
Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.