IBM FileNet P8, Version 5.2.1            

Creating a database index on a property fails: Transaction timeout (Microsoft SQL Server database)

Attempting to add a database index on a property results in an error indicating that the transaction timeout has occurred.

Symptoms

When you attempt to add a database index (also known as a single index) to a property that resides in an object store with the Microsoft SQL server configured as the database engine, an error similar to the following occurs:

A transaction problem has occurred; nested exception is: com.ibm.websphere.csi.CSITransactionRolledbackException: Transaction marked rollbackonly. Error Code: 0 Error Source: FileNet.Api 0x80004005

Causes

The application server transaction timeout value might be insufficient when the underlying table contains a very large number of rows.

Resolving the problem

Temporarily greatly increase the application server transaction timeout value and create the index during off hours.

To modify the transaction timeout value, see the appropriate topic for your application server:



Last updated: October 2015
p8pct005.htm

© Copyright IBM Corporation 2015.