Siebel License Key Update from Back-End

Siebel License Key Update from Back-End

When one needs to insert license key to Siebel CRM server when the Administration-Application option is not available

after logging in as SADMIN/SADMIN, please log into the Microsoft SQL Server Management studio and then type the following DB queries:

use siebeldb

select * from S_REPOSITORY

select * from S_APP_VER

select * from S_APP_KEY

update S_APP_KEY

set APP_KEY = '7207 0105 7880 5783 3210 3318 0417 3444 2103 3197 3818 7591 8759 1870 0187 5916 1241 8744 1873 2187 5918 7591 8759 8726 2180 4221 032'

Where ROW_ID='1-K53'

OR

I went to Administration Application > License Keys and applied the license keys on my local and was successful. I was able to see all the views related to this key.

I have searched in the Support Web and found the resolution for this issue. You can check for the Doc ID 530845.1. This document was previously published as Siebel SR 38-3279920201. Below steps will resolve the issue.

    * Copy the sse_samp.dbf file from \Webclient\Sample\utf8 folder to the \webclient\local folder.

    * You need to change the connect string parameter under [Local] section of CFG file. In my case it was uagent.cfg file. Your original connect string will look similar to string given below

          ConnectString = C:\PROGRA~1\Siebel\7.8\WEBCLI~1\local\sse_data.dbf -q -m -x NONE -gp 4096 -c15p -ch25p

    * Only change the dbf file name to sse_samp.dbf. This way all the attributes related to the local db is available for the Sample db also. The final connect string parameter after editing should as below.

          ConnectString = C:\PROGRA~1\Siebel\7.8\WEBCLI~1\local\sse_samp.dbf -q -m -x NONE -gp 4096 -c15p -ch25p

    * Now log into the dedicated client as Local with Sadmin/sadmin.

    * Apply license key from here as New button is enabled.

    * Log out and move back the sse_samp.dbf file to original Sample\UTF8 folder to continue to work as usual.

    * Change the Local connect string to the original one.

    * Re-log in to the Sample DB to view the new views.

Apart from this way, we can also add license key from Tools or Inserting the key into S_APP_KEY table under the Sample DB using dbisqlc.exe.

Hope this may be useful to someone.