Operator Advisor convertProcessPlanFromID not working

[JO_9930585]

When trying to convert a process plan using convertProcessPlanFromID we get this error:

We think this is because within the process plan is a "longdescription" that has over 4000 chars and the sql tables only allow for 4000 chars max as shown below.

We removed this longDescription, and shortened it, and both instances worked so we are pretty sure this is the cause.

We then tried to change this from (4000) to (max) but we still get a similar(but not exactly the same) datashape error in thingworx. Has anyone encountered this before? How can we resolve this?

[JO_9930585 · Accepted solution]

We resolved this by changing the DB in 2 places to account for a longer value as shown below...