You are here

Server Tables Cleanup component failing - deadlock trying to delete records from s_srm_request

"In Siebel version 7.7, the SRProc component has a new parameter called Enable Various Housekeeping Tasks (Parameter alias = EnableHouseKeeping). This parameter is similar to the previous parameter in Siebel version 7.5.x and earlier called DeleteOldReqs. You should leave the default value of False for the EnableHouseKeeping parameter alias, otherwise both the SRProc and ServerTableCleanup components will try to clean up the same tables and cause potential deadlock type behaviors."

No problem if you disable the Server Tables Cleanup in all the servers and let only one running. This one will delete the S_SRM_REQUEST rows created in all Siebel Servers.