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: