Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
Open the Change Request list of attributes in the Type and Attribute Managemnt utility, then Action Edit and select the star to add a new attribute.
When I enter the information, then Finish, I get this error message:
ATTENTION:
An attribute of type "java.lang.String" cannot be created because no database colums of that type are available. Contact your system administrator to execute the AddColumns utility which will allocate more columns.
Can soeone give me more details on running the AddColumns utility, what inputs are needed, where it is located, how to run it, etc?
Solved! Go to Solution.
Ben Loosli wrote:
Open the Change Request list of attributes in the Type and Attribute Managemnt utility, then Action Edit and select the star to add a new attribute.
When I enter the information, then Finish, I get this error message:
ATTENTION:
An attribute of type "java.lang.String" cannot be created because no database colums of that type are available. Contact your system administrator to execute the AddColumns utility which will allocate more columns.
Can soeone give me more details on running the AddColumns utility, what inputs are needed, where it is located, how to run it, etc?
Hi Ben,
I did this some time ago. Here is the response from tech support:
AddColumns wt.part.WTPart String=3 Long=4 Double=1 Z:\Windchill\src
This example adds 3 String columns, 4 Long columns and 1 Double columns to
WTPart type's database schema.
Rebuild the client jars after manually running the AddColumns tool. Use the following steps to rebuild the client jars:
The above example is for WTPart, but doing it for Change Request wasn't that hard to figure out. IIRC, the Help Center instructions were incomplete, missing step 3 above.
@Hi Ben,
It seem’ s you are creating Standard attribute for Change request. Standard attributes are stored in columns directly on the underlying object class. Out-of-the-box, there are no additional columns on any object class for standard attributes.We need to run Add column Utility to create a column for Change request.
Running the AddColumns Tool:
Command is: AddColumns type_name datatype=number {datatype=number}
Where, type_name is class name for object(wt.change2.WTChangeRequest2)
Datatype - if you want to create string attribute then write string
Number is, how many columns you want to create
For e.g , if you want to create a column for change request object for string data type then you have to run the below command using windchill shell
Addcolumns wt.change2.WTChangeRequest2 string=1
Above command will create a cloumn in WTChangeRequest2 database table.
Then , Rebuild the client jars after manually running the AddColumns tool. Use the following steps to rebuild the client jars:
cd <Windchill>/codebase ant -f MakeJar.xml
4. Restart the server.
After creating a column, then you can create a standard attribute for change request.
I would recommend you to perform this on test server first.
Let me know, if you have any doubts on this.
Thanks,
Jalpesh
Ben Loosli wrote:
Open the Change Request list of attributes in the Type and Attribute Managemnt utility, then Action Edit and select the star to add a new attribute.
When I enter the information, then Finish, I get this error message:
ATTENTION:
An attribute of type "java.lang.String" cannot be created because no database colums of that type are available. Contact your system administrator to execute the AddColumns utility which will allocate more columns.
Can soeone give me more details on running the AddColumns utility, what inputs are needed, where it is located, how to run it, etc?
Hi Ben,
I did this some time ago. Here is the response from tech support:
AddColumns wt.part.WTPart String=3 Long=4 Double=1 Z:\Windchill\src
This example adds 3 String columns, 4 Long columns and 1 Double columns to
WTPart type's database schema.
Rebuild the client jars after manually running the AddColumns tool. Use the following steps to rebuild the client jars:
The above example is for WTPart, but doing it for Change Request wasn't that hard to figure out. IIRC, the Help Center instructions were incomplete, missing step 3 above.
All,
Please remember Windchill's context-sensitive help topics. Clicking on the (?) button on the screen that gives the error leads to the WHC topic: Creating a New Attribute.
Good information there regarding the difference between Standard and Global attributes.