An error appears when trying to consolidate K2 database using Database Consolidation tool v1.9
kbt141290
PRODUCTK2 blackpearl
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
The following error appears when trying to consolidate K2 database using Database Consolidation tool v1.9:
"Could not get database info: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SmartBroker.SmartObject'"
Symptoms
The issue could be caused by incorrect Schemas for SmartBroker DB. The schema was set to “dbo” instead of “SmartBroker”. Reviewing installTrace when the environment was upgraded, we noticed the following error:
Error","15","15002","ERROR","SourceCode.Database.Configuration.ConfigureDBs","15002 SqlException.Number != -2, so not handling it as a timeout. SqlException.Number = 207. Exception: Invalid column name 'AuthenticationPassword'.","anonymous","0.0.0.0"
Troubleshooting Steps
To resolve this issue:
- Add the 'AuthenticationPassword' column to the [K2SmartBroker].[dbo].[ServiceInstance] table.
- Run K2 Blackpearl Setup Manager from Installer with the Repair option.
- After the repair is complete, make sure that Schemas for SmartBroker DB is set to “SmartBroker".
The Database Consolidation tool v1.9 should now work as expected.
