web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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
  • Al Iggs Profile Picture
    Al Iggs Microsoft Employee on at

    Can you go to Field Service>Resources>Booking Statuses>Canceled and share a screenshot of the General Common and FS tabs?

  • RayDL Profile Picture
    RayDL 5 on at

    Hi Alexander, I can't find Field Service > Resources > Booking Statuses > Canceled, we probably have different Site Map.

    Below is the screenshot of Field Service tabs;

    ProjectService.png

    In my instance, Resources is under the Project Service tabs, below is the Project Service tabs screenshot;

    ProjectService.png

    Let me know what you need to see.

    Thanks!

  • Al Iggs Profile Picture
    Al Iggs Microsoft Employee on at

    Ah, you're on FS v7.x. If I remember correctly, booking statuses are under Settings>Administration.

  • RayDL Profile Picture
    RayDL 5 on at

    Seems what we're looking (Booking Statuses) is not in the System  > Administration as well;

    Sorry, I am new to Field Service, I have Googled and couldn't find Booking Statuses location on FS v.7.1. 

  • Suggested answer
    Fannie30 Profile Picture
    Fannie30 2,990 Moderator on at

    FIeld Service Settings is where it should be located.  So go to the Field Service Area - Administration.  There you should see Booking Statuses

  • RayDL Profile Picture
    RayDL 5 on at

    Ah, found it, thanks Scott!

    So it's in Field Service > Administration (Settings sub-menu)

    CancelledCommon.png

    So I'm posting the screenshot which Alexander asked earlier;

    CancelledCommon.png

    Thanks for helping!

  • Al Iggs Profile Picture
    Al Iggs Microsoft Employee on at

    Apologies, forgot that you use the web client. Can you do a screenshot that just shows the normal details of this booking status? I was hoping we could see modifications of the standard values.

  • RayDL Profile Picture
    RayDL 5 on at

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

    Screenshot_5F00_20190628_2D00_181129_5F00_Chrome.jpg

  • Al Iggs Profile Picture
    Al Iggs Microsoft Employee on at

    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

    Here it is;

    Screenshot_5F00_20190628_2D00_214435_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

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 > Field Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans