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;
Do we need to run this only for SADMIN or other user ids also?
ReplyDeleteAny Idea how we run this in SQL Server?
ReplyDeleteGet the Best WordPress product upload Services From Us With the drastic facelift that the retail sector has seen in the recent past, the internet gas become the hub for most of the small, medium as well as large scale businesses that are involved in the same.The ecommerce has seen a monumental growth prospective over the last couple of years and the trend is expected to remain the same for the foreseeable future as well. In this regard, what concerns the businesses and the online retail outlet is the data entry aspect. Tech data entry India provides a number of products and services to cater to the WordPress Bulk product upload Services.
ReplyDelete