Developer forum

Forum » Integration » Integration job fails instantly but work on another site

Integration job fails instantly but work on another site

Skylar Kennedy
Reply

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 Dynamicweb Employee
Nicolai Pedersen
Reply

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
Reply

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 Dynamicweb Employee
Imar Spaanjaars
Reply

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

Looks like bad XML

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
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