Error: Query too complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] the multi-part identifier

When running a constituent query, you receive the following error:
"Query too complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] the multi-part identifier "GIFT_GIFTSPLIT.AMOUNT" could not be found. Native error: 4104"

This often occurs when using Fund ID or Appeal ID and select "One of" as the operator.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 7.81.1334.0 ; 7.81.1334.20
 7.91.5056, patch 28 ; 7.82.1514

Was this article helpful?