SAP Knowledge Base Article - Preview

3210939 - OTC transformation template scripts exception - QUERY_HAS_TOO_MANY_STAGES

Symptom

Transformation scripts throw exception in preview as below. 

Something went wrong

QUERY_HAS_TOO_MANY_STAGES: Number of stages in the query exceeds the allowed maximum (1500). If the query contains multiple DISTINCTs, please set the 'user_mark_distinct' session property to false. If the query contains multiple CTEs that are referenced more than once, please create temporary table(s) for one or more of the CTEs.


Read more...

Keywords

QUERY_HAS_TOO_MANY_STAGES,Number,stages,query,exceeds,allowed,maximum,1500,multiple,DISTINCT,DISTINCTs,user_mark_distinct',session,property,CTEs,CTE,referenced,create,temporary,tables,table,script,running,out,resources,execution,preview,OTC , KBA , BPI-SIG-PI-DTT , Data Transformation Templates , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , BPI-SIG-PI-TRA , Transformation (Business Objects / Pipelines) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.