Close Impromptu v6

[ClayT]

I cannot seem to close the Impromptu User application when running it from Scheduler. It works with the Impromptu Administrator version, but not the User version. This is v6.

I have a macro that I run from the Command Script field on Scheduler's "Results" tab. It's called CLOSEIMP.MAC. The contents are:

Sub Main()
Dim objImpApp As object
Set objImpApp = GetObject("CognosImpromptu.Application")
objImpApp.Quit
Set objImpApp = Nothing
End Sub

When a user with the Administrator version schedules a report and uses this macro, Impromptu starts, runs the report, and closes at the end. When a user with Impromptu User does this, the Impromptu app does not close on completion of the report. Jobmgr32.exe continues running at 100% CPU utilization.

Is there any difference in the way the macro is used between Admin and User of Impromptu? Can anyone recommend a change that would work with both Admin and User?

Thanks

 

[drlex]

Since the workaround you relate is the procedure listed on the Cognos Knowledgebase, the suggestion I have would be to run all impromptu reports via a macro. You can at least 'sell' the idea by mentioning the added value that macros offer - dated output, email of results, conditional action, report post-processing.

If you run Impromptu in single user mode, so that only one instance runs at a time, does that help or hinder performance?



soi la, soi carré

 

[ClayT]

With the number of users we have using Impromptu, and IT wanting to switch to a different reporting solution, I doubt I'll have many takers on the idea of running all reports via a macro. Folks just want to open the report with Impromptu, get their data, and move on.

We still fail to understand why Admin handles the macro properly, and why User cannot. At one point I thought it may be the logged in user's rights, but I logged in myself (domain admin) and got the same results. I have Admin loaded on my PC and Impromptu closes properly after each run.

We have just tried setting Impromptu into single user mode and it appears to only open and use one window now, this is a great improvement - thank you - but the original problem still perplexes me!

Clay