Siebel S_SRM_TASK_HIST Table

In Siebel CRM S_SRM_TASK_HIST plays a very important role in debugging of tasks. This table can be used for checking task history in Siebel CRM which is really important in times of any failure. Sometimes this can be first point where troubleshooting can be start. Server Task Persistence(SrvrTaskPersist) a background, non-multithreaded component (Part of SystemAux component group)fill this table data for all the tasks created by the Siebel Server in case of diagnostic purposes. Deactivating this component will stop filling data in this table. Apart from this by default, Siebel components have the EnableEventHistory parameter set to True, it means that tasks history information will be written to S_SRM_TASK_HIST table.

If you know the server task id for which you want to debug or troubleshoot, Query can be fired like this in database.

select CREATED, SRVR_PROC_ID_VAL, SRVR_LOGFILE_NAME, SRVR_STATUS from SIEBEL.S_SRM_TASK_HIST where SRVR_TASK_ID_VAL=’xxxxxxx’;

One more example can be finding list of Active users in Siebel

select SRVR_START_TS,SRVR_END_TS,SRVR_COMP_NAME,SRVR_USER_NAME from siebel.S_SRM_TASK_HIST where SRVR_COMP_NAME IN (‘PSCcObjMgrCustom_enu’)

So because of these all component task level debugging this table may grow rapidly sometime. SvrTblCleanUp component can be of use in these cases. It can purge the data periodically for this table. To make this happen you need to set a parameter ‘DeleteEventHistoryInterval’ in the SvrTaskPersist component. It controls the duration of tasks info kept in this table. You can provide the value as per the business requirement.

Happy Learning !