It was suggested to set the DSSQLStyle profile parameter as mentioned in the Bookshelf and restart the Siebel server. NOTE:535105.1 - External Business Component - Database connection was lost, please retry.(SBL-DAT-00175) Siebel Workflow - Version: 7.7.2 SIA z*OBSOLETE: Microsoft Windows 2000 Product Release: V7 (Enterprise) Version: 7.7.2  Fin Svcs Database: Microsoft SQL Server 2000 SP3 Application Server OS: Microsoft Windows 2000 Server Database Server OS: Microsoft Windows 2000 Server This document was previously published as Siebel SR 38-1712881391.SBL-DAT-00292, SBL-DAT-00498, SBL-BPR-00100, SBL-BPR-00187We have the following business scenario and are finding it difficult to find a technical solution. We have a Case entity (based on HLS Case) exposed through a partner portal.When a workflow executed the step to write in this EBC it exited with the error below:- - -SBL-EXL-00151: Error sending Trouble Ticket to TTM.
We could either add some skill to the team leader and use dynamic assignment or use static assignment.
If we were to use static assignment, every time the team leader would change, we would also need to update Employee Candidates.
Obj Mgr Bus Comp Log Error 1 0000122b4bed0ea0:0 2010-05-20 ((10497)) SBL-DAT-00175: Database connection was lost, please retry.…Obj Mgr Sql Log Detail 4 0000122b4bed0ea0:0 2010-05-20 Incorrect SQLSTYLE 0 SQLOBJECT NOT cached.…- - -This revealed that the DSSQLStyle profile parameter was not (or at least not correctly) set for the Data Source of the custom EBC.
Note that DSSQLStyle is one of the profile parameters to be set when configuring the data source definition for an EBC.
This parameter and the supported SQL Styles are discussed in the Bookshelf: Integration Platform Technologies: Siebel Enterprise Application Integration External Business Components Process of Configuring External Business Components Specifying Run-Time Parameters For example, "Oracle" and "Oracle CBO" are the SQL Type used for Oracle databases.
"Oracle CBO" is for Oracle databases with cost based optimization, namely for Oracle database version 9i (or later).
Information in this document applies to any platform.
The customer had a problem with a custom External Business Component.
We have not implemented Assignment Manager for the current release and are will probably not be able to, due to time constraints.2.