Cannot edit field length

(0) Share

Report

Posted on by Community Member

Dear community,

I ran into a strange issue as I changed the field length of a specific single linge text field for a custom entity. For another field with the same type on the same entity, editing is possible. However, I took a trace and I got following error message:

MSCRM Error Report:
--------------------------------------------------------------------------------------------------------
Error: DROP FULLTEXT INDEX statement cannot be used inside a user transaction.
Error Number: 0x80044150
Error Message: Generic SQL error.
Error Details: Generic SQL error.
Source File: Not available
Line Number: Not available
Request URL: xxxxx/.../SystemCustomization.asmx
Stack Trace Info: [SqlException: DROP FULLTEXT INDEX statement cannot be used inside a user transaction.]
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropIndexOrConstraintInSqlIfExistsInternal(DropIndexData dropData, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropIndexesFromSQLByIndexIds(List`1 indexIds, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropIndexesInvolvingAttribute(Guid attributeId, Boolean dropAndTrackCustomIndexes, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.AttributeUpdateAction.PreprocessAttributeForSQLChangesIfNecessary(MetadataBusinessEntity updateData)
   at Microsoft.Crm.Metadata.AttributeUpdateAction.UpdateAttributeTable()
   at Microsoft.Crm.Metadata.AttributeUpdateAction.MetabaseOperation()
   at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_metabaseActionsToExecute(CounterList listCounters)
   at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
   at Microsoft.Crm.Metadata.AttributeService.Update(Guid attributeId, AttributeInfo attributeInfo, Boolean mergeLabels, MetadataHelper metadataHelper, ExecutionContext context)
   at Microsoft.Crm.Metadata.AttributeService.Update(Guid attributeId, AttributeInfo attributeInfo, Boolean mergeLabels, ExecutionContext context)
   at Microsoft.Crm.Metadata.AttributeService.Update(Guid attributeId, AttributeInfo attributeInfo, Boolean mergeLabels, Guid solutionId)
   at Microsoft.Crm.Application.WebServices.SystemCustomization.AttributeUpdate.Execute(Guid solutionId, ParameterBag paramBag)
   at Microsoft.Crm.Application.WebServices.SystemCustomization.SystemCustomization.UpdateAttribute(XmlNode data)

Regards,

Karan

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

PS 23,577 on at

Like (0)

Report

RE: Cannot edit field length

I guess you are trying to modify length of a primary key field, which is not allowed and that's why you receive this error.

You can check it by going to settings >>customisation >> customise the system >>entity>> scroll down to custom entity >> fields>> check field type column

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot edit field length

Hi Prashant,

no it's a normal text field (single line of text). The current value is set to 300. I have to set it to 321, but it doesn't work.

When I set a value less than 300, it works well.

When I download the Logfile I got following, but it doesn't help me:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #7B887E57Detail:

<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">

<ErrorCode>-2147220970</ErrorCode>

<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />

<Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #7B887E57</Message>

<Timestamp>2017-02-02T13:46:02.2493171Z</Timestamp>

<InnerFault i:nil="true" />

<TraceText i:nil="true" />

</OrganizationServiceFault>

Was this reply helpful? Yes No
PS 23,577 on at

Like (0)

Report

RE: Cannot edit field length

Can you share the screenshot of the field details form

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot edit field length

sure:

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

RE: Cannot edit field length

Can you check in the entity, whats the primary key if this is not,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot edit field length

That's the primary key:

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

RE: Cannot edit field length

I would suggest you to raise a ticket to Microsoft

Was this reply helpful? Yes No
Verified answer

Pawel Grudzien 20 on at

Like (1)

Report

RE: Cannot edit field length

This error usually happens when the field you are trying to edit is added as a "Find Column" in the Quick Find View of the entity (arunpotti.wordpress.com/.../how-to-configure-and-search-using-quick-find-view-in-ms-crm) and you have full-text search enabled (blogs.msdn.microsoft.com/.../dynamics-crm-2015-update-0-1-full-text-search-quick-find-performance-feature).

We were able to find a workaround by either removing the column from find columns or disabling full-text search and then waiting a day so that the changes are commited - this will not happen instantly as there is a periodic job that handles index changes. After the changes are made you can edit the field's length and add the field back to find columns and enable full-text search. You can read more about maintenance jobs here: blogs.msdn.microsoft.com/.../crm-2013-maintenance-jobs (the article was written for CRM 2013 but it also applies to CRM 2015).

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Cannot edit field length

Hi Pawel,

yes you're right, I've already disabled FTS on my envireonment, I'am waiting...

Here is a great link:

community.dynamics.com/.../critical-bug-with-full-text-search

Regards,

Karan

Was this reply helpful? Yes No