Query API Run Adhoc is failing with 500 Internal Error

I have setup 12 flows using Query API, where 3 of them runs using a saved query in database view (due to cannot use adhoc for specific gift attributes). Other 9 is running using Adhoc querying.

Started with my 5PM EST run, all 9 that use Adhoc querying failed (it is now 7PM and I just tried again and is still failing).

I am using Blackbaud Add-ins Send HTTP Request:

• Method: POST
• Relative Path: /query/queries/execute
• Query Paramters: product=RE and module=None
• Request Body:

{
"query":
{
"select_fields": [
{
"query_field_id": 349,
"user_alias": "id"
},
{
"query_field_id": 3789,
"user_alias": "classification"
},
{
"query_field_id": 3788,
"user_alias": "status"
}
],
"filter_fields": [
{
"query_field_id": 3789,
"compare_type": "None",
"filter_values": [
0
],
"operator": "NotBlank",
"left_parenthesis": false,
"right_parenthesis": false
},
{
"query_field_id": 3788,
"compare_type": "Or",
"filter_values": [
0
],
"operator": "NotBlank",
"left_parenthesis": false,
"right_parenthesis": false
}
],
"sort_fields": [],
"gift_processing_options": {
"soft_credit_option": "Donor",
"matching_gift_credit_option": "MatchingGiftCompany",
"use_gross_amount_for_covenants": false
},
"advanced_processing_options": {
"use_alternate_sql_code_table_fields": false,
"use_alternate_sql_multiple_attributes": false
},
"type_id": 18,
"format": "Dynamic",
"suppress_duplicates": false,
"constituent_filters": {
"include_inactive": true,
"include_deceased": true,
"include_no_valid_addresses": true
}
},
"ux_mode": "Asynchronous",
"formatting_mode": "None"
}

• This is a query to get on all constituent non blank prospect classification and status
• Response Headers:

{

"Cache-Control": "no-store, must-revalidate, no-cache",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"Request-Context": "appId=cid-v1:0c37065f-4d7c-47cf-af06-96cd9a75949d,appId=cid-v1:12568f68-434a-4c0e-bfb8-885db4682268",

"X-Content-Type-Options": "nosniff",

"x-ms-function-status": "OK",

"Date": "Thu, 07 Mar 2024 00:32:51 GMT",

"Content-Length": "156",

"Content-Type": "application/problem+json"

}

• Response Body:

{

"type": "urn:blackbaud:unexpected",

"title": "An error has occurred.",

"status": 500,

"trace_id": "80b4598b55844d15b70d7582d93e376d",

"span_id": "930b446862c9dee4"

}

@Erik Leaver @Heather McLean is this something you can do to track down the issue?