Skip to main content
Kofax

KFS Fixpack 8 cannot be installed, because DB schema is not dbo

Article # 3032462 - Page views: 41

Article # 3032462 - Page views: 41

Issue

Latest KFS FP cannot be installed due to DB Schema is unequal to "dbo".

How can I change DB schema for KFS database?

 

 

Solution

1.) ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.ObjectName -> (please notice that ALTER SCHEMA must be done per DB object (Table, SP orView))

2.) User must have appropriate permission to DB

3.) run the KFS SP or FP update

4.) keep dbo schema or change back to old schema, steps are the same as in 1.)

 

How to change schema of all tables, views and stored procedures in MSSQL:

https://stackoverflow.com/questions/17571233/how-to-change-schema-of-all-tables-views-and-stored-procedures-in-mssql/17571234#17571234

 

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KFS 4.3      

References

Add any references to other internal or external articles

  • Was this article helpful?