Inactivating Workflow Processes

You can run the InactivateWFs.exe utility in development environments (Design Time Repository or DR) to inactivate workflow processes that are no longer required. The utility inactivates workflow processes that have not already been deployed or modified and which are not present in S_WFA_DPLOY_DEF (the old workflow deployment table). The InactivateWFs.exe utility inactivates workflow processess by setting the Inactive flag for the workflow processes to True and removes the corresponding compiled runtime object definition records. You might want to do this task after installing the current Siebel CRM release (and after running PostInstallDBSetup and related utilities).

The following procedure describes how to inactivate workflow processes that are no longer required.

To inactivate workflow processes

1. Run the InactivateWFs.exe utility from the command line using values appropriate to your database. This utility is located in the siebsrvr\bin or Tools\bin directory. The syntax to use is as follows:

   InactivateWFs.exe -s <InstallationPath> -t <SiebelTableOwner> -u <TableOwnerUsername> -p <Password> -o <ODBCDataSource>
   -d <RDBMSPlatform> -r <RepositoryName> -k <LogDirectory> 

   For example, for Oracle Database:

   InactivateWFs.exe -s "../ses/siebsrvr" -t SIEBEL -u SIEBEL -p ********** -o SIEBEL -d ORACLE -r "Siebel Repository" -k "../ses/siebsrvr/log"  

   For example, for Microsoft SQL Server:

    InactivateWFs.exe -s "..\ses\siebsrvr" -t dbo -u SIEBEL -p ********** -o Siebel_DSN -d MSSQL -r "Siebel Repository" -k "..\ses\siebsrvr\log" 

   For example, for DB2390:

   InactivateWFs.exe -s "../ses/siebsrvr" -t SIEBEL -u SIEBEL -p ********** -o SIEBEL -d DB2390 -r "Siebel Repository" -k "../ses/siebsrvr/log"    

2. Output appears that is similar to the following:

   Stage 1 of 3 : Setting the Repository Id
   Stage 2 of 3 : Find the WF data
   Stage 3 of 3 : Delete the run time events
   Inactivated Workflows : ../ses/siebsrvr/log/InactiveWFs_20200609_003106\InactivateWFs.out 

   If there are other errors, then review the log file(s) indicated in the error messages, resolve any issues, and then rerun the process.

Related Books

Siebel Business Process Framework: Workflow Guide