Forum Discussion
Alias for Refinable Managed Property Not Working in Search Queries
Hi,
The alias for the refinable managed property has worked as expected in sortProperties for the past year, but it has recently stopped working and now returns an error. Using the original managed property name (RefinableDateSingle01) continues to work as expected.
The error is shown below, together with the trace ID. Unfortunately, we are unable to switch to using RefinableDateSingle01 in sortProperties as it does not meet our business requirements.
We are currently facing challenges due to the large number of SharePoint sites, many of which we do not have permission to access. As a result, we can only confirm that the refinable managed property RefinableDateSingle01 and its associated alias are configured correctly on the SharePoint sites where we have full access.
What is the root cause of this issue, and how can it be resolved?
https://graph.microsoft.com/v1.0/search/query
{
"requests": [
{
"entityTypes": [
"listItem"
],
"query": {
"queryString": "* AND SiteId:\"siteId\""
},
"from": 0,
"size": 50,
"sortProperties": [
{
"name": "RefinableDateSingle01", // This works when I use the refinable managed property name (RefinableDateSingle01), but it does not work when I use the alias I defined for this property
"isDescending": false
}
]
}
]
}
500 Internal Server Error (When I used alias in sortProperties)
{
"error": {
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "InternalServerError",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "FanoutDownstreamContradiction",
"message": "The call failed, please try again.",
"target": "",
"details": [
{
"code": "TwoStepFanout_FirstStepFailed",
"message": "The call failed, please try again.",
"target": "",
"serviceName": "Xap",
"moduleName": "SubstrateSearch.FanoutV2.MultiDimensionSearchFanoutPluginV3",
"contactTeam": "3sdri",
"httpCode": 500
},
{
"code": "FanoutDownstreamContradiction",
"message": "The call failed, please try again.",
"target": "",
"serviceName": "FanoutService",
"moduleName": "Fanout",
"contactTeam": "3STenantSearchDevs",
"httpCode": 500
}
],
"serviceName": "FanoutService",
"moduleName": "Fanout",
"contactTeam": "3STenantSearchDevs",
"httpCode": 500
}
],
"moduleName": "SubstrateFanoutSearchWorkflow",
"httpCode": 500
}
],
"moduleName": "AscUserSearchFanoutWorkflowV2",
"httpCode": 500
}
],
"moduleName": "AscUserSearchFanoutWorkflowV2",
"httpCode": 500
}
],
"moduleName": "G21AscWorkflow",
"httpCode": 500
}
],
"moduleName": "TenantFileSearchFederationWorkflow_ASC",
"httpCode": 500
}
],
"moduleName": "TenantFileSearchFederationWorkflow",
"httpCode": 500
}
],
"moduleName": "FederationWorkflow",
"httpCode": 500
}
],
"moduleName": "TopLevelWorkflowBase",
"httpCode": 500
},
"Instrumentation": {
"TraceId": "57c005b9-07fc-453b-8c73-2650d90670e0"
}
}