You’re offline. This is a read only version of the page.
Hi Folks, I already posted a shorter version of this problem a couple of days ago but now I have new details and a new error.
The environment is 2 VMs using a local network:
• Server1: Windows Server 2012 / SQL Server 2012 SP2 / Dynamics AX 2012 R3 CU12
• Server2: Windows Server 2016 / SQL Server 2016 SP1
I created a System Data Source on Server1 that points to the EntityStore Database in Server2.
Then, I selected the BudgetTransactionCode entity and clicked “Publish".
DMF gives the following error:
An error occurred while receiving the HTTP response to win-eqfag5dhgvu/.../DMFServiceHelper.svc.
This could be due to the service endpoint binding not using the HTTP protocol.
This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down).
See server logs for more details.
The entity Budget register entries is not published
Found a post in the communities forum suggesting to add a sendTimeout and a receiveTimeout property in the DMF configuration file. I did and restarted the services… error is still there.
The config file is:
C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework\Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe.config
And the added parameters are here:
<binding name="DMFService_WsHttpBinding" sendTimeout="01:00:00" receiveTimeout="01:00:00" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">
<readerQuotas maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxDepth="2147483647" maxNameTableCharCount="2147483647" maxStringContentLength="2147483647" />
</binding>
I rebooted my DAX VM yesterday and now, when I try to publish an entity to the Entity Store Database, now I get the error “DMF2023”. There’s almost no documentation for this error except for this article:
www.daxrunbase.com/.../working-with-entity-store-and-dixf-in-ax
After that, I upgraded the DAX database to SQL2016 so I’ve everything in a single box but I’m still getting the same error.
With DMF2023 there’s at least an entry in the Event Viewer:
Log Name: Application
Source: DataMigrationImportExportFramework
Date: 2018-02-15 07:48:32
Event ID: 4000
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: WIN-EQFAG5DHGVU.nccdaxdev.ca
Description:
Get DataType failed for Column 'BUDGETTRANSACTIONTYPE'.
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDataType(DataType& dataType)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntityDBHelper.PublishSchema(String targetConnectionString, String database, String server, String stagingTable, Dictionary`2 additionalColumns, Boolean isDataArea, Boolean forceUpdate, Boolean isColumnStoreIndex)
No matter which entity I try to export, I always get this “Get DataType failed for Column…” and then it’s a different column name every time.
Anyway, the article says:
There are other issues with the framework as well when trying to publish values to external databases such as the Entity Store. We have worked out a fix with Microsoft for the database publishing, which is available on my GitHub. Make sure you get the class, import it in your environment, then do a Full CIL:
github.com/.../Data%20Import%20Export%20Framework
I included the class provided in the article and did a Full CIL. Nothing changed.
Anybody has found the same problems?
If this doesn't work, my "Plan B" is to use the OData Feed but I know that this is not the ideal way...
Thanks !!
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
4
