QAID # 19036 Published
Question / Problem:
What can cause the following errors when trying to launch Kofax Capture modules after installing a service pack or fix pack?
 KdoLib:  KdoLib: Error executing SQL command. Cannot find the object 'viewUserBatches', because it does not exist or you do not have permission. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. (15151)
 KdoLib: Error getting data reader from SQL command. The SELECT permission was denied on the object 'viewAbandonedBatchLocks', database 'KofaxCapture', schema 'dbo'. (229)
How can this issue be resolved?
Answer / Solution:
This issue can be caused by using a database user without sufficient permission to update the Kofax Capture database.
During upgrades and service pack installations, the database login must be a member of the
To resolve this issue:
- Add the
db_ownerrole to the database user for the Kofax Capture database.
- Stop all Kofax services.
- Run the command to unpatch the Kofax Capture database:
> DBUtil.exe /unpatchall
- Uninstall the service pack or fix pack from Programs and Features or Add and Remove Programs.
- Reinstall the service pack or fix pack.