News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Database Synch error o...

Finance | Project Operations, Human Resources, ...

Unanswered

Database Synch error on the standard data entity

(3) Share

Report

Report

Posted on by Johnny

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Sandeep Tanwar 2 on at

Like (0)

Report

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 Cal... 291,642 Super User 2024 Season 2 on at

Like (0)

Report

Database Synch error on the standard data entity

Hi Johnny,

From which data source, what field was added?

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans