There was a problem loading the comments.

Sheet1 Can Not Be Found (XLS Input File)

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

Problem:

You're getting a login error for your report that looks something like this:

"Problem while checking for records in jnDoesReportHaveRecords. Message=The table 'Sheet1_' could not be found. Error in File SomeReport.rpt: The table could not be found."

Answer:

Our software is unable to open/see the input XLS file when it runs from the scheduler. This is not a bug in our software. It is a "feature" of the operating system.

Workaround:

You might be able to get around it by trying what is in this KB article:

http://superuser.com/questions/579900/why-cant-excel-open-a-file-when-run-from-task-scheduler

Create these two folders:

32Bit:

C:\Windows\System32\config\systemprofile\Desktop 

64Bit:

C:\Windows\SysWOW64\config\systemprofile\Desktop

Excel needs (expects) these folders to exist if it's not run interactively.



Share via

Related Articles

© Support @ Jeff-Net