Power Platform Community Forum Thread Details

Filter error CRM ErrorCode -2147204784 sql errorcode -2146323060 sql number 511

Hi,

Sometimes the same Collection building based on a filter on a dataverse table fails for some users. If I inspect in monitor I get

                                                         Filter(
                                                                DierEvent
                                                                ,EventtypeId <> 97 And CalcDueTime< DateAdd(Today(),BrowseTeller+1) 
                                                                    And ( 
                                                                        (IsBlank(PlanTarget))
                                                                        Or (PlanTarget = vDefaultTaskTarget)
                                                                        Or (PlanTarget = vUserEmail)
                                                                        )
                                                                    )

CRM ErrorCode -2147204784 sql errorcode -2146323060 sql number 511

If in the same session I filter the same table with other criteria that yield less results (3) than this filter (39 results) it succeeds. I can also repeat this

The table has many columns including many lookup columns.

What could be wrong?

Categories:

General Questions

Connecting to Data

Quick Links

Leaderboard