Error #438. Input at line #138

[stewm]

Hey folks, I'm having a bit of a problem with a macro. Has any one ran into similiar behavior? The macro seems to die with the following error...

runmac32
Error #438. Input at line #138.

then...

page34.mcx
Error code: -1003
"Error exception not handled by program"

Line #138...
Set ObjImprep = objImpApp.OpenReport(rName,StrPrompt)
Line #139...
ObjImpRep.RetrieveAll

Thanks




Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada

http://www.consultantsclub.biz

 

[CognosTechUser]

Hi Mark,

Without seeing the rest of your macro, I'll guess that the macro loops through a folder containing reports. Each report is opened and passed the prompt value.

If this is indeed the case, are you setting the report object to nothing each time you are finished with it?

ie: objImpRep.Close
Set objImpRep = Nothing

Also, monitor your memory usage of the Impadmin.exe or Impuser.exe process in Task Manager to see if the size is growing. If so, this would be an indication that you have a memory leak in your macro.

/Roland