Skip to main content
14-Alexandrite
Apr 18, 2023 9:13 PM UTC
Solved

Operator Advisor convertProcessPlanFromID not working

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

JO_9930585_1-1681852246104.png

 

 

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.

JO_9930585_0-1681852014671.png

 

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?

 

 

 

14-Alexandrite
Apr 18, 2023 9:27 PM UTC

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

JO_9930585_0-1681853198509.png

 

1 reply

JO_993058514-AlexandriteAuthorAnswer
14-Alexandrite
Apr 18, 2023 9:27 PM UTC

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

JO_9930585_0-1681853198509.png

 

Translate