Windows error 0x80020009, -2147352567

Detailed Error Information

DISP_E_EXCEPTION[1]

MessageException occurred.
Declared inwinerror.h

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode2 (0x002)
NameFACILITY_DISPATCH[2][1]
DescriptionThe source of the error code is a COM Dispatch.[2][1]
Error Code9 (0x0009)

Questions

73votes
5answers

Is there a limit on an Excel worksheet's name length?

When I try to set a longish worksheet name using ruby and win32ole with the following code: require "win32ole" excel = WIN32OLE.new('Excel.Application') excel.Visible = 1 puts excel.version workbook = excel.Workbooks.Add worksheet1 = workbook.Worksheets.Add worksheet1.Name = "Pseudopseudohypoparathyroidism" #Length 30, fine worksheet2 = workbook.Worksheets.Add worksheet2.Name = "Supercalifragilisticexpialidocious" #Length 34, not fine I [...] read more
excel
26votes
7answers

Registering a dll returns 0x80020009 error

I am trying to register with regsvr32.exe the prnadmin.dll (on a Win7 target machine) but i get this error 0x80020009 Any suggestions please? read more
dll
windows-7
7votes
3answers

Registering a .NET assembly in a COM+ application outside of the GAC

I developed a .NET assembly (.NET 4.0, strong-named) which exposes two Serviced Components. The assembly (dll) is supposed to be hosted in a COM+ application and it is decorated with the COM+ attributes (assembly & component levels). For example, the assembly level attributes: //COM+ Attributes [assembly: ApplicationID("MY_APP_GUID")] //GUID of the [...] read more
.net
wix
windows-installer
com+
servicedcomponent
6votes
1answer

Problems calling IConnectionPointImpl interface from C++ invoked via modal WinForms

We have a native C++ application which supports some VBA macros of various types over COM. One of these types, VBAExtension, registers itself with the core C++ application, resulting in an instance of (a class derived from) IConnectionPointImpl<Extension, &DIID_IExtensionEvents, CComDynamicUnkArray>. This works fine; both core and other VBA macros can [...] read more
c#
c++
vba
com
iconnectionpoint
3votes
0answers

WiX 3.11.2 and .NET 4.7.2 COM+ applications

I am trying to install .NET Framework 4.7.2 developed COM+ component using WiX 3.11.2. And it fails doing this with the following error in the log: > Action 14:38:48: RegisterComPlusAssemblies. Registering COM+ components > > RegisterComPlusAssemblies: DLL: C:\Program Files > (x86)\WiXTestingComPlusApplication\NET472ServicedComponent.dll > > ComPlusInstallExecute: ExceptionInfo: Code='0', > Source='System.EnterpriseServices', Description='Failed to [...] read more
.net-4.0
wix3.11
3votes
1answer

How do I run an Excel macro from Ruby?

Problem I have this ten something year old Excel workbook with a gazillion lines of VBA code in it some of which I have to update. So I had this crazy idea of writing unit tests in Ruby... Question How can I call an Excel macro from Ruby? What I [...] read more
ruby
unit-testing
excel
vba
3votes
1answer

Need help in Calling fox pro program from c# code

I need some help on calling foxprogram from c# code. We have dedicated machine where we have fox releated program. Machine Name : TestFox We have shared folder \\TestFox\FoxPrograms I need to call init.prg which is present in \\TestFox\FoxPrograms [It is built in vfp9] I used the below code try [...] read more
c#
foxpro
3votes
2answers

Wix - ComPlusAssembly - Could not install type library

I'm new to Wix and I have ran into a problem that I'm obviously not able to solve on my own, so any help will be very much appreciated. Quick background: I'm representing a software vendor building a comprehensive suite of SOA based applications for deployment in large enterprises. Our [...] read more
assemblies
wix
com+
3votes
2answers

Force the browser to end the current step

NEED: Using Cucumber 1.0.1 and Watir 1.9.2, I need to execute javascript code in order for a proprietary portal to do some navigation. ISSUE: I am able to execute JS code with the following: def execute_js(js_code) @browser.goto("javascript:#{js_code};void(0)") end execute_js("doNavigate()") By doing so, the navigation is done as expected but Watir [...] read more
javascript
cucumber
watir
3votes
0answers

How do I debug scripts that use win32ole?

How do I debug scripts that use win32ole? For example, I found via trial and error that the following Ruby script doesn't work because excessively_long_range is too long: require "win32ole" # Boring initialization stuff excel = WIN32OLE.new('Excel.Application') excel.Visible = 1 workbook = excel.Workbooks.Add worksheet = workbook.Worksheets.Add # Relevant part excessively_long_range [...] read more
ruby
debugging
win32ole
3votes
1answer

Uploading file in sharepoint library throws an unhandled exception(hresult: 0x80020009, errorcode: -2147352567) with empty error message

I m using following code sample to upload multiple files (using sharepoint Object Model, no webservice) in a document library, but some times it throws exception hresult: 0x80020009, with error code -2147352567 and error message is empty (empty string) while file is upload successfully to the document library. And mostly [...] read more
sharepoint
file
exception
upload
2votes
2answers

Error while creating shortcut button C#

I'm trying to have a button that once you press it, it will create a shortcut. Any time I press the button I am getting an error An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred Additional information: Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) Can anyone see why this is happening? [...] read more
c#
2votes
3answers

Using CAML to compare SharePoint "Person or Group" fields

I have a SharePoint 2007 (MOSS) list with 2 "Person or Group" columns which I would like to compare, essentially: SELECT * FROM List WHERE (Analyst = Developer) In my code (C#) I've built this as: SPQuery itemQuery = new SPQuery(); itemQuery.Query = "<Where><Eq><FieldRef Name='Analyst' /><FieldRef Name='Developer' /></Eq></Where>"; SPListItemCollection queryResults [...] read more
sharepoint
sharepoint-2007
caml
2votes
3answers

Ruby program with win32ole does not work any more under Windows7 64bit

I have an old ruby program that extracts values from an excel file and stores the summary in another excel file. For that purpose, the program uses the library win32ole from Ruby. After switching to a new computer with Windows 7 64bit (instead of Windows XP 32bit), Office 2007 instead [...] read more
ruby
excel
win32ole
2votes
0answers

Unable to create sharepoint site from migrated site template(.wsp)

I have subsite (sharepoint2010) which consist of some custom feature and which has been migrated from sharepoint 2007, I save this site as a site template (in dev environment), when I try to create a site base on that site template in production (it is havig all the updated solution) [...] read more
sharepoint
2votes
2answers

Passing connection string properties when using DTEXEC

I am wondering what the correct format is for passing connection string properties on the command line when using dtexec: dtexec.exe /Ser IpAddress\Instance /IS "\SSISDB\Data Warehouse\MyProject\MyPackage.dtsx" /DumpOnError /Set \Package.Variables[DW_ConnectionString].Properties[Value];\""Data Source=IpAddress;Initial Catalog=DWDB;Provider=SQLNCLI10.1;IntegratedSecurity=SSPI;"\" I have defined the above command line configuration where I am attempting to pass override properties for the default [...] read more
ssis
sql-server-2012
2votes
10answers

What's wrong with this ASP recursive function?

When I call this function, everything works, as long as I don't try to recursively call the function again. In other words if I uncomment the line: GetChilds rsData("AcctID"), intLevel + 1 Then the function breaks. <% Function GetChilds(ParentID, intLevel) Set rsData= Server.CreateObject("ADODB.Recordset") sSQL = "SELECT AcctID, ParentID FROM Accounts [...] read more
asp-classic
vbscript
ado
2votes
2answers

Failed to initialize COM object

I have created a web application in ASP.NET using VB.NET as code behind file. I am using a COM object of ProvideX.Script class to connect to Sage MAS90 ERP. Everything was working fine in visual studio 2010. Now when I moved to the deployment phase, the problem gets started.... I [...] read more
asp.net
vb.net
com
iis-7
windows-server-2008
2votes
2answers

Can add my custom webpart but then cannot modify any webpart on page

I`v made my webpart that works well (I can add it to page and use it). However if i want to move it to different zone or modify ANY other webpart on that page i get an exception. Any ideas on what could be wrong? Maybe it has to do [...] read more
sharepoint
moss
wss
2votes
1answer

Ruby:Watir cannot connect to IE running under non-Admin account on 'default' desktop

Some Background on architecture of the app is needed: Windows 2003/Apache-v2.2/IE7/Watir-v1.6.2/Ruby-v1.8.5 1. Apache running under 'localsystem' account. 2. Request to run a Watir script comes in. 3. Apache CGI kicks off IE7 under a particular user, e.g. 'tester', and attaches the IE7 window to the "default" desktop environment. This allows [...] read more
windows
ruby
watir
1vote
1answer

How to create a desktop shortcut (link), but with own shortcut file extension (e.g. .appfolder) instead of .lnk programmatically in C#?

I have registered a shortcut file extension named .appfolder in registry: reg export It should behave like a normal .lnk shortcut, but has to have .appfolder ending (that has it reasons). Now I want to create an shortcut with that file ending/extension programmatically in C#. Default for .lnk ending it [...] read more
c#
registry
desktop
shortcut
file-extension
1vote
1answer

Would this method of installing COM+ work?

I've been trying to use WiX 3.7 to install a COM+ assembly. I've been using several WiX code snippets I found here on StackOverflow. Although I can generate an MSI, when I then install the msi it fails with errors that look like this: RegisterComPlusAssemblies: DLL: C:\Program Files\Kutana\Kappris\Carson.dll ComPlusInstallExecute: ExceptionInfo: [...] read more
wix
installation
windows-installer
com+
1vote
2answers

Restoring snapshot in virtualbox using pyvbox

I want to write a code which restores a specific snapshot on a specific virtual machine using pyvbox. I have this: def readSnap(mach_name): vbox = virtualbox.VirtualBox() vm = vbox.find_machine(mach_name) snap = vm.restore_snapshot() But the last line throws: virtualbox.library_base.VBoxError: 0x80020009 (Method Machine::restoreSnapshot is not implemented) And I am quite confused about [...] read more
python
automation
virtual-machine
virtualbox
1vote
2answers

cannot send email via outlook in ruby

I have a script where the syntax works using irb but not via the ruby program. The script fails at the message1.Send line. However this syntax works when I execute it under irb. **P:/RubyAutoEmail.rb:23:in `method_missing': (in OLE method `Send': ) (WIN32OLERuntimeError)** OLE error code:4096 in Microsoft Outlook Outlook does not [...] read more
ruby
email
outlook
ole
1vote
1answer

C# Running Active Automation Object - How to Source events?

I have a (long running) console application, written in C#, which I want to be able to manipulate through COM (so no InProc DLLs and regasm.exe). IDispatch is all I need - so a classic OLE Automation object. Here I'll present a minimal version of what I try to do. [...] read more
c#
com
ole-automation
active-objects
running-object-table
1vote
1answer

Unusual Message Source Name in SSIS standard Report

Usually, in a dtsx Standard Report, there is a column "Message Source Name" that indicates which dtsx threw the error or raised the event. Now i get "Transact-SQL stored procedure" and of course I don't have such a dtsx. So, question #1 is: Where should I go to check the [...] read more
ssis
connection-string
1vote
3answers

Windows Update Chef Recipe

I am attempting to use the following chef recipe to download and install windows updates on a windows 2008 R2 machine in the Amazon cloud: https://github.com/dougm/site-cookbooks/blob/master/windows/recipes/update.rb. I am using Chef 11.8.0 but the chef run fails with the following error: Recipe Compile Error in c:/chef/cache/cookbooks/test/recipes/updates.rb WIN32OLERuntimeError -------------------------------------------------------------------------------- (in OLE method [...] read more
windows
chef-infra
1vote
1answer

passing xsl variable to javascript function

Using a date:difference funtion from exslt.org date.msxsl.xsl with msxsl. If I use string literals, then the function works fine. But if I grab the strings from the xml file and put them into variables, and then use those variables for the 'difference' function, I get the following error: msxsl.exe dummy.xml [...] read more
javascript
function
variables
xslt
msxsl
1vote
4answers

SPSiteDataQuery throwing exception while setting it's Query property

I am querying multiple task lists in a SharePoint site. I can retrieve the results until I set the Query property and specify the OrderBy clause. The detailed exception and code is pasted below. Appreciate any help private void doTasks(SPWeb currentWeb, SPSiteDataQuery q) { q.Query = "<OrderBy>" + " <FieldRef [...] read more
sharepoint
1vote
1answer

Using `gets` for file path

I'm writing a script to edit an excel file. I'm testing if it collects information from a user. require 'rubygems' require 'win32ole' print "filpath?" $filepath = $stdin.gets print "sheet?" $sheetname = $stdin.gets excel = WIN32OLE.new('Excel.Application') excel.visible = true workbook = excel.workbooks.Open($filepath) worksheet = workbook.Worksheets($sheetname) worksheet.Cells(2,2).Value = 10 workbook.saved = true [...] read more
ruby
1vote
4answers

opening powerpoint presentations in ruby via win32ole

I've got this piece of code that works for Excel. require 'win32ole' excel = WIN32OLE.new('Excel.Application') excel.visible = true workbook = excel.Workbooks.Open('c:\file.xls'); But I have trouble getting the same thing done with for PowerPoint; This piece of code: require 'win32ole' ppt = WIN32OLE.new('Powerpoint.Application') ppt.visible = true presentation = ppt.Presentations.Open('c:\file.pptx'); Generates this [...] read more
ruby
powerpoint
win32ole
1vote
0answers

WMIC throwing an Description = exception occured when trying to retrieve users in table format

I'm trying to extract list of the users (name and description fields) into a text file. This used to work fine until recently. This is a Windows 8.1 64bit machine which is being used as server and has a few thousand user accounts. The command I'm running is: wmic USERACCOUNT [...] read more
wmic
1vote
0answers

Get lnk shortcut target from public (all users) folder without elevating admin privileges

I am looking for a way to read lnk shortcut target, when this one locates in public folder such as: > C:\ProgramData\Microsoft\Windows\Start Menu\Programs\StartUp I tried to use following: 1. Interop.Shell32.FolderItem.GetLink - it throws an exception ( Why do i get E_ACCESSDENIED when reading public shortcuts through Shell32? ) 2. IWshShortcut [...] read more
c#
.net
windows
shortcut
1vote
1answer

Add Domain User Account to Local Group Windows Puppet

I am trying to set a windows domain user account to the local administrators group that according the puppet documentation is possible. user { 'DOMAIN\user': groups => ['Administrators'], } I tried using the SID with no results. I am using the latest Puppet 2.7.19 err: /Stage[main]/Teamcity_base/User[S-1-5-21-1759977473-2015113658-625696398-26 038]/ensure: change from absent [...] read more
puppet
1vote
1answer

Using WMI to get printer logs

I'm trying to use WMI to get printer system logs from several servers. A week ago I made the following code which for some reason only works sometimes: wmic /node:<servername> NTEvent WHERE "logfile='System' AND SourceName='Print' AND TimeGenerated > '20130219'" get EventCode,TimeGenerated,Message This line of code sometimes will work, but the [...] read more
powershell
scripting
wmi
1vote
2answers

OLE error code 80020101 caused by execute_script of waitr

I just tried this:$browser.execute_script("alert(\"aaa\")") and then I get the error below: h:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.2.0/lib/watir-classic/page-container.rb:46:in `method_missing': (in OLE method `execScript': ) (WIN32OLERuntimeError) OLE error code:80020101 in <Unknown> Could not complete the operation due to error 80020101.HRESULT error code:0x80020009 Exception occurred. from h:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.2.0/lib/watir-classic/page-container.rb:46:in `rescue in execute_script' from h:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.2.0/lib/watir-classic/page-container.rb:39:in `execute_script' Am I missing install something? read more
watir
ole
1vote
1answer

Watir : Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus

I'm new to watir and currently using it for automating an application , however I'm stuck at one error when I try click a button. Watir code looks like this : $browser.button(:id,"Button_one").click html for button looks like this: <input id="Button_one" class="ButtonA ButtonB" type="submit" value="Continue">. error displayed is: WIN32OLERuntimeError: (in OLE [...] read more
ruby-on-rails
ruby
ruby-on-rails-3
selenium-webdriver
watir
1vote
1answer

Reading MSMQ message count with ruby

I've got a problem querying the message count from the remote msmq queue. This is my code: def get_message_count mq_management = WIN32OLE.new('MSMQ.MSMQManagement') mq_management.Init('xxx.yyy.zz.aa', nil,'direct=tcp:xxx.yyy.zz.aa\private$\inbox') message_count = mq_management.MessageCount end xxx.yyy.zz.aa is the IP Address of the remote computer. This method actually works as a charm, BUT: 1. if the queue is [...] read more
ruby
msmq
windows-server
1vote
3answers

I am having problems with a line of ASP code involving response.write

Ok folks, I am trying to write a line of code in Classic ASP for a button that will trigger it to go to another page with a querystring variable. However I am having difficulties getting this to work. Here is my code so far: response.write "<td valign='top'><input type='button' name='cmdUpdateInfo' [...] read more
asp-classic
vbscript
1vote
1answer

I am checking script for exception but got some errors can anyone help?

Below is the code.... require 'watir' @ie = Watir::IE.new @ie.goto 'http://asdfasdf.com' begin @ie.check_for_http_error rescue Watir::Exception::NavigationException => e puts "Page did not load: #{e}" end require 'watir/contrib/page_checker' @ie.add_checker(PageCheckers::NAVIGATION_CHECKER) begin @ie.goto "http://marekj.com/asdfasdfasdfa" rescue Watir::Exception::NavigationException => e puts "Page did not load: #{e}" end I run above code but it is showing an [...] read more
ruby
http
exception
watir
1vote
1answer

VSTO Outlook 2007 Addin Startup throws System.Runtime.InteropServices.COMException (0x80020009): Cannot complete the operation. You are not connected

We are building an Outlook 2007 add-in using VSTO. We have code in the initialization logic of the addin which retrieves the MAPIOBJECT associated with the Application.Session. The code in question is as follows: public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { try { var addIn [...] read more
c#
com
outlook
vsto
mapi
1vote
0answers

Sharepoint 2010 error after uploading files do share document library

After uploading folder using standard sharepoint web interface I am unable to get into my site. How to remove docs I added from sql server (no backup...) ? <nativehr>0x80020009</nativehr><nativestack></nativestack> Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information [...] read more
sharepoint-2010
0votes
0answers

i tried to register netshell.dll failed in windows xp

I cannot open my localconnection's properties, so I tried to register the netshell.dll file, but got a dllregisterserver failed, return code is 0x80020009 error. When I used regsvr32 netshell.dll /u, it worked. After that, I use regsvr32 netshell.dll again, got that dllregisterserver failed, return code is 0x80020009 error again, somebody [...] read more
windows-xp
local-area-network
0votes
0answers

Using Octave to run Excel macro (from personal workbook)

I'm following the methods of this Mathworks post (but using Octave 6.2.0 instead of Matlab) https://www.mathworks.com/matlabcentral/answers/100938-how-can-i-run-an-excel-macro-from-matlab to open an Excel file (Office 365 version) and execute a macro. It works very well to a point (i.e. on a test Excel file containing a test macro). However, in practice I'm using [...] read more
excel
vba
octave
export-to-excel
0votes
0answers

Can Somebody Help me out with this SOAP Error description

#Software: Microsoft Internet Information Services 10.0 #Version: 1.0 #Date: 2021-01-27 10:55:01 #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status time-taken 2021-01-27 10:55:02 192.168.1.1 POST /Honeywell/WebServices/WebDataAccess.asp +SOAP+ERROR:+SoapServer.SoapInvoke+failed.+WSDLOperation:Executing+method+ReadRequest+failed+HRESULT=0x80020009 80 PCNGATE\BizTalk 192.168.1.15 - - 500 0 0 296 Question: Here we are sending a SOAP message [...] read more
vb.net
iis
soap
wsdl
webserver
0votes
0answers

How to handle "0x80020009" while trying to load an ActiveX control?

I'm working in Progress-4GL, release 11.6, working with appBuilder and procedure editor. I'm trying to put an OCX DTPicker on a window, which results in following code (±automatically generated by appBuilder): DEFINE VARIABLE OCX_orderingDate AS WIDGET-HANDLE NO-UNDO. DEFINE VARIABLE chOCX_orderingDate AS COMPONENT-HANDLE NO-UNDO. ... PROCEDURE control_load : /*------------------------------------------------------------------------------ Purpose: Load [...] read more
registry
activex
openedge
progress-4gl
ocx
0votes
2answers

Microsoft.Office.Interop.Outlook._Items.SetColumns(String Columns) Issue

We have an Outlook add-in that's been in the field for a while now and seems to be stable. However, we're seeing this strange behavior on one of our non-US client's machine. Here is the code: items.SetColumns( "[CreationTime], [Subject], [Start], [End], [Importance], [LastModificationTime], [IsRecurring], [BusyStatus], [MeetingStatus], [ResponseStatus], [Sensitivity], [Duration]"); And [...] read more
c#
outlook
outlook-addin
0votes
0answers

Exchange Server 2010 to 2016 upgrade - GetSharedMailbox

We are upgrading our Exchange Server from 2010 to 2016 and have some issues changing our redemption code. What we do with Exchange Server 2010 is: LogonExchangeMailbox (with a user that has access to other mailboxes) GetSharedMailbox (mailbox that we want to send the mails from) GetDefaultFolder(16):Items:Add from that mailbox [...] read more
outlook-redemption
0votes
0answers

Delete unwanted users\groups apart from the mentioned users\groups in the puppet manifest

I am trying to delete all the unwanted groups\users or apart from default groups\users mentioned in my manifest related to built in group " administrator" in the windows machine but no luck, its throwing error as mentioned below when i run "puppet agent -t" command from the agent. error: Error: [...] read more
windows
puppet
puppet-enterprise
0votes
1answer

Equivalent of selectNodes and selectSingleNode in JS

I have a old JS code, but i didn't find the equivalent of some JS old function. * selectNodes * selectSingleNode Here is the code : function getFunctionProto( elem ) { var s = ""; s += elem.getAttribute('name'); s += "("; var oCat = elem.selectSingleNode( "ancestor(CATEGORY)" ); var lParams = [...] read more
javascript
0votes
0answers

MSXML2.ServerXMLHTTP.6.0 send request - The connection with the server was terminated abnormally - win7

I have some code in an ERP system, going through a .Net wrapper calling a REST API. It is a JSON API. My code does not make sense to post directly since it is inside the ERP system. But the code is somewhat like this below. Strange thing is, that [...] read more
.net
rest
msxml
0votes
1answer

Why Batch Process not working by Task Scheduler User Administrator?

I have a process for ETL, in a .bat file wich: * copy .xlsx file to a directory * open the excel file by progress * copy the information to progress database When I run the .bat file by the user: TableauAdmin in the explorer: * it works fine ! [...] read more
batch-file
task
administrator
taskscheduler
0votes
0answers

COleDispatchDriver::Invoke in MFC app causing 61706 "Insufficient Memory" Exception using VS2013?

I have an MFC C++ application running on Win7 rebuilt with VS2013. It uses a custom OCX control. On about the 4th call to the OCX the COleDispatchDriver::InvokeHelper method calls Invoke which results an exception 61706 "Insufficient Memory". This app has been built and run successfully for many years on [...] read more
mfc
out-of-memory
invoke
ole
coff
0votes
0answers

Weird System.Runtime.InteropServices.COMException

Visual Studio 2017 Community, VB.NET, Windows7 This is what I get: System.Runtime.InteropServices.COMException: '[FireDAC][DatS]-32. Variable length column [Version] overflow. Value length - [71], column maximum length - [10]' Details: System.Runtime.InteropServices.COMException occurred HResult=0x80020009 Message=[FireDAC][DatS]-32. Variable length column [Version] overflow. Value length - [71], column maximum length - [10] Source=AllSkyPlateSolver.PlateSolver StackTrace: at AllSkyPlateSolver.IPlateSolver.PlateSolve(String [...] read more
vb.net
0votes
1answer

0x80020009 OLE Exception accessing any number other than 0

So I'm using COM to access a third party program, I use the following Method to acquire property from server: HRESULT ConnectToHYSYS::OLEMethod(int nType, VARIANT * pvResult, IDispatch * pDisp, LPOLESTR ptName, int cArgs...){ if (!pDisp) return E_FAIL; va_list marker; va_start(marker, cArgs); DISPPARAMS dp = { NULL, NULL, 0, 0 }; [...] read more
c++
com
ole
0votes
1answer

ifnull not enough for testing for numerical rs

I have a function, which is supposed to return zero, if the input cannot be converted to an integer. But sometimes it fails, if the field from a resultset is not a proper value, whatever it is. Function nulblank(str) dim val if IsNull(str) then val=0 else str = trim(str) if [...] read more
asp-classic
0votes
1answer

xslt multiple parameters into javascript

Im trying to create a function in javascript in xsl which accepts multiple in-parameters. I can not get it to work and get the following error: Code: 0x80020009 Microsoft JScript runtime error Wrong number of arguments or invalid property assignment line = 37, col = 2 (line is offset from [...] read more
xslt
xslt-1.0
0votes
1answer

Command Prompt error since i am using a generic path to open an excel file

Command Prompt its not working since i am using a generic path to open a excel file. Here is the error message: > T:\PointOfSale\Projects\Automated Testing\TASWeb\TP\TP_Branch>ruby -rubygems > Tes tTP_UK.rb TestTP_UK.rb:19:in 'method_missing': (in OLE method `Open': > )(WIN32OLERuntimeEr ror) OLE error code:800A03EC in Microsoft Excel > './../../../MasterFile.xls' could not be found. [...] read more
ruby
win32ole
0votes
2answers

Issue with execute_script

I am running watir-classic 3.3.0 with the following configuration: * ruby 1.9.2p290 * watir-classic 3.3.0 * Windows XP Service Pack 3 * IE 8 When I try to execute the following script on one of the pages I am testing, I get an error @browser.execute_script "window.confirm = function() { return [...] read more
ruby
watir
watir-classic
0votes
1answer

Chef Selenium: WmiLite:WmiException on Windows Server 2008

On Windows 2008 & 2008 R2 the following exception is thrown during Chef selenium_node installation: FATAL: WmiLite::WmiException: An error occurred connecting to the WMI service for namespace 'root/cimv2'. The namespace may not be valid, access may not be allowed to the WMI service, or the WMI service may not be [...] read more
selenium
wmi
chef-infra
selenium-grid
0votes
2answers

Watir command to attach browser window does not work in radrails ide

I use the radrails ide for running watir tests. I have the following command: ie.link(:text, "Task").click ie1=Watir::IE.attach(:title, 'Task') Using the above command I get the error: E:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.0.0/lib/watir-classic/ie-class.rb:760:in `rescue in attach_browser_window': Unable to locate a window with title of Task (Watir::Exception::NoMatchingWindowFoundException) from E:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.0.0/lib/watir-classic/ie-class.rb:755:in `attach_browser_window' from E:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.0.0/lib/watir-classic/ie-class.rb:157:in `_attach_init' from E:/Ruby193/lib/ruby/gems/1.9.1/gems/watir-classic-3.0.0/lib/watir-classic/ie-class.rb:151:in `attach' from [...] read more
watir
title
radrails
0votes
1answer

Issue on Dll Register after migrating the project from **VS 2012** to **VS2013**

I`m having a Issue on Dll Register after migrating the project from VS 2012 to VS2013 Actually Im working on a custom project, were we qualify our application on each visual studio version, previously we did a migration for VS 2010 to VS 2012, during which there was no issues [...] read more
c++
visual-studio-2012
dll
visual-studio-2013
migration
0votes
2answers

WIN32OLERuntimeError: occurs while accessing a hidden textbox using Watir Script.how to overcome it?

This is the error I get when I try to access a hidden textfield in the webpage. I am navigating through the page using irb(main):184:0> browser.text_fields[1].set "Hey man" WIN32OLERuntimeError: (in OLE method 'focus': ) OLE error code:800A083E in htmlfile Can't move focus to the control because it is invisible, not [...] read more
watir
0votes
2answers

Adding chart in PowerPoint using C++ OLE automation

i've encountered a problem when tried to add chart to PowerPoint in C++ AutoWrap(DISPATCH_METHOD, NULL, pShapes, L"AddChart", 0); It throws "0x80020009 Exception occured" error. That code works for AddTable, AddTextbox etc. read more
c++
com
automation
powerpoint
ole
0votes
0answers

SharePoint Designer: Microsoft.SharePoint.SoapServer.SoapServerException was thrown. 0x80020009

When the Web Page is opened using SharePoint DesignerXSLT List view that contains over one thousand of word documents below exception is thrown. Microsoft.SharePoint.SoapServer.SoapServerException was thrown. 0x80020009 enter image description here [https://i.stack.imgur.com/e35cL.jpg] Help in resolving this is greatly appreciated. Google results did not convey exact reason yet. Thanks, read more
sharepoint
sharepoint-2010
0votes
2answers

open excel file on the above folder with watir/Ruby

At moment I am open an Excel file like this excel = WIN32OLE::new("excel.Application") workbook = excel.Workbooks.Open('T:\\PointOfSale\\Projects\\Automated Testing\\MasterFile.xls') worksheet = workbook.WorkSheets(1) # Get first workbook site = worksheet.Range('A2').Value # Get the value at cell in worksheet. and its fine but when i move the scrip to a server i am getting [...] read more
ruby
0votes
1answer

How to apply blank web part page layout to default page in onet.xml for a site template

I need to use the blank web part page in all the new pages and in the default home page when a site is created. This is what I have so far <WebFeatures> <!-- SharePoint Server Publishing --> <Feature ID="94c94ca6-b32f-4da9-a9e3-1f3d343d7ecb" > <Properties xmlns="http://schemas.microsoft.com/sharepoint/"> <Property Key="DefaultPageLayout" value="~SiteCollection/_catalogs/masterpage/BlankWebPartPage.aspx" /> </Properties> </Feature> <Modules> [...] read more
sharepoint
sharepoint-2013
0votes
1answer

Confusion with Ruby to save the files with any extensions to the excel columns

I am creating a script to insert the files from folders to the Excel columns, but it seems I am doing wrong. Can any one help me for the same? updated Ruby Code: require 'fileutils' require 'win32ole' #Excel Application will be started from here. #-------------------------------------------- excel = WIN32OLE.new('Excel.Application') excel.visible = [...] read more
ruby
win32ole
0votes
2answers

Rails import from Excel issue

We are using Ruby on Rails code to import the data from an Excel sheet, we use an alert where it asks whether we upload the data and append to existing data (MySQL database) and display it in a grid designed in Flex 3, or replace the old data with [...] read more
ruby-on-rails
ruby
excel
import
ole
0votes
2answers

Having error when vb.net application is used in different OS

A .net application is used at XP OS and everything is working fine until the OS is changed to Windows 7. At first have an error "Retrieving the COM class factory for component with CLSID {4E084A82-8FE7-11D0-9125-0004AC3617E1} failed due to the following error: 80040154". I checked the registry and the reg [...] read more
.net
registry
0votes
1answer

Watir-Classic 3.1.0 execute_script issue

I am in the process of upgrading from WATIR 2.0.4 to 3.1.0. I ran into the following error when trying to "kill pop-ups" before they get executed. What can I do to fix this? Windows XP Ruby 1.9.3 Cucumber 1.1.9 Watir-Classic 3.1.0 (in OLE method `execScript': ) OLE error code:80020101 [...] read more
ruby
watir
0votes
1answer

Impossible to add a webpart to a Gantt view of a list

I am a sharepoint user without access to sharepoint designer. I'm hoping to create a Gantt chart with a modified timescale, as per http://blog.pathtosharepoint.com/2008/11/08/how-to-scale-down-the-sharepoint-gantt-view/, i.e. add a Custom Editor Web Part with some css in it which changes the timescale. The steps I take are 1. Create a new Custom [...] read more
sharepoint-2007
gantt-chart
0votes
1answer

IsSearchSynchronous fails in Outlook

I am using Outlook automation to find items in the Calendar. For that I use IsSearchSynchronous() method to see if I have to wait for the AdvancedSearchComplete event. BTW, is it ever synchronous??? Anyway, if I have Outlook running, I have no problems with this call. But if it doesn't [...] read more
outlook
office-automation
0votes
1answer

TypeError: 'NamedScriptAttribute' when calling Request in ASP with ActivePython3

Here's my asp code: <%@ Language = Python%> <% def main(): a = Request("btnSubmit") main() %> This is giving me the error: Error Type: Python ActiveX Scripting Engine (0x80020009) Traceback (most recent call last): File "<Script Block >", line 3, in <module> main() File "<Script Block >", line 2, in [...] read more
python
asp-classic
vbscript
python-3.x
pywin32
0votes
1answer

Error while creating new project using S#arp Architecture template

I am new to S#arp-Architecture, I have S#arp version 1.5.1. Followed steps specified in http://wiki.sharparchitecture.net/VSTemplatesAndCodeGen.ashx to get S#arp-Architecture template integrated with VS2008. When I try to create new Project using S#arp Architecutre template I get following error in visual studio. --------------------------- Microsoft Visual Studio --------------------------- A problem was encountered creating [...] read more
s#arp-architecture
0votes
3answers

Multiplying 2 Columns

I am very new to asp and having following problem I am getting 2 values from 2 column, from database and when i try to multiply them, its giving following error Error Type: (0x80020009) Exception occurred. This is my code totalPrice = totalPrice + rs("ProductQunaity") * rs("ProductPrice") Even if someone [...] read more
asp-classic
0votes
2answers

How to migrate correctly with sequel on Access 2007

When I migrate my application to Access 2007 with sequel library of Ruby. I get the errors as follows. Does anybody know how to migrate correctly? Thanks. C:\ContractManagement>rackup C:/Ruby192/lib/ruby/gems/1.9.1/gems/sequel-3.23.0/lib/sequel/adapters/ado.rb:63: in `method_missing': WIN32OLERuntimeError: (in OLE method `Execute': ) (Sequel:: DatabaseError) OLE error code:80040E14 in Microsoft Office Access Database Engine Syntax error [...] read more
ruby
ms-access
ms-access-2007
ado
sequel
0votes
1answer

Cannot send displayed email using redemption in c#

I created a new email-message using Redemption-Data-Objects in C#. After calling Display(), the window is opened - all looks great. When I try to send the message, by clicking the "send"-button, I get one of the following messages (translated from german...): "The messaging-interface returned an unknown error. try to restart [...] read more
c#
email
send
outlook-redemption
0votes
1answer

sharepoint extract portable schema.xml from custom list on site

I've created a custom list in a SharePoint site, but now I want to convert that into a list template so I can deploy it in other sites using a feature. I've tried two methods: 1. Use SharePoint Manager 2007 to copy/paste list schema into schema.xml and roll into a [...] read more
sharepoint
templates
0votes
1answer

Why am I getting an exception when I try to set the value of a cell in Excel using Perl's Win32::OLE?

I am getting the error Win32::OLE<0.1709> error 0x80020009: "Exception occurred" in PROPERTYPUT "Value" at line 109. The code in is Perl. foreach my $ref_array1 (@$array1) { # loop through the array foreach my $col1 (@$ref_array1) { foreach my $ref_array2 (@$array2) { # loop through the array foreach my $col2 (@$ref_array2) [...] read more
perl
excel
win32ole
0votes
3answers

Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) in SharePoint Part 2

Following this post which I posted some time ago, I now get the same error every time I try to rewire 2 web's URLs. Basically, this is the code. It runs in a LongRunningOperationJob: SPWeb existingWeb = null; using (existingWeb = site.OpenWeb(wedId)) { SPWeb destinationWeb = createNewSite(existingWeb); existingWeb.AllowUnsafeUpdates = true; [...] read more
sharepoint
sharepoint-2007
0votes
1answer

Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) in SharePoint

After googling for many hours for a solution for the above Sharepoint exception, I have come to SO for help on this one... I believe the cause of me getting the above exception is because of the following code: try { using (SPSite site = new SPSite(siteId, spUserToken)) { using [...] read more
sharepoint
sharepoint-2007
0votes
1answer

SPWeb disposing himself and causing exception

When trying to use SPWeb.GetSiteData(SPSiteDataQuery) (Trying to bind some data to SPGridView), it throws me an TargetInvocationException with a following stacktrace: EXCEPTION at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder [...] read more
sharepoint
exception
dispose
-1votes
1answer

Watir cannot running correctly when executing cases:

Please help to have a look for error details in below when running watir for automation test. Details: 1> watir version : 1.9.2 2> Ruby version: 1.8.7 2017-11-14 05:51:06 ERROR [xxx] Failed to create browser object for: IE 2017-11-14 05:51:06 ERROR [xxx] WIN32OLERuntimeError Attach OLE error code:80004005 in HttpWatch.Controller Failed [...] read more
watir
httpwatch
-1votes
1answer

How do I open multiple Excel files using Ruby script?

I am working on writing a ruby script to iterate through a file containing a list of file paths to open in Microsoft Excel. I read the file like this: file_names = IO.readlines('D:\TEST_1\file_names.txt') Next, I create an array of file names from each line of the parsed file (thus containing [...] read more
ruby
excel
parsing

Comments

Leave a comment

(plain text only)

Sources

  1. winerror.h from Windows SDK 10.0.14393.0
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx

User contributions licensed under CC BY-SA 3.0