Siebel Tools >  Siebel Tools Checkout error: The employee ID must be the same on both the client and server databases

Siebel Tools Checkout error: The employee ID must be the same on both the client and server databases.

This happened when I was trying to check out anything in Siebel Tools. There was no error during database extract, local database download or doing a 'GET' on any project. I could not check out any object.

Here is the error popup

Eployee id must be same on both client and server

 

Solution:

I found out after some time, Employee ID is the row_id of the Siebvel Tools user.

So my Server employee id can be found out by running this SQL:

SELECT CREATED, ROW_ID FROM SIEBEL.S_USER WHERE LOGIN = 'mylogin';

This was 1-7MXSHBN. 

I could not open the local Database file with isqlc. It could be that the Database was encrypted.

So this is how I found out my client row_id.

First I right clicked my Siebel Tools shortcut and selected Properties. In the Target, I added a parameter  - /s C:/temp/test.txt

Siebel Tools target

 

The open Siebel Tools, select any Object e.g. Business Component.

In the Name field search with LoginId() and press Enter.

Siebel Tools Logid rowid

Press Enter. Then open file C:/temp/test.txt

This showed my Client Employee ID (marked in red).

Siebel Tools Client rowid

So my Client employee ID is '5-1HFBJYM'.

After some searching I found out that this was the row_id of my login , but from another Siebel Database! We had several Test and Production environments. But how did it happen?

I opened my Siebel Tools configuration file and checked.

Siebel Tools Configuration file

And there was the reason. Te Server ODBC Data Source was from Dev_2 ebvironment and so was the local enterprise. But the parameter DockConnectString was pointing to Dev_1 environment.

I deleted the local Database file and changed the DoclConnectString parameter. After that I had to download the local database with the correct parameters and the error was not there anymore.