Query values are not getting resolved into actual one

(0) Share

Report

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.

I have the same question (0)

All responses (2)

Answers (1)

Nya 29,060 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

EmployeeOcta 6 on at

Like (2)

Report

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.

Was this reply helpful? Yes No