Describe the bug
Inserting a record into listmember is failing with the error message

Duplicate entries will be silently ignored for listmember inserts
Msg 10337, Level 16, State 1, Line 1
Specified cast is not valid.

See the Execution Plan tab for details of where this error occurred

To Reproduce
Query to reproduce the behavior:

INSERT INTO listmember (listid, entityid) VALUES ('5FE12D4B-090F-F011-998A-7C1E52041CBD', '0C122E6B-AB15-EE11-9CBE-002248C8ED33')

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

Environment (please complete the following information):

• XrmToolBox
• Microsoft Dataverse - 9.2.25032.196
  SQL 4 CDS - 9.6.0.0
  Feb 25 2025 10:31:11
  Copyright © 2020 - 2024 Mark Carrington