Solution Properties
Solution ID:
220924760109037
Last Modified Date:
Tue Dec 02 14:32:57 UTC 2025
Taxonomy Path:
Category//Integration//Sage product
Author:
legacyauthor
Sage Paperless Construction: Folder watch imported documents aren't moving
Description
Cause

The archive folder is a subfolder of the Folder Watch folder.

  • For example: Sources: \\Server\xxxx\ Archiving Option: \\Server\xxxx\completed imports

The following error displays in the Job Poll when running PEImporter:

  • Error: "System.Data.StrongTypingException: The value for column 'SearchSubFolders' in table 'ImporterOption' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.
    at PEData.ImporterDataSet.ImporterOptionRow.get_SearchSubFolders() in D:\a\1\s\PEAppServer\PEData\ImporterDataSet.Designer.cs: line 11164
    --- End of inner exception stack trace ---
    at PEData.ImporterDataSet.ImporterOptionRow.get_SearchSubFolders() in D:\a\1\s\PEAppServer\PEData\ImporterDataSet.Designer.cs: line 11167
    at PEImporterJobPollService.Job.MoveToFolder(ImporterOptionRow Source, ImporterOptionRow Target, String SessionFolder, String RemoteFilePath, CloudClient SourceUser) in D:\a\1\s\PEJobPollService\PEImporterJobPollService\Job.vb: line 647
    at PEImporterJobPollService.Job.VB$StateMachine_17_Run.MoveNext() in D:\a\1\s\PEJobPollService\PEImporterJobPollService\Job.vb: line 475"
Resolution
  1. Go to the Capture tab.
  2. Select Importer.
  3. Select the Folder Watch folder.
  4. Click Edit.
  5. Update the source path or archiving settings so the move folder isn’t within the source’s parent directory.
    For example: Sources: \\Server\xxxx\imports Archiving Option: \\Server\xxxx\completed imports.
Steps to duplicate
Related Solutions

Sage Paperless Construction Folder watch isn't working.

What job polls do I set up in Sage Paperless Construction?