Connected to the local database with the user id and password for the local user; while applying with the correct ODBC connection and the process initiates for a minute, and then Siebel tools automatically closes; In another machine, the process initiates and the application hangs forever, tried giving many other options w.r.t different user id's and passwords but did not work. Also tried out with SIEBEL/Local user Password, DBA/Enterprise Server Name and all in vain. The application just hangs without throwing any error message.

Solution:

It was found that during an "Apply" a Siebel DUMMY table is created within the Oracle db then dropped after the Apply completes.

It seems that due to a previous 'Apply' not completing successfully this DUMMY table still existed.

Therefore the error received when attempting to apply the new table.

The exact table name = SIEBEL.D_U_M_M_Y

To resolve this the DUMMY table was dropped using database utilities

NOTE:This Tip appliesto Siebel Tools - Version: 8.0.0.3 SIA [20416] and later [Release: V7 and later] and it is recommended solution by Siebel