Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for Process Analyzer Administration and Configuration  
  Search  |  Index  
Administration & Configuration
Administrative tasks
  Daily tasks
    Prune the data warehouse
    Process the OLAP cubes
  As needed tasks
    Size the data warehouse
    Grant access rights
    Prune isolated region data
    Delete a user-defined field
Process Analyzer Engine Configuration Tool
Process Analyzer Client Configuration Tool
Other information
   

Deleting a user-defined field

At some point, you might decide to delete a user-defined data field, either because it is no longer needed or it was created in error. FileNet provides a command-line program for deleting a user-defined data field from the Process Analyzer data warehouse and the data mart. You can delete one field at a time.

NOTE Depending on the amount of data involved, deleting a data field can use a large amount of space in the SQL Server transaction log. Make sure that the transaction log is large enough or is set to grow automatically as needed. In addition, make sure that the disk drive containing the transaction log has sufficient space.

Syntax

PruneUDF "/F<user-defined field>"

Parameters

user-defined field     The name of the user-defined field to be deleted..

Example

PruneUDF "/FAccount"

To delete a user-defined data field on the Process Analyzer

  1. Use the Windows Services administrative tool to stop the AEEngine, VMAE Publisher Service, and SQLServerAgent processes. In addition, close the Process Analyzer Engine Configuration Tool and the Microsoft Analysis Manager application if either is currently running.
  2. Use the SQL Server Enterprise Manager to navigate to the appropriate database server under the SQL Server Group node. Right-click on the server name and select Properties. On the Connections tab, set the Query Time-out to 3600 seconds.
  3. Open a command prompt window and change to the directory where you installed the Process Analyzer Engine. Then execute the PruneUDF command using the syntax above. Click OK to continue.
  4. A dialog box appears indicating when the process is done. Click OK to exit.
  5. Use the SQL Server Enterprise Manager to restore the Query time-out back to its original value.
  6. Use the Services tool to restart the AEEngine, VMAE Publisher Service, and SQLServerAgent processes.