Developer forum

Forum » Integration » OrderUser export - some issues

OrderUser export - some issues

E-mail notifications
Aki Ruuskanen
Aki Ruuskanen
Reply
Posted on 22/12/2017 08:27:17

We have integration with NAv using the "Integration Framework Batch".
On of the tasks is to export users and orders. 
There we have defined a orderexport and and userexport in the Data Integration.
The problem we have is that sometimes the Navison is doing stuff at the same time as the export and has locked some tables. 

This results in a error saying: 

The add-in executed in this task is: NavOrderUserExport.
Error log information: 
ORDER WEB50083 has empty OrderCustomerAccessUserExternalID

And as soons as this has happend once the OrderUserExport will not work anymore and we need to manually fix it. 

Is there anything we can do to avoid this behavior?

Regards / Aki


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 28/12/2017 10:04:53
Reply

Hi Aki,
it looks like you are using some custom "NavOrderUserExport" add-in, ours default is called ExportDataAddIn/"Export data add-in",
so I am not sure where you get an error. But it looks like you are getting it from the NAV side at calling the method:
string response = ErpServiceCaller.PutOrders
and then you are probably checking the string content for OrderCustomerAccessUserExternalId but I am not sure(could not know where the exception is arised
in the data integration job or on the NAV side).
Is it in DW8 or DW9? Could you attach the data integration jobs log files?
They are created once you have run the add-in with the jobs in it, they are located in Files/System/Log/DataInitegration - sort by date desc.
Regards, Dmitrij

 
Aki Ruuskanen
Aki Ruuskanen
Posted on 02/01/2018 13:15:58
Reply

Sorry the task name is "NavOrderUserExport". The type of the task is "Export data add-in". No custom stuff going on there. 

The solution is upgraded to DW9 but we hade the same issue in DW8. 

This happends only occationally when (we asume) Navision is busy and has locked some table.

/Aki

 

You must be logged in to post in the forum