Macro/Scheduler problem

[saira78]

I have something strange happening on my Scheduler. I have created and successfully tested a macro to run a report and export to an Excel file. When run manually or from CognosScript Editor, it runs without a hitch. When it is on the Scheduler, the result is 0 rows.

Why would this be? Could it be a timeout issue? The report generally takes between 8-12 minutes to run depending on the number of transactions. The exported file is being saved into a network drive.

I have other macros that do the same thing and work fine.

Thanks for any suggestions.

Saira

 

[griffindm]

Does the report automatically retrieve rows? If not, either change it to do so, or add a .Retrieve method before the export to Excel.

Other than that, I have no other ideas on this one yet.

Good luck,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[saira78]

It is set to automatically retrieve rows :-(

I'm so disappointed! I thought macros would be my answer to successful automation of my daily report runs

If you have any other ideas...

Thanks,
Saira

 

[Recce]

Hi,

What database type do you extract from ?

 

[saira78]

Oracle 8.1.7.0.0 on an RS6000 running AIX 4.3.3 and I should mention that we are using the Oracle drivers, not the ones provided by Microsoft.

Thanks,
Saira

 

[Kaiaualad]

How about using the AT Dos command to schedule your macros instead of cognos scheduler?
Also - try using a UNC instaed of a mapeed network drive.

 

[hsqamar]

I have also seen strange things happen in the scheduler when running macros. Try using a User DSN entry for your catalog source if you're not doing so.
hope you find a solution.

 

[saira78]

hsqamar,

Interesting suggestion. We are currently using system DSN. What is the relevance to the problems in the Scheduler or is it just one of those things that was accidentally discovered?

Thanks. I will give it a try.
Saira