SAP Knowledge Base Article - Public

3216219 - "Query exhausted resources at this scale factor" when running ETL or Preview of query

Symptom

  • When running Preview of query in SAP Signavio Process Intelligence, the error message "Query exhausted resources at this scale factor" appears



  • Or when running ETL, the error message "Query exhausted resources at this scale factor" appears. 

Environment

  • SAP Signavio Process Intelligence

Reproducing the Issue

  • In SAP Signavio Process Intelligence -> Manage Data -> Integrations -> Open the relevant Integrations -> Extract/Or Select the relevant tables and Preview 

Cause

  • The query defined hits the AWS Athena limits. 

Resolution

  • If the user is using a standard template (without any modification), then the template needs to be revisited and see if the joined tables can be rearranged in a different way by the Signavio Engineering team.

  • If the user has modified the template, it is needed to check if all the joins are correct and potentially rearrange the joins as recommended in the following chapters in the AWS Blog:

    -----
    6. Optimize ORDER BY
    7. Optimize joins
    8. Optimize GROUP BY
    -----

See Also

Top 10 Performance Tuning Tips for Amazon Athena

Keywords

English; SPI; SAP Signavio Process Intelligence; Query exhausted resources at this scale factor;  , KBA , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , Problem

Product

SAP Signavio Process Intelligence 3.0