Unable to run a query after recent update

[tmykhaylovsky]

Hi Mark, thank you for the great plugin. I've been using it extensively.

I noticed that the following query produces an error:

select top 100 * 
from msdyn_componentlayer
where msdyn_solutioncomponentname = 'Role' 
and msdyn_componentid = '155A0C01-FD75-EA11-A811-000D3A33F11E'
and msdyn_solutionname = 'Active' 

Cannot convert object of type 'System.Data.SqlTypes.SqlGuid' to object of type 'System.Data.SqlTypes.SqlString'.Couldn't store <155a0c01-fd75-ea11-a811-000d3a33f11e> in msdyn_componentid Column.  Expected type is SqlString.
Cannot convert object of type 'System.Data.SqlTypes.SqlGuid' to object of type 'System.Data.SqlTypes.SqlString'.

Any idea how to resolve?

[MarkMpn]

Can you confirm the version of SQL 4 CDS you're running please?

[tmykhaylovsky]

@MarkMpn, 5.4.0.0 thank you

[MarkMpn]

Interesting, I think this is a bug in either the metadata for this entity or the underlying data provider. I've raised an issue for this at https://github.com/MicrosoftDocs/powerapps-docs/issues/2974

[tmykhaylovsky]

@MarkMpn , thank you for responding so quickly and opening the issue with Microsoft. Looking forward to their response.