SourceOne for File Systems: "File archive - Historical" activity fails with "XML parsing: line 2"

Summary: SourceOne for File Systems: SourceOne "File archive - Historical" activity fails with error "XML parsing: line 2, character 1061, illegal xml character Native error: 9420 SQL State: 42000" ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

SourceOne File Archive parent job (JBS) fails while creating child jobs (JBC) based on the data sources selected while creating "File Archive - Historical" activity.
If many jobs were meant to be created by the parent job, some child jobs would have already started to process before the issue is encountered.
Parent and child jobs stop processing because SourceOne Job Dispatcher service would have instructed jobs to stop after error was encountered.

Error message similar to the following would be found in the SOFileArchiveJBS.log verbose log file on the SourceOne worker server that would have processed parent job for the activity that failed:

95216|P2D0|T1274|2017/04/13 23:18:46:531|CoExTask::Save|ERROR|System call failed. (0x86040100) [SOFileArchiveJBS, CoExTask.cpp(947).CoExTask::Save] >System call failed. (0x86040100) [SOFileArchiveJBS, CoExJDFDB.cpp(905).CoExJDFDB::ExecuteCmdForID] >System call failed. (0x86040100) [SOFileArchiveJBS, CoExJDFDB.h(514).CoExJDFDB::ExecuteSP] >System call failed. (0x86040100) Unknown error (0x800424CC) [SOFileArchiveJBS, CoExJDFDB.h(509).CoExJDFDB::ExecuteSP] >{XML parsing: line 2, character 1061, illegal xml character Native error: 9420 SQL State: 42000 } |CoExTask.cpp(947)|Job Id: 209023; Activity Name: FileShareProcessing; Activity Id: 10159; Activity Type: -1788567307; ES1WORKER


 

Cause

There is a malformed folder name present on the file system that was scanned by the SourceOne File Archive parent job.
That folder becomes part of XML to be saved in the SourceOne activity database for creating child job.
Saving XML to activity database fails with the error message mentioned in the issue section above.

Resolution

Identify and rename the folder that is causing the issue.

To identify the folder name causing the issue:

  1. On SourceOne worker server(s) with "File Archive - Historical" role change verbosity level for SOFileArchiveJBS component to 8 (decimal). To change it:  
    • Launch Registry Editor (regedit.exe)
    • Navigate to "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\EMC\SourceOne\TraceLogs\SOFileArchiveJBS\Settings"
    • Change value of TraceVerbosity to 8 (Decimal).
    • Close Registry Editor
  2. Create/run "File Archive - Historical" activity that is failing with the above-mentioned error message. 
  3. When parent jobs created by activity from step 2 are marked with failed state open SOFileArchiveJBS.log file on SourceOne worker server that processed failed parent job.
  4. Starting from the bottom where you fill find error message mentioned below start looking for folders that were recently scanned by SOFileArchiveJBS.exe process. You should find an oddly named folder similar to the following:
2077389|P2D0|T1274|2017/04/13 23:18:43:894|CSOFileArchiveJBS::ScanCurrentDirectory|VERBOSE|Push for path: \\?\UNC\LabMachine\E$\katwar\Downloads\       , index: 206912|SOFileArchiveJBS.cpp(3112)|Job Id: -1; Activity Name: ES1Worker; Activity Id: -1; Activity Type: -1; ES1WORKER
  1. Rename the folder identified in the step 4 and rerun the activity that failed.

Affected Products

SourceOne for File Systems

Products

SourceOne, SourceOne for File Systems
Article Properties
Article Number: 000171396
Article Type: Solution
Last Modified: 02 Sept 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.