SAP ME ODS Script ODSProductionETL.ksh is extremely slow

[former_member323997]

Hello,

Recently we got the problem that the ODSProductionETL.ksh is extremly slow, after some basic analysis, I found the bottleneck is on the ODS_ORDER_CYCLE_TIME sumamry step.

Could you please advice:

1. why the logics behind of this summary?

2. and what could be causing the slowness?

3. And furthermore, how to skip this step in the ODSProductionETL script? actually we are not using this table data to generate any reports.

Thanks & reagrds,

Leon

[sergiy_katerinich]

Hi,

Formally, this is a matter for submitting a support ticket to fix the performance issue.

1. It calculates some statistics on Order Cycle.

2. Looks like some query is not optimal on your volumes of data.

3. Yo can try unselect all rows in Time Granularity Assignment Maintenance for Summary category = "Production Cycle Time". Or you can comment the respective lines in the script - it is about the line with "com.sap.me.ods.ODSProductionLogSummary 3" and

"com.sap.me.ods.ODSProductionLogSummary 4" inside.

Regards,

Sergiy