Hello,
I am trying to update fixed asset using data entities.
Fixed assets Target Entity AssetFixedAssetEntity
Fixed assets V2 entity Target Entity AssetFixedAssetV2Entity
I am getting strange error like below. Entities should be allowing to update the records as well. Is there a problem in the version of D365 or I am using a wrong entity to update. Any suggestion or pointer would be really great.
Installed product version : 10.0.35 (10.0.1627.75)
Installed platform version : Update59 (7.0.6972.95)
Results. Cannot execute the required database operation.
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]UPDATE is not allowed because the statement
updates view /ASSETFIXEDASSETENTITY/ which participates in a join and has an INSTEAD OF UPDATE
trigger.
UPDATE ASSETFIXEDASSETENTITY SET ASSETLOCATIONID = T1.ASSETLOCATIONID,FIXEDASSETGROUPID = T1.FIXEDASSETGROUPID,FIXEDASSETNUMBER = T1.FIXEDASSETNUMBER,NAME = T1.NAME,RESPONSIBLENAME = T1.RESPONSIBLENAME,SEARCHNAME = T1.SEARCHNAME,SERIALNUMBER = T1.SERIALNUMBER FROM ASSETFIXEDASSETSTAGING T1 CROSS JOIN ASSETFIXEDASSETENTITY T2 WHERE ((T1.PARTITION=5637144576) AND (((T1.DEFINITIONGROUP=N'FixedAsset') AND (T1.EXECUTIONID=N'FixedAsset-2023-09-13T19:07:04-31B150FA16A242A8BBDE6F5E545155B0')) AND NOT ((T1.TRANSFERSTATUS=2)))) AND (((((((((((((((((((((((((((((((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'8026')) AND ((T2.PARTITION#2=5637144576) OR (T2.PARTITION#2 IS NULL))) AND ((T2.DATAAREAID#2=N'8026') OR (T2.DATAAREAID#2 IS NULL))) AND ((T2.PARTITION#3=5637144576) OR (T2.PARTITION#3 IS NULL))) AND ((T2.DATAAREAID#3=N'8026') OR (T2.DATAAREAID#3 IS NULL))) AND ((T2.PARTITION#4=5637144576) OR (T2.PARTITION#4 IS NULL))) AND ((T2.PARTITION#5=5637144576) OR (T2.PARTITION#5 IS NULL))) AND ((T2.PARTITION#6=5637144576) OR (T2.PARTITION#6 IS NULL))) AND ((T2.DATAAREAID#6=N'8026') OR (T2.DATAAREAID#6 IS NULL))) AND ((T2.PARTITION#7=5637144576) OR (T2.PARTITION#7 IS NULL))) AND ((T2.DATAAREAID#7=N'8026') OR (T2.DATAAREAID#7 IS NULL))) AND ((T2.PARTITION#8=5637144576) OR (T2.PARTITION#8 IS NULL))) AND ((T2.DATAAREAID#8=N'8026') OR (T2.DATAAREAID#8 IS NULL))) AND ((T2.PARTITION#9=5637144576) OR (T2.PARTITION#9 IS NULL))) AND ((T2.DATAAREAID#9=N'8026') OR (T2.DATAAREAID#9 IS NULL))) AND ((T2.PARTITION#10=5637144576) OR (T2.PARTITION#10 IS NULL))) AND ((T2.DATAAREAID#10=N'8026') OR (T2.DATAAREAID#10 IS NULL))) AND ((T2.PARTITION#11=5637144576) OR (T2.PARTITION#11 IS NULL))) AND ((T2.DATAAREAID#11=N'8026') OR (T2.DATAAREAID#11 IS NULL))) AND ((T2.PARTITION#12=5637144576) OR (T2.PARTITION#12 IS NULL))) AND ((T2.PARTITION#13=5637144576) OR (T2.PARTITION#13 IS NULL))) AND ((T2.DATAAREAID#13=N'8026') OR (T2.DATAAREAID#13 IS NULL))) AND ((T2.PARTITION#14=5637144576) OR (T2.PARTITION#14 IS NULL))) AND ((T2.PARTITION#15=5637144576) OR (T2.PARTITION#15 IS NULL))) AND ((T2.DATAAREAID#15=N'8026') OR (T2.DATAAREAID#15 IS NULL))) AND ((T2.PARTITION#16=5637144576) OR (T2.PARTITION#16 IS NULL))) AND ((T2.DATAAREAID#16=N'8026') OR (T2.DATAAREAID#16 IS NULL))) AND ((T2.PARTITION#17=5637144576) OR (T2.PARTITION#17 IS NULL))) AND ((T2.DATAAREAID#17=N'8026') OR (T2.DATAAREAID#17 IS NULL))) AND (T1.FIXEDASSETNUMBER=T2.FIXEDASSETNUMBER))
session 1048 (Admin)
'1' 'Fixed assets' record(s) inserted in staging
Thanks,
Vinodh
