Adding an Attribute for Change Request

[BenLoosli]

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?

[jdadania]

@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:

1. Stop the server.
2. Open a Windchill shell.
3. Run the following command:

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

[DonSenchuk · Accepted 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:

• Please refer to Customizer s Guide http://www.ptc.com/WCMS/files/158620/en/10_2_M010_WindchillCustomizationGuide.pdf
• Section "Allocate Database Columns for Standard Attributes" in Windchill Help Center
• Section "Adding Columns to Types" in Windchill Help Center

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:

1. 1. Stop the server
2. 2. Open a windchill shell
3. 3. Run the following commands: cd <windchill>/codebase ant -f MakeJar.xml
4. 4. Restart the server

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.

[BenPerry]

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.