Folder Data Source on schedule
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?
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 email@example.com
I just verified that the map returns success on 18.104.22.168 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.
I was working with 20.16 before. Upgraded our test server to 22.214.171.124 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.