New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Setting ownerid/owneridtype with TDS endpoint not working #388

Closed

clintonbale opened this issue Nov 15, 2023 · 0 comments · Fixed by #383

clintonbale commented Nov 15, 2023

A query similar to the following does not work when using the TDS endpoint, works perfectly when that setting is not enabled:

UPDATE child
SET    child.ownerid     = parent.ownerid,
       child.owneridtype = parent.owneridtype
FROM   account AS child
JOIN   account AS parent ON child.parentaccountid = parent.accountid
WHERE  parent.ownerid <> child.ownerid;

with the error on the UPDATE:

Specified cast is not valid.
See the Execution Plan tab for details of where this error occurred

Deployment: Online
DB Version: 9.2.23105.202
Connection Controls Version: 1.2023.6.56
XrmToolBox Version: 1.2023.10.67
Tool Version: 7.6.1.0

The text was updated successfully, but these errors were encountered:

MarkMpn linked a pull request

that will close this issue

Merged

MarkMpn closed this as completed in #383

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment