cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Operator Advisor convertProcessPlanFromID not working

JO_9930585
9-Granite

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?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

JO_9930585_0-1681853198509.png

 

View solution in original post

1 REPLY 1

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

JO_9930585_0-1681853198509.png

 

Top Tags