Skip to main content
14-Alexandrite
April 18, 2023
Solved

Operator Advisor convertProcessPlanFromID not working

  • April 18, 2023
  • 1 reply
  • 763 views

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?

 

 

 

Best answer by JO_9930585

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
April 18, 2023

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

JO_9930585_0-1681853198509.png