Mercury Quality Center Dashboard™ presents Key Performance Indicators(KPIs) in real-time, enabling users to make informed, accurate decisions about application deployment readiness

Unable to cast COM Object Type System_

Solution#3:
please try the below solution with the help of local support to fix the issue. Please note that you can only run below scripts as admin on your laptop

Start->Run

Enter “Regsvr32 actxprxy.dll”

Click OK

If the popped up message shows successful, try log in to QC and see. If you still face the same problem,

Please run below script at command prompt:

for %1 in (%windir%\system32\*.dll) do regsvr32 /s %1

for %1 in (%windir%\system32\*.ocx) do regsvr32 /s %1

If both scripts executed successfully you should be able to log in to QC other wise it indicates that there is a problem with .NET framework on your laptop. You have to install it again with the help of local support

Unable to cast COM OBJET TYPE SYSTEM_

Solution#2

Access Object Collector error: Database
     Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00000021-0000-0010-8000-00AA006D2EA4}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

 

At first I thought this could be issue due to corrupted files for Management Studio, so to overcome that conclusion I have tried from another client's machine which has been successful to load the database properties with no error/warnings. So the conclusion is some issue with system files on the machine which is presented with same error, the issue could be with the DLL file 'DAO360.DLL'. Also to take out what are the recent changes to this machine I found that SQL Server Migration Assistant was installed recently and to solve the COM component error we could try re-register of specified DLL file above by using:

• Click Start, and the click Run.
• Type the following command:   Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll" 

Once it is completed it will prompt a command box stating, specified DLL registered successfully. So to see whether this has solve the actual prblen I have tried accessing the same database from SSMS, to some extent the error on subject line was not presented again  bu with this error:  An error occurred while loading database content 

As a final trial before I decide on format the machine and reload the required tools again, I tried to check whether the PATH environment varialble is directed to correct location and to check this the procedure will be the following:

1.    Right click properties on My Computer

2.    Go to the tab “Advanced”

3.    Click on the button “Environment Variables”

4.    On the System Variables section, look for the variable “Path” and click on it.

5.    Once highlighted, click the “Edit” button.

6.    Go to the end of the “Variable value” , add a semicolon and then add the path of the DAO360.dll.

7.    Click OK button

8.    Click OK button

9.    Click OK button

 

 

 

COM OBJECT CAST TYPE ERROR - Solutions for this

Problem : see the Image

 

 

Solution:

Uninstall and Cleanup:


1. Close all instances of Internet Explorer 2. Download the QCClient_Uninstall92.zip file attached and run this utility.
3. Once the utility is finished, on the client navigate to the path C:\Program Files\Common Files\Mercury Interactive.
4. In the “Mercury Interactive” folder delete either the “TD2000_80” or “Quality Center” folders. If both exist, delete both.
5. On the same client navigate to the %Temp% folder. This will be located in the path: C:\Documents and Settings\<windows_user_id>\Local Settings\Temp. Be sure to supply the windows user ID in the path.
6. Once in the “Temp” folder delete the “TD_80” subfolder. This is better known as the QC Cache. Like “Temporary Internet Files” this can be safely deleted. It will be recreated upon the next logon to Quality Center.
7. Navigate to the path: C:\WINDOWS\Downloaded Program Files 8. In the “Downloaded Program Files” folder right click on the “LoaderClass v4" and select “Remove”
9. Click Start>Control Panel>Add or Remove Programs 10. In the Add/Remove programs section look for “Microsoft .NET Framework 2.0”
11. Select the “Microsoft .NET Framework 2.0” and click the “Remove” button. Let the uninstall finish.
12. Open Internet Explorer, navigate to your Quality Center server and let the client load. The .Net CFramework 2.0 will reinstall.
After that, lets proceed as follow in order to clean up the temporary files:
1. Go to C:\Program files\Common Files and rename Mercury Interactive folder. 
2. Open a new IE browser. Go to Tools ->Internet Options -> setting s-> View Objects. Remove all the loader class files from the window.
3. Try to access QC again. it will perform a fresh installation of client files.

 

Source : http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1263729

Steps to Migrating from TD8.0 to QC9.2

http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1304427923695+28353475&threadId=1287315

Error in QC with Excel : "compile error in hidden module: CTDServer"

Error#1 :

I try to export tests from Excel (2003 SP 3)
to Quality center 9.2
I always get the error
"compile error in hidden module: CTDServer"

I alredy tried to re-install the Excel-Add-in
and the HP Quality Center Connectivity Add-in,
but no success.

I also tried opening directly
C:\Program Files\Microsoft Office\OFFICE11\XLSTART\TDExcelAddin.xla
but also no success.

Solution#1:

Title:
Error: "Compile error in hidden module: CTDServers" when using the Excel macro
Document ID:
KM177013
Product:
TestDirector for Quality Center
Version:

OS:
Unspecified
Updated:
2002-Nov-21


When using the Excel macro to export data into a TestDirector project, the following error message appears:

"Compile error in hidden module: CTDServers."

Diagnosis:The macro may not have been started properly or the appropriate library is not being used.

This can happen for TestDirector or TestDirector for Quality Center.

Solution
Open the TDExcelAddin.xla file manually and/or use appropriate COM library

Open the TDExcelAddin.xla file manually:

1. Open Excel.
2. Go to File -> Open.
3. Open your "\Program Files\Microsoft Office\Office\XLStart\TDExcelAddin.xla" file.

The problem should go away after doing this once.

If the problem still persists, then try the following:

1. Within Excel, Go to Tools -> Macro -> Visual Basic Editor.
2. Select VBAProject TDExcelAddin.xla (highlight). (please contact Mercury Interactive support for the default password)
3. Go to Tools -> References.
4. Scroll down to OTA 8.0 COM API Library (Or 9.0 depending on version of QC), move it up in the list and make sure it is selected.

This should resolve the macro error.

If the problem still persist, proceed to un-install and re-install the Excel Macro.

1. Select Start -> Settings -> Add/Remove Programs.
2. Select "TestDirector Microsoft Excel Add-in" to un-install the Excel Macro.
3. Download and re-install the Excel Macro from the TestDirector Add-in page.
********************

Also check if you have write access to the folder MAPS where the file TDExcelAddin.xla is or local admin rights.

Solutions#2:

Possible solutions :

Possible solutions:

1.. a. Open Excel.
b. Go to File -> Open.
c. Open your "Program Files\Microsoft Office\Office1x\XLStart\TDExcelAddin.xla" file.

2. Make sure that OTA COM Type Library is selected:

a. Within Excel, Go to Tools -> Macro -> Visual Basic Editor.
b. Select VBAProject TDExcelAddin.xla (highlight). (please contact Mercury Interactive support for the default password)
c. Go to Tools -> References.
d. Scroll down to OTA COM Type Library, move it up in the list and make sure it is selected.

3. Re-install the Excel Macro.

a. Select Start -> Settings -> Add/Remove Programs.
b. Select "TestDirector Microsoft Excel Add-in" to un-install the Excel Macro.
c. Download and re-install the Excel Macro from the TestDirector Add-in page.

4. Get the TDExcelAddin.xla file from a working machine and replace that of the affected machine. TDExcelAddin.xla is located at "C:\Program Files\Microsoft Office\OFFICE1x\XLStart".

Run the HP Quality Center Connectivity Add-in which provides the ota objects necessary for excell addinFixed the paths and OTA COM type Library version

Note : If none of the suggested solutions works, get the C:\Program Files\Microsoft Office\OFFICE11\XLStart\TDExcelAddin.xla file from a working machine and replace that of the affected machine.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Excel tutorial resources

Data Source: DataPig Technologies

New! Excel Recorded Webinars

10 Must Have VBA Skills

Excel Basics

Using "Paste Special"

Using Text to Columns

Tips on Filtering with "AutoFilter"

Using Goal Seek

Data Validation in Excel

About Conditional Formatting

Basics of Protecting a Worksheet

Basics of Using Subtotals

Basics of Print Setup Options

Formatting Tricks

Grouping Tabs to Save Time

Conditional Format with Four Conditions

Adding Tool Tips to Cells

Pivot Tables

Create a Basic Pivot Table

Sorting in a Pivot Table

Create a Drill Down Effect with a Pivot Table

Adding a Calculated Field in a Pivot Table

Grouping in a Pivot Table

Creating Pivot Charts

Using Pivot Table Advanced Options

Convert Pivot Tables Into Hard Data

Synchronize 2 Pivot Tables with a Combo Box

Tie a Chart to a Pivot Table

All About Multiple Consolidation Ranges

Pivot Table Based Conditional Chart

Add Dynamic Icons to Pivot Table Reports

Pivot Tables and Spreadsheet Bloat

Excel Charting Techniques

Combo Charts and Formatting Data Points

Create Dynamic Chart Labels

Create a Histogram Chart

Using the Bar to Pie Chart

Add Average Line to a Chart

Invert Negatives in a Chart

Create a Scrolling Chart (With Dynamic Ranges)

Create a Basic Speedometer Chart

Create a Thermometer Effect in you Column Charts

Creating a Delta Chart

Creating a Benchmark Chart

Use Excel Charts in PowerPoint Without Bloat

Creating Bullet Graphs in Excel

Excel Functions Explained

Matrix Lookup Formula (Index and Match)

Cell Information Functions

Text and String Functions

Formula to Convert Trailing Minus Signs

Using IF(AND()) & IF(OR()

Using the SumProduct() Function

Basics of Nested Formulas

Conditional Sums and Array Formulas

Using the SUBTOTALS Function

Dynamic Ranges Finally Explained

Excel Tips and Tricks

Increase Available Undo Actions

Using the COUNTIF() to Find Duplicates

Set Duplicates Warning with Data Validation

Formula to convert your dates to quarters

Sort by Color without an Add-in

Turn a Row Oriented Dataset into a Column Oriented Dataset

Sort by Capitalization

Using Excel Macros

All About Recording Macros

Cleaning up your Macro generated VBA

Using Spreadsheet Form Controls

Using Macros to create a user interface

Send Emails with SENDEMAIL method

Create your First User Form (Create a Splash Screen)

Calling up Excel Dialog Boxes

Force Users to Enable Macros

VBA Basics

Quick overview of VBA

Understanding Reference Libraries

Declaring Variables

Using If Statements

Using Select Case Statements

The Basics of the Do Loops

Using For Next Loops

Looping with For Each Statements