How to increase the length/size of the 'proc_type' field in the har_virx MDB table.

Document ID : KB000045360
Last Modified Date : 14/02/2018
Show Technical Document Details

Question

How to increase the length/size of the 'proc_type' field in the har_virx MDB table.

Answer

Unfortunately, there is no supported way to increase the length of the 'proc_type' field in the har_virx MDB table.

As an alternative, we recommend creating a custom field to replace the 'proc_type' field:

1. Login to Web Screen Painter (WSP)
2. Go to Tools -> Schema designer
3. In the left side under Tables, select nr
4. Click 'Add Column '
5. Enter column name (zProcessorType) and click OK
6. Change column properties as desired (type, length, etc.) and click SAVE 
7. Click File -> Save and Publish, then click YES and then OK
8. Click File -> Close to exit schema designer
9. Close WSP and stop CA SDM services
10. Run pdm_publish command via a command prompt
11. Restart CA SDM services
12. Login to Web Screen Painter (WSP)
13. Click File -> Open and select the ' nr_cmdb_har_worx_tab.htmpl' form
14. Double click the processor type control
15. Click on Attribute to change the attribute and select the newly created column (zProcessorType)
16. Click SAVE  
17. Click File -> Publish and OK twice
18. Run pdm_webcache command via a command prompt and clear web browser cache prior to accessing CA SDM UI