Error while using FileBrowse Tool (No Sheet Specified)

Question

Team, I'm having this error mentioned below when executing the Analytic App:

DbFileInput (33): No sheet specified, you must specify a sheet
DbFileInput (7): No sheet specified, you must specify a sheet
DbFileInput (118): No sheet specified, you must specify a sheet

But if I open that as a workflow in the Desktop application, it is executing without any issues. Following is the workflow screenshot of how the FileBrowse Tool is used:

Thank you for your help in advance.

OllieClarke · Answer

@Rahulkanth to add to @alexnajm's points:
If you're connecting to an excel and your action tool is overwriting the full filepath of the input data tool, then that will overwrite the sheetname too. The filebrowse tool doesn't include the sheet, so you'll probably have to update a specific string in the action tool (everything to the left of the '|||') rather than the full filepath.

alexnajm · Answer

It's hard to help off hand with the screenshots, but a couple of thoughts:

- Your Action tools should be set to "Update Input Data tool" - one of them is but one is not

- There are three Input Data tools getting the error, but only two are shown - are those truly the ones coming up with the errors?

- Are the Mapping / Settings files you are feeding in .xlsx or .csv?