Error: Status: Did not finish Status Message: The query processor ran out of stack space during query optimization. Please simplify the query. BBERR_ORIGINAL_ERROR:8621. BBERR_ORIGINAL_PROCEDURE: BBERR_ORIGINAL_LINE_NUMBER:1

When refreshing a marketing segment the process fails with Error: 
Status:  Did not finish 
Status Message:  The query processor ran out of stack space during query optimization.  Please simplify the query.  BBERR_ORIGINAL_ERROR:8621.  BBERR_ORIGINAL_PROCEDURE:  BBERR_ORIGINAL_LINE_NUMBER:1

This can occur if a segment has a lot of selections, which SQL Server's query optimizer cannot handle properly. To resolve, reduce the number of selections in the affected segment.

Environment

 2.5.465, patch 62

Was this article helpful?