rksenthil2003 Absent Member.
Absent Member.
2575 views

Runtime error 429 while accessing ALM 11 from Excel

Hi,

 

I am trying to exceute an Excel Macro coded in VB to connect to HP ALM 11 for pulling some reports. But the process fails with the runtime error 429 (ActiveX component can't create object). I found out that the code is failing somewhere in the below statement.

 

    Set QC_Conn = New TDAPIOLELib.TDConnection
    QC_Conn.InitConnectionEx strServer
    QC_Conn.ConnectProjectEx strDomain, strProject, strUser, strPwd

 

Could anyone suggest what could be the possible cause?

 

Thanks

Senthil

0 Likes
4 Replies
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: Runtime error 429 while accessing ALM 11 from Excel

Have you run the HP ALM Client Registration program available from the ALM Add-ins page?
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
rksenthil2003 Absent Member.
Absent Member.

Re: Runtime error 429 while accessing ALM 11 from Excel

Hi Trudy,

 

I tried that, but still no change. 😞 In some other forum, i noticed that there should be a folder in C:\Program Files\Common Files\Mercury Interactive. But i have ALM in this location only - C:\Documents and Settings\Administrator\Local Settings\Application Data\HP. Does that mean i miss something?

 

Thanks

Senthil

0 Likes
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: Runtime error 429 while accessing ALM 11 from Excel

Not necessarily. Mercury Interactive was the previous vendor for Test Director for Quality Center. HP bought them, and ultimately changed the product name to ALM.

Are you sure you followed all the instructions related to installing the Excel add-in, including meeting the prerequisites for all software that has to be installed, and settings that are required?

What OS and bit level is your workstation? What version of Excel are you running? What patch level are you on for ALM? Are you sure that the ALM patch level you are at supports your workstation OS, bit level, and version of Excel?

Are you logged into the workstation as a user with admin permissions? If using Vista or Windows 7, did you install the additional software while logged in as a user that had admin permissions, and then use the Run As Admin option when running the installers for the additional software?

does the code you've written work on other workstation?
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
jyboo Absent Member.
Absent Member.

Re: Runtime error 429 while accessing ALM 11 from Excel

first login to HP QC with valid credentials, project and domain, click–> help –> add-in –> click Register and wait for the process to complete

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.