Saturday, February 27, 2010

Table Apply Activate issue in Siebel Tool

Table Apply Activation Issue in Siebel Tool :

Some time when we do Table Apply Activate, Siebel tool hangs and required restart.
Few times, It hangs each and every time.

So you can use following approach to avoid it.

1. Do spool and check which column(Column_Name) is not present in underline database.

2. Find out table(Table_Name).

3. Simply run following sql statement with DBO privilege.
Alter Table Siebel.Table_Name
Add Column_Name DATA_TYPE

Data_Type could be Varchar, Date etc. Take data_type as per requirement.
It works fine.
As per my understanding above is good approach to avoid siebel hang on Table Apply.

Your feed back would be appreciable.

2 comments:

  1. Just came across this. Will this also take care of Foreign Keys, Multivalued Columns, and other such stuff ?

    Regards

    ReplyDelete
  2. Yes As per my understanding, it will take care all...!!!Only index will not be taken care locally and Index don't have much impact locally

    ReplyDelete