The attached DeploymentPatch.zip archive contains a SQL script that can be used to improve the deployment performance of custom client applications using the Client Application Framework.
Issue/Introduction
Improving the Deployment Performance of Custom Client Applications Using the Client Application Framework
Environment
All supported operating systems using Microsoft SQL Server database
Resolution
To apply the patch: 1. Shut down the tibcohost that hosts the ActiveMatrix BPM system. 2. Take a backup of the ActiveMatrix BPM database and the ActiveMatrix Administrator database. 3. Login to Microsoft SQL Server Management Studio. 4. Execute the apa-create-indexes-mssql.sql SQL script on the ActiveMatrix BPM database. 5. Restart the tibcohost that hosts the ActiveMatrix BPM system.
If you want to subsequently remove the patch: 1. Shut down the tibcohost that hosts the ActiveMatrix BPM system. 3. Login to Microsoft SQL Server Management Studio. 4. Execute the apa-drop-indexes-mssql.sql SQL script on the ActiveMatrix BPM database. 5. Restart the tibcohost that hosts the ActiveMatrix BPM system.
Additional Information
DeploymentPatch.zip
Attachments
Improving the Deployment Performance of Custom Client Applications Using the Client Application Framework
get_app