Skip to content

[BUG] Sharing / Unsharing record (Insert into principalobjectaccess) - Operand type clash: int is incompatible with uniqueidentifier #674

Description

@PRusakPL

Describe the bug
Feature described here: https://markcarrington.dev/2024/06/10/sql-4-cds-v9-1-released/#sharing_&_unsharing_records seems to not work anymore (maybe regression bug ??)

Error message received:
Msg 206, Level 16, State 1, Line 1
Operand type clash: int is incompatible with uniqueidentifier

To Reproduce
Just try to share any record by inserting into POA table (see sql below)

INSERT INTO principalobjectaccess (objectid, objecttypecode, principalid, principaltypecode, accessrightsmask)
VALUES('ed4eac76-4ad3-ef11-8ee9-000d3a67e20f', 'account', 'c8f23980-b1d1-ef11-8ee9-000d3a67e20f', 'systemuser', 3)

Expected behavior
Sharing / Unsharing records work as in version 9.1

Screenshots

Image

Environment (please complete the following information):

  • SQL 4 CDS edition: XrmToolBox
  • Results of SELECT @@VERSION:

Microsoft Dataverse - 9.2.25042.222
SQL 4 CDS - 9.6.1.0
May 05 2025 07:25:54
Copyright © 2020 - 2025 Mark Carrington

Additional context
N/A

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions