Session time out issue for ACE users

[Former Member]

Hi

we upgraded to SAP CRM EHP3 upgrade and have been facing 500 connection timeout issue for ACE user. Ids which are not under ACE are working fine but others are giving timeout issues while searching a Trade Promotion or while creating a Trade Promotion.

Urgent help required

[Former Member]

Hi,

you most possibly have custom coding in ACE - if yes then please check its performance. Sometimes it is not written as best as should be. You may debug CRM_ACE_DISPATCHER job to see how it is handling with custom coding - how it performes.

please also try to recalculate ACE rights for all users.

BR
Radek

[former_member186644]

Hi Michael,

This performance issue maybe because the join of the main tables have the following big volume:

CRMD_ORDER_INDEX   

CRM_JEST 

CRMD_ORDERADM_H 

The SQL query is a dynamic query that is being generated in reporting framework based on the selection parameters passed from the application. Hence, further tuning of the SQL query is not possible.

Please create the secondary index on crmd_order_index table with the fields in the WHERE clause of the query.

1.) Update the stats on table CRMD_ORDER_INDEX

2.) Reorganise your indexes on table CRMD_ORDER_INDEX as per SAP Note 332677

Also consider archiving of the old data for improving the performance.

As additional information, The CRM Data Archiving is used to archive CRM business objects, such as activities or sales transactions that belong to a completed business process, or no longer needed master data, such as business partners or products.

This data is saved in archive files outside the database, but read-only access is still possible within the CRM system.

Once you have archived your data, you can delete it from the CRM database. For more information regarding data archive please refer to the below SAP online help link. http://help.sap.com/saphelp_crm70/helpdata/EN/4e/309e3a462f8a09e10000000a114084/content.htm

Regards, Gervase