Impromptu Scheduler in Disconnected Citrix Session

[JackHorlock]

I have a client trying to run a Macro that in turn runs a series of Impromptu reports using the Impromtu Scheduler. This works fine in an open Citrix session. However, my client wishes to leave the scheduler processing his reports in the Citrix session after he has disconnected from it. All Citrix sesion timeouts are set so that he can re-connect to his session after several hours and we find that scheduler has run the macro. He is not logging out of his session, just disconnecting.

The problem is that the macro reports an 'Object not found' error on all the reports it is trying to run. This does not happen when the session is connected, just disconnected.

Any suggestions?

 

[drlex]

JackHorlock,
Would it be possible for you to post the macro (or relevant section) that the error references?


soi la, soi carré

 

[JackHorlock]

Here's the latest version of the macro; we've tried several different versions all with the same result

Sub Main()
Dim ImpApp as Object
Dim ImpRep as Object
Dim ImpExcelRep as Object
Dim ImpPath as String
Dim ReportName as String
Dim MsgText, userfile
Open "T:\Impromptu Macros\ErrorText.txt" For Output As #1
On Error GoTo Debugger
Set ImpApp = CreateObject("Impromptu.Application")
ImpApp.Visible 1
ImpApp.OpenCatalog "T:\Test Reports V4.0\EliteUK6next.cat","Creator"

Rem ****** PAY024 - Advances *******
ReportName = "PAY024 - Advances.imr"
Set ImpRep = ImpApp.OpenReport ("T:\UK Reports\Ronnie\To Be Signed Off\Signed Off\PAY024 - Advances.imr")
ImpRep.Visible 1
Set ImpExcelRep = ImpRep.PublishExcel
ImpExcelRep.Version 0
Rem ImpExcelRep.ExportOptions 15
ImpExcelRep.Publish "T:\Impromptu Macros\PAY024 - Advances.xls"
ImpRep.SaveAs "T:\UK Reports\Ronnie\To Be Signed Off\Signed Off\PAY024 - Advances.imr"
ImpRep.CloseReport

Rem ***** PAY020 - Miscellaneous Deductions *****
ReportName = "PAY020 - Miscellaneous Deductions.imr"
Set ImpRep = ImpApp.OpenReport ("T:\UK Reports\Ronnie\To Be Signed Off\Signed Off\PAY020 - Miscellaneous Deductions.imr")
ImpRep.Visible 1
Set ImpExcelRep = ImpRep.PublishExcel
ImpExcelRep.Version 0
Rem ImpExcelRep.ExportOptions 15
ImpExcelRep.Publish "T:\Impromptu Macros\PAY020 - Miscellaneous Deductions.xls"
ImpRep.SaveAs "T:\UK Reports\Ronnie\To Be Signed Off\Signed Off\PAY020 - Miscellaneous Deductions.imr"
ImpRep.CloseReport

ImpApp.Quit
Set ImpExcelRep = Nothing
Set ImpRep = Nothing
Set ImpApp = Nothing
Close #1
Exit Sub
Debugger:
MsgText=ReportName & " Error number " & Err & " : " & Error & _
" occurred at line: " & Erl
Print #1, MsgText
Resume Next
End Sub

 

[drlex]

OK, thanks for that.
What is the Error line that is reported in your debugger?

soi la, soi carré

 

[JackHorlock]

Here's the error messages:

PAY024 - Advances.imr Error number 438 : no such property or method occurred at line: 16
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 17
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 18
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 19
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 21
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 22
PAY024 - Advances.imr Error number 91 : Object value is set to Nothing occurred at line: 23
PAY020 - Miscellaneous Deductions.imr Error number 438 : no such property or method occurred at line: 27
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 28
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 29
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 30
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 32
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 33
PAY020 - Miscellaneous Deductions.imr Error number 91 : Object value is set to Nothing occurred at line: 34
PAY020 - Miscellaneous Deductions.imr Error number 438 : no such property or method occurred at line: 36

 

[xs4citrix]

A disconencted Citrix session freezes all processes from that user, so the behaviour on this client side application running on a citrix server is not surprising.
Have the user run the macro's as a "run as" using another domain or local account.
Then have him disconnect his session

(disconnecting is comparable to shutting down the engine, while going 80 on the freeway; the car will not do another mile)

Stefan

http://www.printingsupport.com