0

Jet Scheduler

Jet Reports Historic Posts

January 20, 2014 02:15

None

Follow

Hi All,

I having a problem on using Jet Scheduler, my PC has CPUi5 3.20GHz , Memory is 8 GB , OS is MS Window 7 Professional 64 bits.

Jet Report Version is 2013 64bits , Microsoft Office 365 ProPlus - Excel 2013 64 bits

I have several reports when run direct manually on the PC, no problem, report ok, result ok, value ok.

But when scheduled those reports at the Jet Scheduler, those reports sometime ok, sometime contained #Value! , sometime the PC excel and jet engin hang, (Note: No other jobs being run or scheduled in anykind, memory is only 2gb being utilised by OS, balance of 6gb memory free)

Report has rows : 3 level grouping and columns : Jan to Dec (Table being read is Item Ledger Entry Table)

How to I able to solve this problem.

Thanks.

Rgards
Ed.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 20, 2014 10:57

  Did you turn on logging? So, if there is an error you see it.
  Did you run the report with the exact same settings Manually?
  Did you put in the correct user password in the Scheduler?
  
  I have a lot of automatic reports running, very simple one's but also very complicated ( 5 hours+ ). No problems with reports or sending them.

• 0
  
  Jet Reports Historic Posts January 20, 2014 16:27

  edwloh,
  
  Try disabling Batch Function Execution on the Machine that schedules the reports. Not certain this is the solution since the report runs successfully when manually run, but it is something that we had to disable to get certain "large" reports to run successfully on our Dedicated Scheduled Report system.
  
  To disable do the following:
  
  - Log into the machine with the account that is used to run the Scheduled Tasks.
  - Open Excel.
  - Click the Jet Tab and click on Application Settings.
  - Click on the Performance Options.
  - Uncheck the first checkbox "Enable batch function execution"
  
  Good luck!

• 0
  
  Jet Reports Historic Posts January 21, 2014 04:07

  Did you run the report with the exact same settings Manually?
  all parameters are same.
  
  Did you put in the correct user password in the Scheduler?
  passowrd same.
  
  it seem utlised a lot of memory during jet scheduler run report compare to manual direcr run report