Error Creating File Cabinets Against SQL 2005 Database: "The cursor does not include the table being modified or the table is not being updatable through the cursor"

(Doc ID 1307665.1)

Last updated on JULY 10, 2012

Applies to:

Oracle WebCenter Capture 10g - Version 5.0 to 10.1.3.5.1 [Release Stellent to 10gR3]
Oracle WebCenter Distributed Capture - Version 5.0 to 10.1.3.5.1 [Release Stellent to 10gR3]
Information in this document applies to any platform.

Symptoms

When attempting to add a file cabinet the following error is returned:


Administration
Failed to add commit profile. Error Number: 40004, Error Description: The following error occurred saving the commit profile. Error Number: -2147205115 Error Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include the table being modified or the table is not being updatable through the cursor.

Changes

This is a new database and a new Oracle Document Capture workstation attempting to create file cabinets.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms