Problem summary during QC use

Summarize the problems in QC usage, including the following four aspects:

1. Incompatibility with IE7 and IE8 (server side settings)

2. Unable to download the page normally under Win 7 (set on the client)

3. The data cannot be submitted to the database normally after the Chinese content is entered in QC (client settings)

4. garbled characters occurred when entering Chinese content in QC (to be modified)

5. Unable to access QC under Win 7 IE

6. The Chinese version of QC must be changed to the English version.

7. After the plug-in qcmsexceladdin is installed, open the Excel file and you cannot find the export to QC option.

 

8. qc9.0 supports IE 6 by default, and does not support IE 7, IE8, and ie9.0

9. When importing data to Qc in Excel, the user password cannot be entered

10. When importing data to Qc in Excel, select the data to be imported (requirement, use case...). The system prompts: you are not allowed to perform the following operations:

11. Modify QC 8080 Port

12. Use qc to remotely start qtp

13. Modify the default SA password of MSDE

14. Change the sqlserver Password

15. Uninstall QC

 

 

1. Solve the Problem of QC compatibility (Support) IE 7 and IE 8

Qc9.0 supports Internet Explorer 6 by default, but does not support Internet Explorer 7 and Internet Explorer 8. Open the Internet Explorer 7 and Internet Explorer 8 and enter the QC website. Here, my website is used as an example: http: // 192.168.1.122: 8080/qcbin, the message "Microsoft Internet Explorer: 4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0 ;. net CLR 1.1.4322 ;. net clr2.0.50727 ;. net CLR 3.0.20.6.2152 ;. net CLR 3.5.30729) not supported!"

Solve the Problem of qc's support for IE7 and IE8. Now, the general method is to directly modify the start_a.htm file under the Server installation directory. The method is as follows:

1. under the JBoss \ Server \ Default \ deploy directory under the QC installation directory on the server side (the default file path is: C: \ Program Files \ mercury \ qualitycenter \ JBoss \ Server \ Default \ deploy) find 20qcbin. war package.

2. Open this directory with winrar. you can see the start_a.htm file.

3.copy the start_a.htm file, open it with notepad, search for MSIE on the page, and click "(UA. lastindexof ('msie 6.0 ')! =-1) "and then add | (UA. lastindexof ('msie 7.0 ′)! =-1) | (UA. lastindexof ('msie 8.0 ′)! =-1) and then replace the start_a.htm file in the warehouse. You can also modify it directly in the original file.

4. After the configuration is modified, restart the QC server. The reason is that the content in 20qcbin. War is extracted to the temporary directory during server restart.

Note:

If you do not want to restart the server, add IE7 and IE8 support to the start_a.htm file in temp. To change the system file only, restart the QC service ~

By referring to this method, the server can be changed. However, when I open QC in IE 7 and IE 8 Client browsers, I still find that QC cannot be displayed normally. A prompt message is displayed on the page, this is caused by the security settings of IE 7 and IE 8. Just change it a bit:

A. IE 7

The security level of IE 7 is relatively high. You need to modify the options of IE:

1. Open your browser and enter the site of QC. The prompt is "javascript is not installed in your browser, or it has been disabled ."

Return to the browser, click the tool menu> Internet Options> Security> Custom Level, find the script scripting, and set "Active Scripting" and "script. of Java applets check "enable" and click "OK"

Refresh the page. The previous prompt is no longer displayed, but an IE message is displayed:

It seems that the ActiveX plug-in still needs to enable. In the custom options, find active controls and plug-ins, check "Run ActiveX controls and plug-ins" and then refresh the page, the client can be downloaded normally:

B. IE 8

IE8 is relatively simple. You only need to enable the ActiveX plug-in:

At this point, the server and client have been modified, and QC 9.0 can be used normally in IE 7 and IE 8! :)

 

Change User Account Control first ---- restart ---- modify ie attributes

In IE8/9 (to run as an administrator), set ie attribute tool> Internet Options> advanced enable memory Saving to Reduce memory attack options to deselect.

 

2. Unable to download the page normally under Win 7 (client settings)

The same problem will also occur on the siteadmin interface. Open the IE 7 and IE 8 browsers and enter the qc url. Here, my URL is used as an example: http: // 192.168.1.23: 8080/Sabin/siteadmin.htm. the problem similar to start_a.htmis displayed. Modify the siteadmin.htm file in the Server installation directory. The solution here is the same as the modification of the start_a.htm file, but the modified path is inconsistent. The specific method is as follows:

1. under the JBoss \ Server \ Default \ deploy directory under the QC installation directory on the server side (the default file path is: C: \ Program Files \ mercury \ qualitycenter \ JBoss \ Server \ Default \ deploy) find 10sabin. war package.

2. Use winrarto open this directory and you can see the siteadmin.htm file.

3.copy the siteadmin.htm file, open it with notepad, search for MSIE on the page, and click "(UA. lastindexof ('msie 6.0 ')! =-1) "and then add | (UA. lastindexof ('msie 7.0 ′)! =-1) | (UA. lastindexof ('msie 8.0 ′)! =-1) and then replace the siteadmin.htm file in the warehouse. You can also modify it directly in the original file.

4. After the configuration is modified, restart the QC server. The reason is that the content in 10sabin. War will be extracted to the temporary directory during server restart.

5.If other settings have been set in the modified start_a.htm, you do not need to repeat the settings here.

 

3. Solve the problem that QC cannot work normally in win7.

In Windows 7, I found that many client components cannot be downloaded normally when I log on to The addin page of QC server. As a result, the entire QC cannot be used. The solution is as follows:

Step 1: Disable UAC (User accountcontrol)

Enter UAC in the Start Menu search box. The "Change User Account Control Settings" menu appears. Click open, and the menu will pop up, as shown in the next User Account Control Settings dialog box. Select "Never notification" from the scroll bar ". Then restart the machine. This step grants the current user full administrator permissions.

Step 2: Disable Dep (dataextension Prevention)

Open the command line as the administrator (Enter cmd in the search box of the Start menu, right-click the CMD option, and select Run as the administrator. Then run the following command line and restart the machine.

Bcdedit/set {current} NX alwaysoff

Step 3: Re-download the client components

Enable HP qcexplore, or directly use IE to enter the address of the QC server in the address bar. After confirmation, the component will be downloaded smoothly:

Step 4: Access hp qc Server

After the download is complete, you will be able to normally use HP qc0000e, or directly use the IE browser to normally access the QC server.

Step 5: Restore UAC settings

To ensure security, it is best to reply UAC to the original settings and restart the machine. However, DEP must be in the disabled status.

　　

4. Solve the problem that QC cannot submit Chinese content to the database

After QC is installed and the website is successfully opened, enter the system and enter Chinese content in QC. An error message is displayed, as shown in:

Shows how to solve this problem (this method is for Windows 7 client settings, other systems can make similar changes ):

Step 1: Open the control panel and enter the following interface:

Step 2: select the red area, that is, change displaylanguage, to go to the following page:

Step 3: select the red area (formats) to go to the following page:

Step 4: on the formats interface, change the option in the red area to "Chinese (simplified, PRC)", and click "OK" to automatically close the interface.

Step 5: re-open the QC website, enter Chinese content in QC and submit it. The Chinese content can be submitted successfully.

 

5. Windows 7 ie cannot be accessedQCProblem

1. Other IE kernel browsers are required to enter the address to access the download plug-in (note that all plug-ins must be downloaded before the background)

2. Set the IE attribute tool in IE browser-> Internet Options-> enable memory storage in advanced mode to reduce memory attack options (run as Administrator)

3. Direct Access (run as Administrator)

 

6. The Chinese version of QC must be changed to the English version.

1. Find the 20qcbin.warwarpackage in the JBoss \ Server \ Default \ deploydirectory under the QC installation directory on the server. You can see start_a.htm modifying this file.

Add | (UA. lastindexof ('msie 7.0 ′)! =-1) | (UA. lastindexof ('msie 8.0 ′)! =-1) and then replace the start_a.htm file in the warehouse.

2.In the same example, modify the siteadmin.htm file in the 10sabin.warpackage.

3. Clear the files in this directory: C: \ Program Files (x86) \ common files \ Mercury Interactive. There are also three folders (The author is system: win7 64-bit)

1. License Manager 2. Quality Center 3. tdapiclient

Restart

 

 

7. After the plug-in qcmsexceladdin is installed, open the Excel file and you cannot find the export to QC option.

Solution: Open excel, open "load macro" under "Tools" in the menu bar, browse the office directory "C: programfilesmicrosoft officeoffice11xlstart", and select "tdexceladdin. xla.

 

8. qc9.0 supports IE 6 by default,Internet Explorer 7, Internet Explorer 8, and Internet Explorer 9.0 are not supported.

Open the IE 7 and IE 8 browsers, enter the qc url, and the prompt will appear: "microsoftinternet Explorer: 4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0 ;. net CLR 1.1.4322 ;. net CLR 2.0.50727 ;. net CLR 3.0.20.6.2152 ;. net clr3.5.30729) not supported!"

However, the problem we encounter is that every time we restart the QC server, we will find that the previous settings do not take effect because we modified the file configuration in the Temporary Folder. Therefore, to solve QC's support for IE7 and IE8 at one time, we need to modify the system file. The method is as follows:

1. Find the war package 20qcbin. War in the JBoss \ Server \ Default \ deploy directory of the QC installation directory on the server.

2. Open this directory with winrar. you can see the start_a.htm file.

3.copy the start_a.htm file and add it. | (UA. lastindexof ('msie 7.0 ′)! =-1) | (UA. lastindexof ('msie 8.0 ′)! =-1) and then replace the start_a.htm file in the warehouse.

This can also be directly modified in the original file.

4. In the same example, modify the siteadmin.htm file in the 10sabin.warpackage.

 

9. When importing data to Qc in Excel, the user password cannot be entered

Solution: Switch the input method to English

 

10. When importing data to Qc in Excel, select the data to be imported (requirement, use case...). The system prompts: you are not allowed to perform the following operations:

Solution: you cannot use the site administrator account to import data here. If you change to admin, OK.

 

11. Modify QC 8080 Port

During QC installation, IIS + JBoss is used. However, during use, port 8080 of your server may be occupied. Therefore, you need to modify the JBoss port in QC. The specific modification steps are as follows, the modification method has passed the test on the local machine, and the new port number can be used in the background and foreground to log on normally:

1. Modify Port = "8080" in the \ Quality Center \ JBoss \ Server \ Default \ deploy \ jbossweb-tomcat55.sar \ Server. xml file ".

2. Modify the following three URL port numbers in the \ qualitycenter \ JBoss \ Server \ Default \ deploy \ http-invoker.sar \ META-INF \ jboss-service.xml file.

<Attributename = "invokerurlsuffix">: 8080/invoker/ejbinvokerservlet </attribute>

<Attributename = "invokerurlsuffix">: 8080/invoker/jmxinvokerservlet </attribute>

<Attributename = "invokerurlsuffix">: 8080/invoker/readonly/jmxinvokerservlet </attribute>

 

12. Use qc to remotely start qtp

As the test Team expands and qtp test scripts increase, we need to use multiple computers to run the qtp script. If you want to log on to each machine and run the script, it is too inconvenient, the consistency of script versions on each machine is also required.

If we can use one computer to run scripts on multiple computers with qtp installed, it would be unpleasant.

The quanlity Center (QC) developed by mercury can implement this function.

To use qc to remotely call qtp, a series of settings are required. In this article, we call the computer that has deployed qtp "Test Machine" and the computer that remotely controls the test machine "console" for convenience.

After qtp is installed on the test machine, a plug-in tdplugin is also installed. The installation program of this plug-in is under the tdplugin directory of the installation disk, and restarts after installation.

The settings below are very important. The installation guide for qtp has a detailed description. Here I will introduce several key points. The Installation Guide is named qt_install_guide.pdf. The specific content is in the "modifyingdcom permissions manually to enable remote quicktest execution" chapter.

First, you need to set the permissions for Windows login users. The instructions in the Guide file assume that the test machine and console have been added to the domain. In fact, it is also feasible to not add the domain, but the settings are somewhat different. We will first talk about the absence of a domain. For example, if you use ctrluser to log on to Windows, you must add a ctrluser user with the same name and password to the test machine and add the user to the system administrator group.

If both machines are added to the domain, it is better to do so. For example, if the region user in the console is ctrldomainuser, you only need to add this user to the system administrator Group of the test machine. That is to say, the user logging on to the console has the administrator privilege of the test machine.

The next step is to set up a fire wall for the test host. The main step is to open the 135port and expose the aqtrmtagent.exe agent to the firewall's exception list.

Next, set the permissions for DCOM. Here, there are many setup steps, which are clearly described in the installation guide documentation, mainly to add some users and groups to the list of permitted access.

After setting DCOM, open qtp and select "allowother mercury products to run tests and components" on the run page of option.

Now open a test, connect qtp to QC, and save the test to QC. Log on to QC on the console, create a test set, and add the test just now to the test set. Then, in the host manager, add the IP address of the test machine. Return to the test set window and specify the "planned host name" of the test as the IP address of the test machine. Now you have finished running the test set.

At this time, the qtp of the test machine is automatically started. After the test is run, the test results are automatically saved on the QC server. We can view the test results on any computer.

 

13. Modify the default SA password of MSDE

1. Open the Command Prompt window in the host computer of the MSDE instance you are connecting.

2. type the following command and press Enter: osql-U sa

At the password: prompt, press enter (if the password is empty) or enter the current password. In this way, you can use the SA account to connect to the local default instance of MSDE.

To use Windows authentication for connection, enter this command: osql-E (this method can be used if you do not know the SA password)

3. type the following commands in each individual line and press Enter:

Sp_password @ old = NULL, @ new = 'Password', @ loginame = 'sa'

Go

Note: Make sure to replace "password" with your password. You will receive the following prompt, indicating that the password has been changed successfully:

Password Changed.

Note: After the MSDE password is changed, go to the site management of QC -- change the DB admin password in DB server to be consistent with the new MSDE password.

 

14. Change the sqlserver Password

Uninstall SQL Server, delete the "Microsoft SQL Server" folder generated during installation, and run the Registry to delete HKEY_CURRENT_USER \ Software \ Microsoft \ microsoftsql server, and HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ microsoftsql server are all deleted. (Delete the entire Microsoft SQL Server folder)

 

15. Uninstall QC

If you cannot use the Add/delete program to uninstall QC, follow these steps:

1. Delete the c: \ Program Files \ HP \ quality center directory.

2. Re-add and delete the program to uninstall the quality center. The icons in the list will be deleted, but they are not completely deleted. Next step is required:

3. delete the file c: \ windows \ VPD. perties.

4. All rights!

Problem summary during QC use