Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Field Service forum / Unable to update Booka...
Field Service forum

Unable to update Bookable Resource Booking from Scheduled to Cancelled

(0) ShareShare
ReportReport
Posted on by RayDL 5

I am trying to update an existing Bookable Resource Booking from Scheduled to Cancelled.  When I attempt to update the record I am getting the error output below. It is saying an SQL error: A string value provided is too long. The issue is, I don't know which field is causing this. I have looked at all fields on the related Work Order and the Booking itself, none of them has long string value.
Any assistance would greatly appreciated.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Unhandled exception:
Exception type: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]
Message: Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>7b426e5f-d080-436c-bfbe-575d81fb34b8</ActivityId>
<ErrorCode>-2147220891</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic">
<KeyValuePairOfstringanyType>
<d2p1:key>ApiExceptionSourceKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">Plugin/Microsoft.Crm.ObjectModel.CustomBusinessEntityService</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiOriginalExceptionKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">Microsoft.Crm.CrmException: Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152 ---&gt; Microsoft.Crm.CrmException: Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152 ---&gt; System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
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&amp; dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.CrmDbConnection.LockConnectionAndExecuteMethod[TResult](IDbConnection connection, Func`1 executeMethod)
at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command, ICrmTransaction crmTransaction)
at Microsoft.Crm.CrmDbConnection.&lt;&gt;c__DisplayClass122_0.&lt;InternalExecuteNonQuery&gt;b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
at Microsoft.Crm.Platform.Server.DataEngine.SqlDataAccessManager.ExecuteNonQuery(IDbCommand command, ISqlExecutionContext context, Int32 sourceLineNumber, String memberName, String sourceFilePath)
at Microsoft.Crm.Platform.Server.DataEngine.EntityCrudManager.Update(IBusinessEntity entity, FilterExpression filter, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoUpdate(IBusinessEntity entity, FilterExpression filter, ExecutionContext context)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
at Microsoft.Crm.Extensibility.PipelineInstrumentationHelper.Execute(Boolean instrumentationEnabled, String stopwatchName, ExecuteWithInstrumentation action, PipelineExecutionContext context)
at Microsoft.Crm.Extensibility.Pipeline.&lt;&gt;c__DisplayClass2_1.&lt;Execute&gt;b__0()</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiStepKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">d100f787-f9d9-e711-a829-000d3ae0e7a4</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiDepthKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">1</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiActivityIdKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">7b426e5f-d080-436c-bfbe-575d81fb34b8</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiPluginSolutionNameKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">System</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiStepSolutionNameKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">System</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>OperationStatus</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">0</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>SubErrorCode</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">-2146233088</d2p1:value>
</KeyValuePairOfstringanyType>
</ErrorDetails>
<Message> Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152</Message>
<Timestamp>2019-05-28T05:44:31.8017737Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText>

[Microsoft.Dynamics.FieldService: Microsoft.Dynamics.FieldService.FieldServicePlugin]
[3fd0045a-55f6-499b-a389-729f3f697525: Field Service: Update (post-operation) for bookableresourcebooking]
Starting sync workflow 'Return value for the booking status', Id: f5ce41b6-45eb-e811-a862-000d3ad117e3
Entering ConditionStep1_step:
Entering SetAttributeValueStep2_step:
Entering ConditionBranchStep3_step:
Sync workflow 'Return value for the booking status' completed successfully
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginContext Start
FpsPlugin: MessageName: Update
FpsPlugin: PrimaryEntityName: bookableresourcebooking
FpsPlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FpsPlugin: SecondaryEntityName: none
FpsPlugin: Stage: 20
FpsPlugin: PreEntityImages.Count: 1
FpsPlugin: PostEntityImages.Count: 0
FpsPlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
ConcurrencyBehavior = Default
FpsPlugin: OutputParameters:
FpsPlugin: SharedVariables:
FpsPlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: IsolationMode: 1
FpsPlugin: Mode: 0
FpsPlugin: OrganizationName: orga66a1bdf
FpsPlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FpsPlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FpsPlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FpsPlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: IsInTransaction: True
FpsPlugin: Depth: 1
FpsPlugin: IsExecutingOffline: False
FpsPlugin: Parent PluginContext Start
FpsPlugin: PluginContext Start
FpsPlugin: MessageName: Update
FpsPlugin: PrimaryEntityName: bookableresourcebooking
FpsPlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FpsPlugin: SecondaryEntityName: none
FpsPlugin: Stage: 30
FpsPlugin: PreEntityImages.Count: 0
FpsPlugin: PostEntityImages.Count: 0
FpsPlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
SuppressDuplicateDetection = False
ConcurrencyBehavior = Default
FpsPlugin: OutputParameters:
FpsPlugin: SharedVariables:
FpsPlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: IsolationMode: 1
FpsPlugin: Mode: 0
FpsPlugin: OrganizationName: orga66a1bdf
FpsPlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FpsPlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FpsPlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FpsPlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: IsInTransaction: True
FpsPlugin: Depth: 1
FpsPlugin: IsExecutingOffline: False
FpsPlugin: PluginContext End
FpsPlugin: Parent PluginContext End
FpsPlugin: PluginContext End
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: InitializePlugin: local
FpsPlugin: ConfigurePluginFlagsSupportInternal()
FpsPlugin: CreateEntityOperation(bookableresourcebooking)
FpsPlugin: Operation type: BookableResourceBookingOperation
FpsPlugin: operation.Initialize()
FpsPlugin: InputEntity:
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedon = 5/28/2019 5:44:31 AM
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
modifiedonbehalfby =
vel_workcomplete = False
FpsPlugin: PreEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = b57973f1-be81-4660-bbfe-b6b1685785b3_systemuser[SYSTEM]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/6/2019 2:41:34 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = f16d80d1-fd07-4237-8b69-187a11eb75f9_bookingstatus[Scheduled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
msdyn_traveltimerescheduling = False
FpsPlugin: operation.Execute()
FpsPlugin: PluginStage: 20 MessageName: Update
FpsPlugin: Before calling message handler
FpsPlugin: Before
FpsPlugin: BeforeUpdate
FpsPlugin: BeforeCreateOrUpdate
FpsPlugin: BookingSetupMetadata: Cache miss for 4 BookingSetupMetadataDB records
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: CrmMetadataCache [23220392|138]: GET: Result True
FpsPlugin: After calling message handler
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: PluginContext Start
FieldServicePlugin: MessageName: Update
FieldServicePlugin: PrimaryEntityName: bookableresourcebooking
FieldServicePlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FieldServicePlugin: SecondaryEntityName: none
FieldServicePlugin: Stage: 20
FieldServicePlugin: PreEntityImages.Count: 1
FieldServicePlugin: PostEntityImages.Count: 0
FieldServicePlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
ConcurrencyBehavior = Default
FieldServicePlugin: OutputParameters:
FieldServicePlugin: SharedVariables:
FieldServicePlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: IsolationMode: 1
FieldServicePlugin: Mode: 0
FieldServicePlugin: OrganizationName: orga66a1bdf
FieldServicePlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FieldServicePlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FieldServicePlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FieldServicePlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: IsInTransaction: True
FieldServicePlugin: Depth: 1
FieldServicePlugin: IsExecutingOffline: False
FieldServicePlugin: Parent PluginContext Start
FieldServicePlugin: PluginContext Start
FieldServicePlugin: MessageName: Update
FieldServicePlugin: PrimaryEntityName: bookableresourcebooking
FieldServicePlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FieldServicePlugin: SecondaryEntityName: none
FieldServicePlugin: Stage: 30
FieldServicePlugin: PreEntityImages.Count: 0
FieldServicePlugin: PostEntityImages.Count: 0
FieldServicePlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
SuppressDuplicateDetection = False
ConcurrencyBehavior = Default
FieldServicePlugin: OutputParameters:
FieldServicePlugin: SharedVariables:
FieldServicePlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: IsolationMode: 1
FieldServicePlugin: Mode: 0
FieldServicePlugin: OrganizationName: orga66a1bdf
FieldServicePlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FieldServicePlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FieldServicePlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FieldServicePlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: IsInTransaction: True
FieldServicePlugin: Depth: 1
FieldServicePlugin: IsExecutingOffline: False
FieldServicePlugin: PluginContext End
FieldServicePlugin: Parent PluginContext End
FieldServicePlugin: PluginContext End
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: InitializePlugin: local
FieldServicePlugin: ConfigurePluginFlagsSupportInternal()
FieldServicePlugin: CreateEntityOperation(bookableresourcebooking)
FieldServicePlugin: Operation type: BookableResourceBookingOperation
FieldServicePlugin: operation.Initialize()
FieldServicePlugin: InputEntity:
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedon = 5/28/2019 5:44:31 AM
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
modifiedonbehalfby =
vel_workcomplete = False
FieldServicePlugin: PreEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = b57973f1-be81-4660-bbfe-b6b1685785b3_systemuser[SYSTEM]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/6/2019 2:41:34 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = f16d80d1-fd07-4237-8b69-187a11eb75f9_bookingstatus[Scheduled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
msdyn_traveltimerescheduling = False
FieldServicePlugin: operation.Execute()
FieldServicePlugin: PluginStage: 20 MessageName: Update
FieldServicePlugin: Before calling message handler
FieldServicePlugin: Before
FieldServicePlugin: BeforeUpdate
FieldServicePlugin: BeforeCreateOrUpdate
FieldServicePlugin: Begin:RetrieveResxWebResourceByName, webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationResoursesList.xml
FieldServicePlugin: Webresources Returned from server. Count=1
FieldServicePlugin: End:RetrieveResxWebResourceByName , webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationResoursesList.xml
FieldServicePlugin: Begin:RetrieveResxWebResourceByName, webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationResoursesList.xml
FieldServicePlugin: Webresources Returned from server. Count=1
FieldServicePlugin: End:RetrieveResxWebResourceByName , webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationResoursesList.xml
FieldServicePlugin: Begin:RetrieveResxWebResourceByName, webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationXml/localizedString.resx
FieldServicePlugin: Webresources Returned from server. Count=1
FieldServicePlugin: End:RetrieveResxWebResourceByName , webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationXml/localizedString.resx
FieldServicePlugin: Begin:RetrieveResxWebResourceByName, webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationXml/localizedString.resx
FieldServicePlugin: Webresources Returned from server. Count=1
FieldServicePlugin: End:RetrieveResxWebResourceByName , webresourceSchemaName=msdyn_/LocalizationLibrary/LocalizationXml/localizedString.resx
FieldServicePlugin: After calling message handler
FieldServicePlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin: PluginLocal.Dispose, Depth: 1
Starting sync workflow 'Validate booking service task completion', Id: 5dee9a33-2231-e911-a86a-000d3ad11148
Entering ConditionStep7_step:
Entering ConditionStep1_step:
Sync workflow 'Validate booking service task completion' completed successfully
Starting sync workflow 'Copy to billable time', Id: 4f992840-954c-e911-a87a-000d3ad11bfb
Entering ConditionStep7_step: Booking in progress
Entering ConditionStep4_step: Booking complete
Sync workflow 'Copy to billable time' completed successfully
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginContext Start
FpsPlugin: MessageName: Update
FpsPlugin: PrimaryEntityName: bookableresourcebooking
FpsPlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FpsPlugin: SecondaryEntityName: none
FpsPlugin: Stage: 40
FpsPlugin: PreEntityImages.Count: 1
FpsPlugin: PostEntityImages.Count: 1
FpsPlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
ConcurrencyBehavior = Default
FpsPlugin: OutputParameters:
FpsPlugin: SharedVariables:
FpsPlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: IsolationMode: 1
FpsPlugin: Mode: 0
FpsPlugin: OrganizationName: orga66a1bdf
FpsPlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FpsPlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FpsPlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FpsPlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: IsInTransaction: True
FpsPlugin: Depth: 1
FpsPlugin: IsExecutingOffline: False
FpsPlugin: Parent PluginContext Start
FpsPlugin: PluginContext Start
FpsPlugin: MessageName: Update
FpsPlugin: PrimaryEntityName: bookableresourcebooking
FpsPlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FpsPlugin: SecondaryEntityName: none
FpsPlugin: Stage: 30
FpsPlugin: PreEntityImages.Count: 0
FpsPlugin: PostEntityImages.Count: 0
FpsPlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
SuppressDuplicateDetection = False
ConcurrencyBehavior = Default
FpsPlugin: OutputParameters:
FpsPlugin: SharedVariables:
ChangedEntityTypes = System.Collections.Generic.Dictionary`2[System.String,System.String]
FpsPlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FpsPlugin: IsolationMode: 1
FpsPlugin: Mode: 0
FpsPlugin: OrganizationName: orga66a1bdf
FpsPlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FpsPlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FpsPlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FpsPlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FpsPlugin: IsInTransaction: True
FpsPlugin: Depth: 1
FpsPlugin: IsExecutingOffline: False
FpsPlugin: PluginContext End
FpsPlugin: Parent PluginContext End
FpsPlugin: PluginContext End
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: PluginLocal.Create, Depth: 1
FpsPlugin: InitializePlugin: local
FpsPlugin: ConfigurePluginFlagsSupportInternal()
FpsPlugin: CreateEntityOperation(bookableresourcebooking)
FpsPlugin: Operation type: BookableResourceBookingOperation
FpsPlugin: operation.Initialize()
FpsPlugin: InputEntity:
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedon = 5/28/2019 5:44:31 AM
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
modifiedonbehalfby =
vel_workcomplete = False
FpsPlugin: PreEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = b57973f1-be81-4660-bbfe-b6b1685785b3_systemuser[SYSTEM]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/6/2019 2:41:34 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = f16d80d1-fd07-4237-8b69-187a11eb75f9_bookingstatus[Scheduled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
msdyn_traveltimerescheduling = False
FpsPlugin: PostEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/28/2019 5:44:31 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
modifiedbyyominame = Plamen Kurtev
msdyn_traveltimerescheduling = False
FpsPlugin: operation.Execute()
FpsPlugin: PluginStage: 40 MessageName: Update
FpsPlugin: Before calling message handler
FpsPlugin: After
FpsPlugin: AfterUpdate
FpsPlugin: AfterCreateOrUpdate
FpsPlugin: PipelineLocal.Value: Retrieving local
FpsPlugin: PipelineLocal.Value: Retrieving soft
FpsPlugin: PipelineLocal.Value: Retrieving hard
FpsPlugin: Settings: Retrieving local
FpsPlugin: Settings: Retrieving hard
FpsPlugin: PipelineLocal.Value: Retrieving local
FpsPlugin: PipelineLocal.Value: Retrieving local
FpsPlugin: PluginLocal.Create, Depth: 2
FpsPlugin: PluginLocal.Dispose, Depth: 2
FpsPlugin: PluginLocal.Create, Depth: 2
FpsPlugin: PluginLocal.Dispose, Depth: 2
FpsPlugin: After calling message handler
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FpsPlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: PluginContext Start
FieldServicePlugin: MessageName: Update
FieldServicePlugin: PrimaryEntityName: bookableresourcebooking
FieldServicePlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FieldServicePlugin: SecondaryEntityName: none
FieldServicePlugin: Stage: 40
FieldServicePlugin: PreEntityImages.Count: 1
FieldServicePlugin: PostEntityImages.Count: 1
FieldServicePlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
ConcurrencyBehavior = Default
FieldServicePlugin: OutputParameters:
FieldServicePlugin: SharedVariables:
FpsPlugin_settings =
FieldServicePlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: IsolationMode: 1
FieldServicePlugin: Mode: 0
FieldServicePlugin: OrganizationName: orga66a1bdf
FieldServicePlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FieldServicePlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FieldServicePlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FieldServicePlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: IsInTransaction: True
FieldServicePlugin: Depth: -1
FieldServicePlugin: IsExecutingOffline: False
FieldServicePlugin: Parent PluginContext Start
FieldServicePlugin: PluginContext Start
FieldServicePlugin: MessageName: Update
FieldServicePlugin: PrimaryEntityName: bookableresourcebooking
FieldServicePlugin: PrimaryEntityId: ea2f1e65-a86f-e911-a881-000d3ad0ed15
FieldServicePlugin: SecondaryEntityName: none
FieldServicePlugin: Stage: 30
FieldServicePlugin: PreEntityImages.Count: 0
FieldServicePlugin: PostEntityImages.Count: 0
FieldServicePlugin: InputParameters:
Target = Microsoft.Xrm.Sdk.Entity
SuppressDuplicateDetection = False
ConcurrencyBehavior = Default
FieldServicePlugin: OutputParameters:
FieldServicePlugin: SharedVariables:
ChangedEntityTypes = System.Collections.Generic.Dictionary`2[System.String,System.String]
FieldServicePlugin: UserId: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: InitiatingUserID: 71d05771-18d4-e811-a879-000d3ad07131
FieldServicePlugin: IsolationMode: 1
FieldServicePlugin: Mode: 0
FieldServicePlugin: OrganizationName: orga66a1bdf
FieldServicePlugin: OrganizationId: 8ea6e8dd-cca3-4a28-8420-7ccef5c8d4b7
FieldServicePlugin: BusinessUnitId: 479bdd38-f1c1-e811-a86d-000d3ad0ed15
FieldServicePlugin: CorrelationId: 0c0f33cb-3fb1-4aba-bafa-47faeaa57669
FieldServicePlugin: RequestId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: OperationId: 96cd23e9-fbd6-4223-a3c2-8c1b9726255a
FieldServicePlugin: IsInTransaction: True
FieldServicePlugin: Depth: -1
FieldServicePlugin: IsExecutingOffline: False
FieldServicePlugin: PluginContext End
FieldServicePlugin: Parent PluginContext End
FieldServicePlugin: PluginContext End
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: PluginLocal.Create, Depth: 1
FieldServicePlugin: InitializePlugin: local
FieldServicePlugin: ConfigurePluginFlagsSupportInternal()
FieldServicePlugin: CreateEntityOperation(bookableresourcebooking)
FieldServicePlugin: Operation type: BookableResourceBookingOperation
FieldServicePlugin: operation.Initialize()
FieldServicePlugin: InputEntity:
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedon = 5/28/2019 5:44:31 AM
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
modifiedonbehalfby =
vel_workcomplete = False
FieldServicePlugin: PreEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = b57973f1-be81-4660-bbfe-b6b1685785b3_systemuser[SYSTEM]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/6/2019 2:41:34 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = f16d80d1-fd07-4237-8b69-187a11eb75f9_bookingstatus[Scheduled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
msdyn_traveltimerescheduling = False
FieldServicePlugin: PostEntityImage:
vel_customerassettestcompleted = False
statecode = 0
msdyn_allowoverlapping = False
msdyn_preventtimestampcreation = False
statuscode = 1
vel_customerassettestsnotcompleted = False
createdon = 5/6/2019 2:41:10 AM
vel_servicetaskscompleted = False
importsequencenumber = 0
msdyn_bookingsetupmetadataid = d59df12a-aedb-4f82-b5b8-9a6eba4f1712_msdyn_bookingsetupmetadata[msdyn_workorder]
msdyn_estimatedtravelduration = 0
ownerid = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_resourcerequirement = 982ee18a-391c-e911-a86a-000d3ad11148_msdyn_resourcerequirement[WO014999]
name = WO014999
msdyn_cascadecrewchanges = False
bookingtype = 1
owneridyominame = Plamen Kurtev
endtime = 4/23/2019 11:00:00 PM
msdyn_workorder = 932ee18a-391c-e911-a86a-000d3ad11148_msdyn_workorder[WO014999]
vel_workcomplete = False
transactioncurrencyid = 42e45582-ead9-e711-a829-000d3ae0e7a4_transactioncurrency[Australian Dollar]
exchangerate = 1.0000000000
timezoneruleversionnumber = 5
duration = 30
bookableresourcebookingid = ea2f1e65-a86f-e911-a881-000d3ad0ed15
modifiedby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
resource = 43424c6d-d2c5-e811-a883-000d3ad07e6c_bookableresource[Perry Goss]
createdbyyominame = Plamen Kurtev
modifiedon = 5/28/2019 5:44:31 AM
owningbusinessunit = 479bdd38-f1c1-e811-a86d-000d3ad0ed15_businessunit[]
bookingstatus = 0adbf4e6-86cc-4db0-9dbb-51b7d1ed4020_bookingstatus[Cancelled]
starttime = 4/23/2019 10:30:00 PM
createdby = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[Plamen Kurtev]
msdyn_estimatedarrivaltime = 4/23/2019 10:30:00 PM
owninguser = 71d05771-18d4-e811-a879-000d3ad07131_systemuser[]
msdyn_bookingmethod = 690970001
modifiedbyyominame = Plamen Kurtev
msdyn_traveltimerescheduling = False
FieldServicePlugin: operation.Execute()
FieldServicePlugin: PluginStage: 40 MessageName: Update
FieldServicePlugin: Before calling message handler
FieldServicePlugin: After
FieldServicePlugin: AfterUpdate
FieldServicePlugin: AfterCreateOrUpdate
FieldServicePlugin: PluginLocal.Create, Depth: 2
FieldServicePlugin: PluginLocal.Dispose, Depth: 2
FieldServicePlugin: PluginLocal.Create, Depth: 2
FieldServicePlugin: PluginLocal.Dispose, Depth: 2
FieldServicePlugin: PluginLocal.Create, Depth: 2
FieldServicePlugin: PluginLocal.Dispose, Depth: 2
FieldServicePlugin: PluginLocal.Create, Depth: 2
FieldServicePlugin: PluginLocal.Dispose, Depth: 2
FieldServicePlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin: PluginLocal.Dispose, Depth: 1
FieldServicePlugin:
An error occured while processing this request.
Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152

Microsoft.Xrm.Sdk.SaveChangesException: An error occured while processing this request. ---&gt; System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152
at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext, Dictionary`2 optionalParameters)
at Microsoft.Crm.Extensibility.InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
at Microsoft.Dynamics.FieldService.FieldServicePatchOrganizationService.PatchOrganizationService.Execute(OrganizationRequest request)
at Microsoft.Dynamics.FieldService.FieldServiceEventSource.LogOrganizationService.Execute(OrganizationRequest request)
at Microsoft.Dynamics.FieldService.PluginCommon.PluginFlagsOrganizationServiceFactory.Service.Execute(OrganizationRequest request)
at Microsoft.Xrm.Sdk.Client.OrganizationServiceContext.Execute(OrganizationRequest request)
at Microsoft.Xrm.Sdk.Client.OrganizationServiceContext.SaveChange(OrganizationRequest request, IList`1 results)
--- End of inner exception stack trace ---
at Microsoft.Xrm.Sdk.Client.OrganizationServiceContext.SaveChanges(SaveChangesOptions options)
at Microsoft.Dynamics.FieldService.Operations.BookableResourceBookingOperation.UpdateWorkOrder()
at Microsoft.Dynamics.FieldService.Operations.BookableResourceBookingOperation.AfterCreateOrUpdate()
at FieldOne.PluginCommon.EntityOperation`3.HandleMessage(Int32 pluginStage, String messageName)
at FieldOne.PluginCommon.Operation`1.HandleMessage()
at FieldOne.PluginCommon.Operation`1.Execute()
at FieldOne.PluginCommon.FosPluginBase.ExecutePlugin(ITracingService tracingService, IPluginExecutionContext pluginContext, IOrganizationServiceFactory serviceFactory)
at Microsoft.Dynamics.FieldService.FieldServicePlugin.ExecutePlugin(ITracingService tracingService, IPluginExecutionContext pluginContext, IOrganizationServiceFactory serviceFactory)
at FieldOne.PluginCommon.FosPluginBase.Execute(IServiceProvider serviceProvider)

at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext, Dictionary`2 optionalParameters)

at Microsoft.Crm.Extensibility.InprocessServiceProxy.ExecuteCore(OrganizationRequest request)

at Microsoft.Dynamics.FieldService.FieldServicePatchOrganizationService.PatchOrganizationService.Execute(OrganizationRequest request)

at Microsoft.Dynamics.FieldService.FieldServiceEventSource.LogOrganizationService.Execute(OrganizationRequest request)

at Microsoft.Dynamics.FieldService.PluginCommon.PluginFlagsOrganizationServiceFactory.Service.Execute(OrganizationRequest request)

at Microsoft.Xrm.Sdk.Client.OrganizationServiceContext.Execute(OrganizationRequest request)

at Microsoft.Xrm.Sdk.Client.OrganizationServiceContext.SaveChange(OrganizationRequest request, IList`1 results)


FieldServicePlugin: PluginLocal.Dispose, Depth: 1

</TraceText>
</OrganizationServiceFault>

Categories:
Work Order
Field Service
Connected Field Service
  • RayDL Profile Picture
    RayDL 5 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled
    [quote user="Karuna Karan"]

    I would suggest disabling all plugins and workflows (in test environment) that triggers over the booking & its related entities such as work order, resource requirements etc. and then try the status change action. If it works, then enable plugin/wf one by one and try to zero down on the cause. Also try and see if you get any error when canceling the booking from schedule board directly.

    [/quote]

    This issue only happens in one particular Booking and it's in Prod instance, so I don't think it's an option to disable all plugins and workflows or plugins.

    Cancelling the booking from the schedule board directly also produces the same error.

  • Fannie30 Profile Picture
    Fannie30 2,990 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Has anyone updated any of the OOB Status values?  Are there any customizations running in the background based on status changes?  What version of FS are you running and are you updating to canceled in D365 online or FS Mobile?  

  • Karuna Karan Profile Picture
    Karuna Karan 1,210 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    I would suggest disabling all plugins and workflows (in test environment) that triggers over the booking & its related entities such as work order, resource requirements etc. and then try the status change action. If it works, then enable plugin/wf one by one and try to zero down on the cause. Also try and see if you get any error when canceling the booking from schedule board directly.

  • RayDL Profile Picture
    RayDL 5 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    [quote user="Thomas Dayman"]

    I can see that the error says. Sql error: A validation error occurred. A string value provided is too long.

    Do you have a workflow setting a field over the character limit?

    [/quote]

    I don't have such workflow. I've checked all fields (related Work Order, Bookings, Service Task, Job Type), none has long string value.

    And this is the only error in a particular Booking among hundreds which were successfully cancelled.

  • RayDL Profile Picture
    RayDL 5 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Do you manually cancel the booking? Yes

    Do you have any plugins or workflow? Yes, but the error (please see below) was triggered by Field Service OOB Plugin, not from the custom ones. Correct me if I'm wrong.

    FieldServicePlugin: PluginLocal.Dispose, Depth: 1

    FieldServicePlugin:

    An error occured while processing this request.

    Sql error: A validation error occurred. A string value provided is too long. CRM ErrorCode: -2147012607 Sql ErrorCode: -2146232060 Sql Number: 8152

    javascript:void(0);

  • Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    I can see that the error says. Sql error: A validation error occurred. A string value provided is too long.

    Do you have a workflow setting a field over the character limit?

  • Al Iggs Profile Picture
    Al Iggs on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Hmm, that wasn't the cause. Do you manually cancel the booking? Do you have any plugins or workflow? Localizations? Have never come across this issue myself.

  • RayDL Profile Picture
    RayDL 5 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Here it is;

    Screenshot_5F00_20190628_2D00_214435_5F00_Chrome.jpg

  • Al Iggs Profile Picture
    Al Iggs on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Almost :-) , the "General" tab please. I'm just looking for entries that might be too long and then later cause the error when selecting this status.

  • RayDL Profile Picture
    RayDL 5 on at
    RE: Unable to update Bookable Resource Booking from Scheduled to Cancelled

    Sorry, I keep misunderstanding. Hopefully below is the one you want;

    Screenshot_5F00_20190628_2D00_181129_5F00_Chrome.jpg

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans