Error when deploying package on D365 F&O on-prem.

(3) Share

Report

Posted on by grapevyn

Good day,

I am facing an error when deploying a packing onto our on-prem F&O. I believe they started when we upgraded from .39 to .43. When I download the log, there aren't any helpful pointers but when digging in the event viewer of the second AOS server i found 3 errors

It says

07/15/2025 16:38:04: Infolog diagnostic message: 'Specified field VatDueDate_W
of datasource CzCustAdvanceInvoiceTable does not exist in the database or the
configuration key on the field or on Extended Data Type used by the field is
off. The view SAFTGeneralJournalFocusDimensionView can not be created in the
database.' on category 'Error'.

the other similar error says

07/15/2025 16:38:32: Infolog diagnostic message: 'Specified field VatDueDate_W
of datasource CzCustAdvanceInvoiceTable does not exist in the database or the
configuration key on the field or on Extended Data Type used by the field is
off. The view SAFTGeneralJournalView can not be created in the database.' on
category 'Error'.

the last error says

07/15/2025 17:01:36: Infolog diagnostic message: 'Query extended range failure:
Invalid class name 'WorkflowApprovalHistoryEntity'..' on category 'Error'.

I have looked at the views SAFTGeneralJournalFocusDimensionView and SAFTGeneralJournalView as well as the underlying datasource CzCustAdvanceInvoiceTable and VatDueDate_W but I am not able to change anything meaningful through extension to resolve this error as these components are in Application Suite model.

I checked in SQL and the field VatDueDate_W is there in the CzCustAdvanceInvoiceTable

Please assist.

Regards

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

grapevyn 16 on at

Like (1)

Report
Copy link

Link copied!
I resolved the first 2 errors by enabling maintenance mode then going to system admin->setup->license config and scroll to General ledger->sales tax-> and enable 'Transaction date for VAT register period'.

Please assist with the remaining error :

<EventData> <Data>07/16/2025 14:54:04: Infolog diagnostic message: 'Query extended range failure: Invalid class name 'WorkflowApprovalHistoryEntity'..' on category 'Error'.</Data> </EventData>

Was this reply helpful? Yes No
CU26011300-0 6 on at

Like (0)

Report
Copy link

Link copied!

Good day,

I came across your post regarding the error:

"Query extended range failure: Invalid class name 'WorkflowApprovalHistoryEntity'."

You mentioned that you resolved the first two errors by enabling maintenance mode and activating Transaction date for VAT register period in License configuration.

Could you please let me know if you were able to resolve the remaining error related to WorkflowApprovalHistoryEntity? If so, would you mind sharing what the root cause was and how you fixed it?

Thank you in advance!

Was this reply helpful? Yes No
CU28111010-1 99 on at

Like (0)

Report
Copy link

Link copied!

hi CU26011300-0,grapevyn is any one finds the solution for Infolog diagnostic message: 'Query extended range failure: Invalid class name 'WorkflowApprovalHistoryEntity'..' on category 'Error'.

Thank you in advance!

Was this reply helpful? Yes No