Skip to main content

Notifications

Announcements

No record found.

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

Database Synch error on the standard data entity

(3) ShareShare
ReportReport
Posted on by 6,420
Hello,
 
We have just deployed the new cloud hosted environment.
I made a branch from our UAT branch and applied the bacpac from UAT.
Compilation is succesfull, but during the DB synch, I'm getting below error on the data entity and table.
Only customization I see on this data entity is that, that extension is made and just 1 field is added from datasource. So no new datasources have been added.
Error        Log level - Error | Infolog diagnostic message: 'Specified datasource PurchLineAllVersions of View PurchPurchaseOrderConfirmationLineEntity is a temp table.' on category 'Error'. 
 
I can't underatdn what the problem is or how can I solve it, if all the tables in the entity are standard and no customizations are done on them?
Thanks
  • Suggested answer
    Sandeep Tanwar Profile Picture
    Sandeep Tanwar 2 on at
    Database Synch error on the standard data entity
    Hi Johnny,
     
    We are also getting the same error : 
     
    'Specified datasource PurchLineAllVersions of View PurchPurchaseOrderConfirmationLineEntity is a temp table.' on category 'Error'
     
    Further checking on the error log and found that error is thrown from PurchPurchaseOrderConfirmationLineEntity.totalLineSalesTaxAmountDefinition() method- error occurred while execute computed column method: totalLineSalesTaxAmountDefinition on view/ data entity PurchPurchaseOrderConfirmationLineEntity Microsoft.Dynamics.Ax.Xpp.ErrorException: Specified datasource PurchLineAllVersions of View PurchPurchaseOrderConfirmationLineEntity is a temp table.
     
    Fix - I tried to comment totalLineSalesTaxAmountDefinition method and db synch was succeeded. We are not using this entity in our current project. If you are using this entity please find the alternate solution.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at
    Database Synch error on the standard data entity
    Hi Johnny,
     
    From which data source, what field was added? 

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans