Skip to Content

SAP ME ODS Script ODSProductionETL.ksh is extremely slow

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 25, 2017 at 10:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded