Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Error while updating fixed asset using data entities.

(1) ShareShare
ReportReport
Posted on by 17
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
 
  • PasqualD Profile Picture
    PasqualD 77 on at
    Error while updating fixed asset using data entities.
     
    Important: use the according entity and uncheck set-based processing. Delete Majortypeid in import file or entity attribute. I received error message field major type must be filled in
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,615 Most Valuable Professional on at
    Error while updating fixed asset using data entities.
    Hi,
     
    Go to your Excel please and then delete the lines that seems are blank in your Excel.
  • SB-13052059-0 Profile Picture
    SB-13052059-0 2 on at
    Error while updating fixed asset using data entities.
    Thanks for the solution to this, I have never encountered this before and I have loaded assets tons of times before. Thanks again!
  • Verified answer
    DAX Coder Profile Picture
    DAX Coder 17 on at
    Error while updating fixed asset using data entities.
    Found the solution for this issue. It is their in product itself. Some of the entities are set based. Thus wont allow update. We have to check uncheck the set based operation. Entity refresh is not required for this change to take effect.
     
     
    WorkSpace > Data Management > Data Entities > Edit > Grid > Uncheck the set based operation.
     
     
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans