https://community.esri.com/t5/arcgis-enterprise-portal-questions/relationship-queries-not-returning-results-after/m-p/1570948#M16041 <P>Hi everyone,</P><P>I’m encountering an issue with a published feature layer that includes a polygon layer and several related tables.</P><P>The relationships work perfectly in both PostgreSQL (the database) and ArcGIS Pro. I can see all related records without any problem. However, after publishing the layer as a feature service, the relationships appear in the table as expected, but clicking the link to view related records returns nothing.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_1-1734963649027.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122352i7E882CCA8176BA65/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_1-1734963649027.png" alt="arc_ticodex_1-1734963649027.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_2-1734963665597.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122353i7F540FCC1B8B23F8/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_2-1734963665597.png" alt="arc_ticodex_2-1734963665597.png" /></span></P><P>When checking the server logs, I found two errors:&nbsp;Error: Invalid query;&nbsp;Unable to perform query operation</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_0-1734963454869.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122351i628019D3FA990614/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_0-1734963454869.png" alt="arc_ticodex_0-1734963454869.png" /></span></P><P>I’ve tried various troubleshooting steps but haven’t been able to resolve this. Does anyone have an idea of what might be causing this or suggestions on how to fix it?</P><P>Any help is greatly appreciated!</P><P>Thanks in advance!</P><P>&nbsp;</P> Mon, 23 Dec 2024 14:26:28 GMT arc_ticodex 2024-12-23T14:26:28Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/relationship-queries-not-returning-results-after/m-p/1570948#M16041 <P>Hi everyone,</P><P>I’m encountering an issue with a published feature layer that includes a polygon layer and several related tables.</P><P>The relationships work perfectly in both PostgreSQL (the database) and ArcGIS Pro. I can see all related records without any problem. However, after publishing the layer as a feature service, the relationships appear in the table as expected, but clicking the link to view related records returns nothing.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_1-1734963649027.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122352i7E882CCA8176BA65/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_1-1734963649027.png" alt="arc_ticodex_1-1734963649027.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_2-1734963665597.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122353i7F540FCC1B8B23F8/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_2-1734963665597.png" alt="arc_ticodex_2-1734963665597.png" /></span></P><P>When checking the server logs, I found two errors:&nbsp;Error: Invalid query;&nbsp;Unable to perform query operation</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arc_ticodex_0-1734963454869.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/122351i628019D3FA990614/image-size/medium?v=v2&amp;px=400" role="button" title="arc_ticodex_0-1734963454869.png" alt="arc_ticodex_0-1734963454869.png" /></span></P><P>I’ve tried various troubleshooting steps but haven’t been able to resolve this. Does anyone have an idea of what might be causing this or suggestions on how to fix it?</P><P>Any help is greatly appreciated!</P><P>Thanks in advance!</P><P>&nbsp;</P> Mon, 23 Dec 2024 14:26:28 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/relationship-queries-not-returning-results-after/m-p/1570948#M16041 arc_ticodex 2024-12-23T14:26:28Z