Skip to Content
0

SAP ME ODS Script ODSProductionETL.ksh is extremely slow

Dec 02, 2016 at 08:34 AM

34

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sergiy Katerinich
Jan 25, 2017 at 10:39 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded