Customer experience | Sales, Customer Insights,...

SQL error when fetch entity 'childincidentcount'

(0) Share

Report

Posted on by Manh Hung Nguyen

Hi everyone,

I'm trying to fetch entity 'childincidentcount', and i'm getting this error:

Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207

My fetchxml is:

Can anyone help me with this one?

Thanks you!

I have the same question (0)

All responses (7)

Answers (0)

gdas 50,091 Moderator on at

Like (0)

Report

May I know how you are executing the fetchXML ?

Do you have entity named childincidentcount?

Was this reply helpful? Yes No
Manh Hung Nguyen 5 on at

Like (0)

Report

Hi Goutam,

Here is my code:

var executeFetchReq = new ExecuteFetchRequest { FetchXml = xml };

var orgSvcExecuteFetchResponse = (ExecuteFetchResponse)_service.Execute(executeFetchReq);

Yes I have this entity. I also got the metadata of this entity. But when I try to fetch data, it throw the error.

Note: this entity is not supported 'RetrieveMultiple'.

Thanks you.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Please put entity name with publisher name like "new_childentity"

Was this reply helpful? Yes No
Manh Hung Nguyen 5 on at

Like (0)

Report

Hi,

It's not new entity. It's currently existing. So I don't want to rename it.

And here is the detail of error:

System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207 (Fault Detail is equal to Exception details:

ErrorCode: 0x80044150

Message: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207

TimeStamp: 2020-02-11T08:10:33.9567199Z

--

Exception details:

ErrorCode: 0x80044150

Message: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207

TimeStamp: 2020-02-11T08:10:33.9567199Z

--

Exception details:

ErrorCode: 0x80040216

Message: Exception output:: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Name'.

Invalid column name 'ImportSequenceNumber'.

Invalid column name 'OverriddenCreatedOn'.

Invalid column name 'ChildIncidentCountId'.

Invalid column name 'TimeZoneRuleVersionNumber'.

Invalid column name 'UTCConversionTimeZoneCode'.

Invalid column name 'ChildIncidentCountId'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(T...).

Please note that I use '<all-attributes />' in fetchxml. So I don't know why it throw the error.

Thanks you

Was this reply helpful? Yes No
Manh Hung Nguyen 5 on at

Like (0)

Report

Hi everyone,

Is there anyone help me please? Or any suggestions.

Thanks you all.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

I am not saying to rename the entity ,I believe the entity you mentioned in the fetchXML , you should use the publisher name instead of only "childincidentcount" , check in the entity information page what is the entity publisher name and put the entity name accordingly. Look here entity name which you need to use as an exampel , I have used "tel_" as publisher name.

Was this reply helpful? Yes No
Manh Hung Nguyen 5 on at

Like (0)

Report

Hi Goutam,

I sure i'm using the publisher name of entity 'childincidentcount', because I still able to get metadata of this entity. But I can't get data of this entity. I also find this entity in the entity information page like you, and I didn't find it. It seem to be invisible.

Thanks!

Was this reply helpful? Yes No