Solution Properties
Solution ID:
220924760109037
Last Modified Date:
Tue Jul 05 17:09:31 UTC 2022
Taxonomy Path:
Category//Transactions
Author:
legacyauthor
Folder watch imported documents are not moving in Sage Paperless Construction?
Description
Cause

The archive folder is a sub folder of the folderwatch folder. such as below
Sources: \\Server\xxxx\ Archiving Option: \\Server\xxxx\completed imports

May see similar error in job poll when running PEImporter

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

For full information see Sage Paperless Construction help under the Contents of Capture, Importer.

  1. Go to the Capture tab.
  2. Select Importer.
  3. Select the Folder Watch folder in question and select edit.
  4. Change either the Sources for the imported file location or Archiving options to update the move folder location so that the Sources is not a parent folder.
    Example:
    Sources: \\Server\xxxx\imports Archiving Option: \\Server\xxxx\completed imports
DocLink: Which job poll jobs should I set up in Sage Paperless Construction?
Defect ID
Steps to duplicate
Related Articles