Siebel Error: "SBL-DBC-00105: An error has occurred executing a Sql statement"

This error occurs mostly in 2 scenarios:

1. When a user navigates to a View and executes a query in an Applet.
2. When a Business components has 2 fields mapped to the same column.

This error is generated when an SQL SELECT statement fails to execute against the database.

In Order to troubleshoot this error, we need to capture the SQL which can be done in below ways:

• spool the sql using the /s option, if the error is reproducible in the mobile client or dedicated client.This spools all the SQL's generated into a log file by the application and allows to identify the problematic SQL.
• If the error is reproducible only in the thin client, then we need to raise the log level for the Application Object Manager component and identify the sql from the resultant logs.

The error can be encountered due to various reasons. Below are some of them:

1. Logical and Physical schema are not in sync.
2. A field without mapping to a column.
3. A field with a calculated value without the calculated value set to True.
4. A field on link is defined as a calculated field
5. A join specification field based on a calculated field.
6. Incorrect permissions are set on the table at the database level.
7. A join in the select statement is specified more than once.
8. There is a difference in the field type and length at the business component field definition versus the table column definition.