Tuesday, October 20, 2009

The repository database is already associated with the CE server.

Scenario : We were using shared content engine server 4.5 through Capture Professional 5.2 and were able to perform all the required operations. The database we were using is SQL Server 2005. Due to some migration activity we were needed to drop and recreate the existing object stores. After it happened we were not able to open and connect to the CE repositories and were getting following error:



Solution : When we configure a Shared CE repository for the first time it creates few tables for house keeping purpose. These tables are only used by Capture internally. Among these table , there is one table named 'DBInfo'. It has following structure :

RowID PropertyName PropertyValue
1 UsageType Repository
2 RepositoryType Shared CE Repository
3 RepositoryConnection {GUID Value}
4 CapProVersion {Capture Pro Version}

Follow the below steps:
a). In this table update the GUID Value to the new GUID Value of object store.
b). Delete the DSN pointing to the sql database for your CE Shared repository.
c). Delete the capture repository using Capture Manager.
d). Create DSN accessing the same SQL Database.
e). Configure the same CE Shared repository again.

Now open Capture Professional. you should be able to see your repository.

1 comment:

Anonymous said...

Excellent,had same issue, followed steps as given and it worked well