dc_Array2Excel Error

[Stuart.Fraser]

Hi Roger,

Strange Error with dc_Array2Excel.

This is established code that has been running for years. I've been running it on the same box for years as well.

Suddenly yesterday if I log in and run any routine that is calling dc_Array2Excel I get an automation object error setting the orientation property of the PageSetup class. If however another analyst logs in with different credentials to the same box and runs the same software it works for them.

Error log is attached. Obviously I'm guessing something profile wise on the box but could use any clues available as to what to even be looking for.

thanks

Hmm.
Cannot seem to attach a file. Error Log content below:

==============================================================================
ERROR LOG of "C:\Program Files\Ministry of Health\HARSP\hars1.exe" Date: 2013-09-26 11:48:15
------------------------------------------------------------------------------
Xbase++ version : Xbase++ (R) Version 1.90.355
eXPress++ version : eXPress++ (c) Version 1.9.252
Operating system : Windows XP 05.01 Build 02600 Service Pack 3
Database path : Program Files\Ministry of Health\HARSP
Default Directory : R:\internal\IARS\Prod\Data\
Current Directory : C:\Program Files\Ministry of Health\HARSP
Todays Date : 2013-09-26
App Version : 1.60.07
Data Set : HSRC2013
Rate Set : Default
------------------------------------------------------------------------------
ERROR OBJECT:
------------------------------------------------------------------------------
oError:args :
-> VALTYPE: C VALUE: Orientation
-> VALTYPE: N VALUE: 2
oError:canDefault : Y
oError:canRetry : N
oError:canSubstitute: Y
oError:cargo : NIL
oError:description : Unable to set the Orientation property of the PageSetup class
oError:filename : NIL
oError:genCode : NIL
oError:operation : Orientation
oError:osCode : -2146827284
oError:severity : 2
oError:subCode : 6500
oError:subSystem : Automation
oError:thread : 1
oError:tries : NIL
------------------------------------------------------------------------------
CALLSTACK:
------------------------------------------------------------------------------
Called from AUTOMATIONOBJECT:ONERROR(1344)
Called from ASCOMERROR:RAISE(324)
Called from ASCOMERROR:RAISEERROR(593)
Called from ASCOMERROR:RAISEONERROR(672)
Called from AUTOMATIONOBJECT:SETNOIVAR(1146)
Called from DC_ARRAY2EXCEL(4036)
Called from SAVERESULTS(353)
...
Stu

[rdonnay]

This is very strange.

Did you try rebooting that computer?

[Stuart.Fraser]

Hi Roger,

Yes I did reboot that computer. Strangely, if I have another developer log into the computer it works just fine. I had rather forgotten about this issue until this morning when I logged into that computer and tried again only to have the same error.

For the purpose of getting this work done I will get the other developer to try again but this is very strange.

Any ideas are appreciated.

Thanks

Stu

[Koverhage]

Maybe this help.

Orientation should 0 or 1 not 2.
So if you use
XBPPRN_ORIENT_LANDSCAPE
XBPPRN_ORIENT_PORTRAIT
it should be
XBPPRN_ORIENT_LANDSCAPE -1
XBPPRN_ORIENT_PORTRAIT - 1