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

WTPart 40 Character (Hard?) Limit

SOLVED
ptc-4580596
Newbie

WTPart 40 Character (Hard?) Limit

Anyone have any experience/advice for creating WTParts for documents that are 40-70 characters in length?

We are currently set up so the WTPart created in 10.1 is copying the name from the cad file. These cad files are being loaded from network drives and some have been in use for almost a decade now, and are in many assemblies.

If I try to check in these models,

ex. 3880 FITTING,PIPE,BUSHING,HEX,0.25IN FNPTX1.25MNPT.SLDPRT <- 57 Characters

then this error comes up.

Conflict Description:

The value exceeds the upper limit of "40" for "Number".

I have a few ideas how I could approach this, but it would be a very manual approach (manually create and name the Part for the cad doc) or I could simply ignore the WTPart for these files for now... I should note that I have almost 2000 of these files with freakishly long file names. And for the record, no I did not name any of these files...

Thanks in advance.

1 ACCEPTED SOLUTION
Polls

Windchill Customers

What browser do you most commonly use? (Chrome, Firefox, Edge Chromium, Internet Explorer 11, Safari, Other)


Accepted Solutions

Re: WTPart 40 Character (Hard?) Limit

You can do it by following the steps mentioned in http://www.ptc.com/cs/help/windchill_hc/wc101_hc/index.jspx?id=WCCG_Serv_CustModeledElements_CustCol...

  1. Create a model properties partModel.Properties with the below entry in wtCustom/wt/part

WTPartMaster.number.UpperLimit=350

2. Run the command ant -f bin\tools.xml custom_column -Dgen.input=wt.part

3. Run the upgrademanager -cs command for comparing the schema

4.. As per the Upgrademanager output present in ptc\Windchill\Upgrade\UpgradeManagerOutputs\UpgradeReports\CompareSchema\CompareSchema-, run the sqls to modify the table.

Hope this helps...


View solution in original post

3 REPLIES 3

Re: WTPart 40 Character (Hard?) Limit

I should mention I did just set the preference to strip the extensions of the number field so that will save me 7 characters... but this will not solve my issue.

Re: WTPart 40 Character (Hard?) Limit

You can do it by following the steps mentioned in http://www.ptc.com/cs/help/windchill_hc/wc101_hc/index.jspx?id=WCCG_Serv_CustModeledElements_CustCol...

  1. Create a model properties partModel.Properties with the below entry in wtCustom/wt/part

WTPartMaster.number.UpperLimit=350

2. Run the command ant -f bin\tools.xml custom_column -Dgen.input=wt.part

3. Run the upgrademanager -cs command for comparing the schema

4.. As per the Upgrademanager output present in ptc\Windchill\Upgrade\UpgradeManagerOutputs\UpgradeReports\CompareSchema\CompareSchema-, run the sqls to modify the table.

Hope this helps...


View solution in original post

Re: WTPart 40 Character (Hard?) Limit

Hello Binesh Kumar, is it procedure for oracle db? How i can upgrade schema with MSSQL?

SQL file that generate script can not be executed by MS SQL. Here is the log:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'Foundation'.

Msg 111, Level 15, State 1, Line 36

'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Msg 156, Level 15, State 1, Line 45

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 57

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 69

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 81

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 93

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 105

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 117

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 129

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 141

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 153

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 165

Incorrect syntax near the keyword 'PROCEDURE'.

Msg 156, Level 15, State 1, Line 177

Polls

Windchill Customers

What browser do you most commonly use? (Chrome, Firefox, Edge Chromium, Internet Explorer 11, Safari, Other)