This is a new one…
I’m trying to use the REST API to update an External BAQ Datasource, using the Ice.BO.BAQExtDatasourceSvc\MsSqlKeyProperties endpoint.
When I make a call to that endpoint I get a 500 error and the Epicor app server logs show this error message:
Ice.Common.EpicorServerException: The hierarchy of relations between ‘BAQExtDatasource’ main table and ‘MsSqlKeyProperties’ table is not found
I’ll probably take it to Epicor Support but wondered if anyone has ever seen this before, and if there is anything I can do about it.
Thanks!
PS - If you have a suggestion on how to update the database server for a SQL Server External BAQ Datasource, other than the REST API, let me know. The connection string is encrypted in the database entry and the individual properties are not exposed.
I am trying to include this step as part of our ‘Copy Production to Test/Dev’ script. Our external BAQs also need to reference the appropriate database server.