Reload Content Monitor fails constanly. At the end of the log file it says Error: Table 'FolderScanResults' not found. See the log file attached. What is the cause of the error? How to fix it?
Hello @AO, the Content Monitor is programmed to inventory files in all the Folder Data Connections in the platform, and to avoid long reload times, this happens only once per month.
When it will happen is driven by a variable in the ** optional configuration ** section of the Data load script, vFileScanReferenceDay.
The default value (1) indicates that the file scan will be executed only when the reload happens between the 1st and the 6th of the month. If the value was 15, it would execute only when the reload happens between the 15th and 21st of the month.
On some systems, the reload fails until the first file scan happens. If the App was deployed anytime after the 6th of the month, it will fail until the next month starts and the reload happens between the 1st and the 6th of the month.
[Today is March 2nd] Setting that variable to 5 will ensure that the scan is triggered next Saturday (March 6). If you want to have a reload earlier than Saturday, then set the variable to the day you expect it to run. You don't need to change it again in the future, just know that it will execute only when the reload falls within the 6 calendar days starting on the day of the value of the variable.
Hello @AO, the Content Monitor is programmed to inventory files in all the Folder Data Connections in the platform, and to avoid long reload times, this happens only once per month.
When it will happen is driven by a variable in the ** optional configuration ** section of the Data load script, vFileScanReferenceDay.
The default value (1) indicates that the file scan will be executed only when the reload happens between the 1st and the 6th of the month. If the value was 15, it would execute only when the reload happens between the 15th and 21st of the month.
On some systems, the reload fails until the first file scan happens. If the App was deployed anytime after the 6th of the month, it will fail until the next month starts and the reload happens between the 1st and the 6th of the month.
[Today is March 2nd] Setting that variable to 5 will ensure that the scan is triggered next Saturday (March 6). If you want to have a reload earlier than Saturday, then set the variable to the day you expect it to run. You don't need to change it again in the future, just know that it will execute only when the reload falls within the 6 calendar days starting on the day of the value of the variable.
