SAP Knowledge Base Article - Preview

3210939 - OTC transformation template scripts exception - QUERY_HAS_TOO_MANY_STAGES


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.



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.