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.
Siebel - My Learnings
Tuesday, January 20, 2015
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
Subscribe to:
Posts (Atom)