Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Query values are not g...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Query values are not getting resolved into actual one

(0) ShareShare
ReportReport
Posted on by EmployeeOcta

Hello All Experts,

I am trying to login to CRM but there is coming a SQL Generic Error.

I have collected the trace and there is one query that is getting generated but i am not sure which values needs to inside the query in place of C# generic class.

Below is little small chunk query after WHERE clause.

"userquery0".UserQueryId in (select POA.ObjectId from PrincipalObjectAccess POA
where POA.PrincipalId in ('000000-1344-eb11-8127-000000000',(SELECT id from System.Collections.Generic.List`1[Microsoft.SqlServer.Server.SqlDataRecord])) 

But  i am not sure how this highlighted part will have actual values . from where can we get these values.   

any help will be really appreciable.

  • Verified answer
    EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: Query values are not getting resolved into actual one

    Hello All Experts,

    I am able to generate the actual values by using sql server profiler.

    also the issue which i was facing is that due to some reason there were some access teams which were added to user. and it was giving a sql generic error.

    I have removed the access teams records associated with the user and now the issue is resolved.

    Hope this will be helpfull for other people as well.

  • Nya Profile Picture
    Nya 29,056 on at
    RE: Query values are not getting resolved into actual one

    Hi,

    Is there any Error Description/ Error Detail/ Error Number about it?

    It would be appreciated if you could provide more details such as the above ones, the log or the screenshot.

     

    Best Regards,

    Nya

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans