Siebel table apply doesn't affect the database

Question

In Siebel Tools, I added a new column to a table. After applying and compiling the changes, the UI App shows a SQL error (SBL-DBC-00105), and when running a simple Select query directly to the database I found that the new column isn't added to the table.

Error message    
    
We detected an error that may have occurred for one of the following reasons:
 
An error occurred while executing an SQL statement. Please continue 
or ask the system administrator to check the application configuration 
if the problem persists. (SBL-DBC-00105)

I double checked the ODBC data source and DB credentials, all good.

Any ideas about this issue?

Answer 1

You need to Apply/DDL your new changes.

Assuming you are using Siebel Tools IP15. Login to server tools and search for your newly updated table in Tools.

Click on Apply/DDL button

Then choose option "Apply":

Answer 2

Are you applying your DB changes to the same database which hosts your development reposoitory? In case you are applying to some other environment (e.g. from Development Tools to Test database) apply would not work as Siebel Tools are comparing physical schema with logical schema and would find no differeneces if your repository has no new column definition.

That means you have to migrate your changes from DEV repository to TEST before applying table changes. Or use DDL generation instead of applying.