Data Truncation Issue for Account CP

[Suresh1]

Hello Team,

We have couple of tasks stuck in the pending tasks list due to a data truncation exception for one of the account CP (CP2). CP2 gets populated from a dynamic attribute and it has a large text more than 250 chars. 

I have tried to complete the task manually from UI as well but no luck same error.

I would like to understand is there a way to complete these tasks ? If yes, How can i do that ?  

[stalluri]

@Suresh1 
You can check the accounts table and find the datatype.

 

[mbh_it2]

@Suresh1  Can you attach complete logs? Instead of using CP2 you can use some other CP for the same which has Medium text data type.

[rushikeshvartak]

Change custom property mapping from cp2 to any customproperty cp32-cp59

[Suresh1]

Yeah, I can change the cp2 to cp31 as its having long text datatype. but would i be able to close the existing pending tasks which are already created ?

[rushikeshvartak]

No, You need to recreate request

[stalluri]

@Suresh1 
Discontinue existing tasks and create a new request.