Multiple Cognos Impromptu Sessions on scheduler

[marys1]

Hi,

I have various reports set up on scheduler to run over night and as each report begins it automatically opens a new session of Impromptu. When this occurs over the weekend it causes problems, filling up the taskbar and an error occurs with the report not running. Is there any way of eliminating these multiple sessions of Impromptu.

 

[drlex]

Yes:
go to the command prompt and type:
C:\Program Files\Cognos\cer3\bin\impadmin.exe /si
to switch to single instance mode (assuming the standard installation pathway for 7.1)

Use /mi for multiple instance.

(if you are running 7.3 , then substitute cer4)

If you use macros to run a report, you can force Impromptu to close afterwards.

soi la, soi carre

 

[DoubleD]

drlex is correct. Here's a little more detail about his suggestion though.
If you switch to single instance mode, your reports can only run consecutively (one at a time). By running a macro that launches the report, then closes Impromptu when it's done, you can still have multiple reports running simultaneously, but Impromptu will clean itself up as each report finishes.

I am what I am based on the decisions I have made.

DoubleD

 

[drlex]

Thanks DoubleD,
Note that if you are using Cognos Scheduler, then the tasks run consecutively; you need to use the OS scheduler to make cogonos run reports concurrently.

soi la, soi carre

 

[npresto]

I'm having the same problems with Scheduler leaving multiple instances of Impromptu open on my desktop.
I was looking for an example of a macro that would call and run a report and close Impromptu when the report has been saved.

If anyone has an example of a macro, I'd be grateful?

npresto

 

[drlex]

npresto,
Check out the pdfs that are in the documentation folder and the help file in the cognos script macro editor.
Here's an example that opens a catalogue, then a report and saves an iqd before closing.

Sub Main()
   
   Dim objImpApp As object
   Dim objImpRep As Object
   
   Set objImpApp = CreateObject("CognosImpromptu.Application")
   objImpApp.Visible 1
   objImpApp.OpenCatalog "c:\catalogues\mycatalogue.cat","Creator",,,,1

   Set objImpRep = objImpapp.OpenReport("C:\Reports\Open items.imr")
   Set objImpRep = objImpApp.ActiveDocument
   objImpRep.Export "C:\iqd\Open Items.iqd", "x_iqd.flt"
   objImpRep.CloseReport    
   objImpApp.Quit
   Set objImpRep = Nothing
   Set objImpApp = Nothing   
   
End Sub

soi la, soi carre