Integration job fails instantly but work on another site

Skylar Kennedy

Posted on 16/04/2024 21:23:57

Hello forums,

I have two websites with identical integration jobs using an identical staging table as the source and using dynamicweb provider as the destination provider. The websites use two different databases and the staging table exists in both. For some reason, the job successfully runs on one website but not the other. I've tried checking the schema numerous times and dropping the number of rows in the source table to one. It fails quickly and gives me a "job failed" error. Is there anything else I should try to get the job to run?

Thank you,

Skylar

Replies

Nicolai Pedersen

Posted on 16/04/2024 23:36:02

What does the log says for the failed job? You can find the information in Settings -> System -> Event viewer. It will tell you which log file to look into.

Skylar Kennedy

Posted on 17/04/2024 14:35:36

2024-04-16 18:15:45.191: Integration job failed: 'Update CategoryFields from DB Staging Table'; logfile: /Files/System/Log/DataIntegration/Update CategoryFields from DB Staging Table20240416-181544988789.log. System.Xml.XmlException: Unexpected end of file while parsing Name has occurred. Line 5868, position 55.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset, Int32& colonPos)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.Load(String filename)
at Dynamicweb.Configuration.Xml.XmlConfigurationProvider.Persist()
at Dynamicweb.Configuration.ConfigurationManager.SetValue[T](String key, T value)
at Dynamicweb.DataIntegration.Integration.Job.UpdateStatistic(ISource source, IDestination destination)
at Dynamicweb.DataIntegration.Integration.Job.Run()
2024-04-16 18:15:45.191: Request headers: [ "Host" ]
2024-04-16 18:15:45.191: Request item keys: [ "ExecutionTableMapper", "Dynamicweb.Environment.Web", "Dynamicweb.DataIntegration.Providers.DynamicwebProvider.DynamicwebProvider" ]
2024-04-16 18:15:45.191: Request form: []

Imar Spaanjaars

Posted on 17/04/2024 14:58:22

>> Unexpected end of file while parsing Name has occurred. Line 5868, position 55.

Looks like bad XML

Dmitriy Benyuk

Posted on 17/04/2024 15:00:55

This post has been marked as an answer

Hi Skylar,
can you try to open the "GlobalSettings.config" file from the Files folder and check its content?
Maybe smth is broken in this file
BR, Dmitrij

Votes for this answer: 1

You must be logged in to post in the forum

Developer forum

Integration job fails instantly but work on another site

Replies