Hi,
I can able to publish the standard data entities in D365 for operations, to a external SQL DB which creates a table with columns same as that of data entities fields.
On creating a table directly using CREATE sql command, table is getting created in Azure DB. So there is permission for table creation in Azure SQL DB.
But on publishing the data entities to external SQL DB which is in Azure, the entities are not published and table creation is failed with the message "Error on publishing the data entity. Create for Table dbo.xxxxx."
And the stack trace is,
at Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntityProxy.DoWork[T](Func`1 work)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Dynamics.Ax.Xpp.CLRInterop.MakeReflectionCall(Object instance, String methodName, Object[] parameters)
Can anyone help guide me to publish the entity to Azure SQL DB.
Thanks,
Elamathi. S
