Skip to content
+1-888-319-3663

COMMUNITY FORUM

Folder Data Source on schedule

Jim asked 4 years ago
I’ve got a map with a folder data source and have it scheduled to check every 15 minutes for a new file (only because real-time folder data sources aren’t working currently).  If there is no file present in the folder when the scheduled task runs, it’s being flagged as a failed run.  Is there a way to only have it flagged as a failure if there is a file present?  The option setting on the map is to return success if there is no data.
Phil replied 2 years ago

Jim,

Did you ever get a solution to this? I have the same problem. I’m running a scheduled map that checks integrates an Excel data source but it’s throwing errors when the Excel file doesn’t exists (which it won’t about 99.9% of the time). I only want it to be a failure if there is an Excel file and it actually fails the integration, not if it can’t find the file. Is there a way to accomplish this? I don’t want to have to have an empty Excel file sitting there. Perhaps there’s a scripted solution?

Jim Harris replied 2 years ago

Yes, we ended up creating sql jobs to run any maps that use a folder data source. One requirement is that sql has to be installed on the same machine as smartconnect. We run all of our smartconnect maps from a single application server, so adding sql there wasn’t an issue for us.

Below is an example of the script to use. If no file is found then the error handling is done in sql, so in SmartConnect the only errors reported are legitimate ones for a specific source file.

exec master..xp_cmdshell ‘”C:\Program Files (x86)\eOne Solutions\SmartConnect\eOne.SmartConnect.RunMapConsole.exe” EW2_CASH_RCPT_STAGING’, no_output;

Feel free to contact me directly at jim.harris@examworks.com

Answers
Ethan Sorenson Staff answered 4 years ago
Jim,
I just verified that the map returns success on 20.17.0.17 when the options tab on the map is set to return success when no data is returned from data source. 
Make sure your folder locations use UNC path names, and the map is set to allow any user to run the map. 
Jim replied 4 years ago

I was working with 20.16 before. Upgraded our test server to 20.18.0.9 but I’m still getting the same thing. I did make the changes you noted for UNC paths and allowing any user to run the map. The options setting is to return success if there is no data. I do have is set to log errors. Wondering if that could be a factor.


If you would like to submit an answer or comment, please sign in to the eOne portal.