The Siebel EIM group is a forum where peers share technical expertise, solve problems, and discuss issues related to Siebel Enterprise Incentive Management (EIM), also referred to as Incentive Compensation Management.

How to create a new column in S SRV REQ table

As per our requirement we need to create new column in S_SRV_REQ table
,I followed few basic steps
1)Login into Siebel Tools connecting to Local.
2) Locked the S_SRV_REQ table.
3)I have done the right click on the columns section and created a new
record. Given a name as NEW_SRV_NUM. The column is automatically
prefix with X_ and it is reflecting as X_ NEW_SRV_NUM
4) Mentioned the Physical type , length of the column and saved therecord, column status is Active .
5)I have hit the Apply button, an inputform pop up and asking for details.
6)I have entered below parameters.
a. Tables: Select current Row
b. Database User: SIEBEL
c. Database Password: This is the user password , when i extracted
the local DB.(also this is Tools login password ) .
d. ODBC Data Source: ODBC data source pointing to the local
database. This is SSD Local Db default instance
e. Hit Applied on the window. This would taken a while and message
is pop up as confirming changes to the database.
7) I have created one new field (New_SRV) in the Service Request BC ,mapped
X_NEW_SRV_NUM column to above created field.
8)After at Service Request List Applet mentioned the NEW_SRV field and
mapped at the Edit list mode and base mode
9) Complied the entire projects Service Request , ServiceRequest(SSV),Table
Service request and all locked projects
After Compilation Service request Screen it self is not opening and
showing error message as “Please consult administrator e.t.c”

1) I have done the Apply successfully ,that column is reflecting in Local
DB(verified in local DB by using sql tool) and finally I done 'Activate' .
2) Compiled the 'S_SRV_REQ' Table , at UI(Web client I didn't give any error
msg).

3)When I compiled the 'Service Request' BC, I got a error msg as

We detected an Error which may have occurred for one or more of the
following reasons:

1) Can you check if you have created a Column with name containing spaces ? X_ NEW_SRV_NUM (for example, a space between Underscore and N)

Not sure whether siebel will allow you to do this mistake or not. But if it allows, then this WILL create a problem in Internal Spools, which intern give you a SQL related error.

2) As per my understanding, Issue is not with Siebel Web Client or Dedicated Client. Issue is with Tools ? Please confirm.

Do the following.
Take the back up of your Service Request BC which is with changes.
Then try importing the server definitions newly by doing Checkout or SIF Import. Now you will have your fresh old SR BC. Start doing the changes related to the new field like specifying the column name , field type and all the stuff. Then try compiling this and check if it is allowing you to compile.

I recommend you this because, unknowingly you would have changed some of the definitions of SR BC as it is locked (which will allow you to change and save).

If I understand this correctly, you are creating the new column in your
local dbf (using tools) and applying the changes to your local dbf database.
Using the sql tool you were able to verify the new column was created in the
local dbf database.

On compiling S_SRV_REQ, and testing the application you get no error.

On compiling the Service Request BC, and testing the application you get an
error. On testing the application, do you log into your local database or to
the server. If it is to the server, you will get the error, as the column is
not applied to the server db, but if you're logging to your local db, then
it's still a mystery.

Were you able to generate a spool sql file and see what sql was causing the
error?

Seems to be some data shape issue .If you are still stuck with the issue,enable the SQL Tagging by setting the environment variable to "SIEBEL_LOG_EVENTS" to 5 and trace out the SQL causing the failure.

There is no space between Underscore and N in column name X_NEW_SRV_NUM ,I
have done the checkout for Service Request, Service Request SSV projects,
after created the extension column in S_SRV_REQ table and followed the
below steps ,

Hi Rajkumar Raju,
Thanks for the document ,but issue was neither at Applet level nor at BC
level, i was ADDED column in Webclient Local DBF file, which i was created
newly in S_SRV_REQ table,after creating the column in webclient DBF file
,successful compile it is reflecting on client UI and i am able to save
the value for that column.

Can you confirm me one thing ,is it mandatory to add a new column in Webclient
Local dbf file ??

In configuration file you have to set which data base you are pointing to .

normally we have to point tools, and client to same database. if you are
extended column in tools database, and trying to check in client data base.
How it will work. you have to point to exact database. set in configuration
file. ok good luck.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.