Developer forum

Forum » Integration » BC integration - import products - sometimes fail

BC integration - import products - sometimes fail

E-mail notifications
Eva Sommer
Reply
Posted on 20/10/2022 13:06:21 
Hi,
we have a scheduled task that only sometimes fails with the error message below. We are trying to identify whether it happens because of something
in the DW end or caused by the ERP system (BC). 

I have not seen it myself, but was told that this error was also seen at a time when the BC was set to be offline. 
So could this be a general error message when the dw service cannot connect to BC? Or is there some other more saying error message for that scenario? 

2022-10-19 10:16:10.924: Starting scheduled task.
2022-10-19 10:16:47.515: There is no batch id in the response. Response (first 200 characters): <?xml version="1.0" encoding="utf-8"?><tables version="1.2.0.17_NAV14.22.46358"><table tableName="EcomProducts"><item table="EcomProducts"><column columnName="ProductID"><![CDATA[0003201]]></column><c
2022-10-19 10:16:51.466: String is not valid XML format: '{0}'.. System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.    at System.Xml.XmlTextReaderImpl.Throw(Exception e)    at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()    at System.Xml.XmlTextReaderImpl.ParseDocumentContent()    at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)    at System.Xml.XmlDocument.Load(XmlReader reader)    at System.Xml.XmlDocument.LoadXml(String xml)    at Dynamicweb.DataIntegration.ScheduledTaskAddIns.ImportDataWithPaging.ImportDataWithPagingScheduledTask.StringToXml(String xml)
2022-10-19 10:16:51.466: Including file content: D:\dynamicweb.net\Solutions\[Project]\Files\System\Log\DataIntegration\Import Products DAN (UPDATE)20221019-101610924574.log
2022-10-19 10:16:51.466: 2022-10-19 10:16:40.703: Start checking input files changing 2022-10-19 10:16:45.710: Finish checking input files changing 2022-10-19 10:16:45.710: reading configuration 2022-10-19 10:16:46.182: Starting import to temporary table for EcomProducts. 2022-10-19 10:16:46.567: Added 1000 rows to temporary table for EcomProducts. 2022-10-19 10:16:46.567: Finished import to temporary table for EcomProducts. 2022-10-19 10:16:46.567: Starting update products information. 2022-10-19 10:16:46.645: Update products information finished. 2022-10-19 10:16:47.499: Job succeeded. 
2022-10-19 10:16:51.466: End of file content: D:\dynamicweb.net\Solutions\[Project]\Files\System\Log\DataIntegration\Import Products DAN (UPDATE)20221019-101610924574.log
2022-10-19 10:16:51.466: Xml returned from the web service: 'http://[serviceURL]' is empty
2022-10-19 10:16:51.466: Scheduled task failed.

Replies

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Posted on 20/10/2022 13:59:16
Reply

Hi Eva,

If your screendump reflects actual data, it seems that the response is cut off:

That would also explain the error message String is not a valid XML format.

On the NAV side you need to find out why the response string is cut (if I get this correctly).

BR
Snedker

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 20/10/2022 14:27:37
Reply

I think it's the logging that cuts it off:

There is no batch id in the response. Response (first 200 characters)
 
Carolee Schuck Dynamicweb Employee
Carolee Schuck
Posted on 20/10/2022 18:39:02
Reply

Hi Eva,

Seems BC-related since BC is responsible for writing the response. 

The response contains valid data, so it's not a problem with BC being unavailable.

<table tableName="EcomProducts"><item table="EcomProducts"><column columnName="ProductID"><![CDATA[0003201]]>


Is it only the product import that fails?  

The error message is accurate, but I don't have any ideas yet as to why the response differs occassionally.

 

You must be logged in to post in the forum