Results 1 to 1 of 1

Thread: Unable to refresh the pivots with huge data source using Autosys scheduler

  1. #1

    Exclamation Unable to refresh the pivots with huge data source using Autosys scheduler



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    We are having reports with pivots which are refreshed using huge data sources(.xlsx, .sas7bat (sas dataset), MDB files).

    For refreshing the same reports we are having excel tools created using VBA.

    We tried by scheduling the VBScript which will trigger the VBA macro using Autosys scheduler. For smaller data source (less than 50MB) the jobs are running successfully.

    When we use the data sources more than 50 MB size, the autosys job is failing. The same report is running through command prompt without any failure.

    Could you please help me to identify the issue??? Do we need to enable any settings in Autosys for larger files???

    Thanks in advance
    Vinoth
    Last edited by Truelie; 2017-04-21 at 06:38 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •