Finance | Project Operations, Human Resources, ...

Database Synch error on the standard data entity

(3) Share

Report

Posted on by Johnny

6,494

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 (2)

Answers (0)

Sort by

André Arnaud de Cal... 307,259 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Johnny,

From which data source, what field was added?
Suggested answer

Sandeep Tanwar 2 on at

Like (0)

Report
Copy link

Link copied!

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.