54
Hi
We tried to import data from excel using dmf workspace and system show error related to dmf service.
Is onprimise d365fo supports DMF. if supports do we need go to configure it separately.
Please advise
Regards
Shijith
Hi Shijith,
Ensure you have a correct version of SQL Server 2016 installed with the corresponding SSIS features. Also check if the license has been provided correctly. If not, it could also be the case that SQL Server itself is running as an evaluation edition. In that case, it could also give errors on SQL Server itself today or tomorrow.
Looks like an issue with Integration services. The error says - "Integration Services evaluation period has expired.".
Were you using an evaluation version? If so, can you try uninstalling SSIS and re-installing it? That should fix the issue.
Hi
Thanks all for the reply, good to know that DMF supported in on premise deployment of D365FO.
As requested please find the error messages.
Error message in View Execution log.
Package execution failed please check event log in DMF service box-
'0' 'Main account' record(s) inserted in staging
These are the error messages on Event log.
Package "{B28B600F-3C65-4898-A0EB-77A5733E636C}" failed.
-----------------
<?xml version="1.0"?><Errors><Error><ErrorCode>-1073741773</ErrorCode><SubComponent></SubComponent><Description>Integration Services evaluation period has expired.</Description></Error><Error><ErrorCode>-1073741773</ErrorCode><SubComponent></SubComponent><Description>Integration Services evaluation period has expired.</Description></Error></Errors>
-----------------------------------
DMF043
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ExportDataImpl()
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ExportData()
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.ExportData(DMFEntity entity)
---------------------
Exception from HRESULT: 0xC0202009
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFExcelPackageExport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)
Regards
Shijith
Hello Shijith,
Yes DMF is supported on the On Prem D365FO as per the document https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/cloud-prem-comparison
To integrate follow this office addin document for D365 FO Onprem https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration
For Data Integration Strategies please follow https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/integration-overview
Regards,
Clive Purushothaman
This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
Hi Shijith,
According to the documentation, DMF is supported by on-premise deployment, but recurring integrations are not supported. Are you trying to import data by loading an Excel file in the data management workspace and import data manually? Could you, please, share the exact error message?
The documentation for reference:
Hi Shijithkumar,
DMF is supported in on-premises deployments. What was the exact error you got while trying to use DMF?
You can check this link as well which describes SSIS setup for enabling DMF.
#1
André Arnaud de Cal...
283,860
Test role Public
#2
Ludwig Reinhard Microsoft Employee
#3
Martin Dráb
225,155
Moderator
Share
Report
All responses (
Answers (
