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
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
The open Siebel Tools, select any Object e.g. Business Component.
In the Name field search with LoginId() and press Enter.
Press Enter. Then open file C:/temp/test.txt
This showed my Client Employee ID (marked in red).
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.
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.
|