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.

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.