Tuesday, January 20, 2015

Does DDLSYNC/ Apply Activate Drop Tables or Columns after they were deleted from the Siebel repository?

Does DDLSYNC/ Apply Activate Drop Tables or Columns after they were deleted from the Siebel repository?

DLSYNC / "Synchronize Schema Definitions" will NOT drop CX_ tables at DB level
(it will also not delete CX_ columns from DB tables when deleting them in the Siebel repository) 


Typically, you will only add tables, so this normally not an issue. Also this is expected / intended functionality:
just imagine what would happen if someone accidentally deleted a table or column in Siebel Tools and that would result in all your data in that table or column automatically being dropped being lost. 


To delete custom tables or columns, the developers would need to delete or inactivate them in the Siebel repository,
and the DBA would need to drop / remove them at physical DB level - please note that standard Siebel tables or columns (that cannot be removed from the Repository) also must not be dropped at DB level.

Thursday, January 8, 2015

WfProcMgr error Database connection was lost, please retry.(SBL-DAT-00175)"(SBL-EAI-04376)

Issue: Siebel Workflow process manager shows below error in the log files

Database connection was lost, please retry.(SBL-DAT-00175)"(SBL-EAI-04376)

This issue is related to IDLE_TIME parameter of user profile at the Oracle database.

Check the IDLE_TIME parameter
select profile from dba_users where username = 'SADMIN';
select profile, resource_name, limit from dba_profiles where resource_name ='IDLE_TIME'

Set IDLE Time to UNLIMITED on the Oracle database

ALTER PROFILE app_user2 LIMIT IDLE_TIME UNLIMITED;

Wednesday, January 7, 2015

Change File System parameter from *FSM* to actual server path Siebel 7.8



Change File System parameter from *FSM* to actual server path Siebel 7.8

Check current value of File System
Login to srvrmgr and use below command to display current value of file system parameter
> list advanced param DSFileSystem for named subsystem ServerDataSrc

Changing the parameter to actual server path
> change param dsfilesystem='\\\\\\WINDOWSSRVR111\\\sea78files\\\att' for named subsystem ServerDataSrc