3426815 - Error Query timeout when executing transformation run on SAP Signavio Process Intelligence

While running a transformation script in Process Intelligence it runs fine during preview, but ends in error when executed with transformation run with the following error:

• Error: Error executing query for pulling data: [There was a problem executing your SQL statement: Query timeout]

This error occurs when the AWS Athena memory limit is reached. For example, this can happen when transformation scripts with memory expensive operations are run on large data sets.

To solve this error, re-organize and optimize any resource-heavy query in transformation scripts. For example, you can optimize grouping, ordering, and joining operations as described in this AWS blogpost with performance tuning tips.

Query timeout, SQL, aws athena, athena, process intelligence, sap signavio, intelligence, query, timeout , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Known Error