Forum Discussion

Subbulakshmi's avatar
Subbulakshmi
Frequent Contributor
7 years ago

Test Complete execution through Jenkins - Database issue

Hi,   I have configured Test complete plugin in Jenkins and able to execute the test cases properly, if the script does not have any database queries. If there is a database query, It is waiting ...
  • Subbulakshmi's avatar
    Subbulakshmi
    7 years ago

    Hi, 

     

    The issue is resolved now. The problem was, We use Test Complete 32-bit for our execution and Database driver is also 32-bit. But Jenkins is launching Test Complete 64-bit. Hence Database is not connected. When I redirected it to use 32-Bit test complete, we are able to execute the test case properly. 

    Thank you all. 

Subbulakshmi's avatar
Subbulakshmi
Frequent Contributor

Hi,

 

I am able to connect to database when I run my testcase from Test complete directly. Only through Jenkins, it is not working. 

shankar_r's avatar
shankar_r
Community Hero
7 years ago

It might be an access issue.

 

Do you running your tests VM or in local system?

  • Subbulakshmi's avatar
    Subbulakshmi
    Frequent Contributor
    7 years ago

    Hi Shankar,

     

    We are using local system. 

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      7 years ago

      This sounds like a permissions problem.  Keep in mind, when running tests via Jenkins, the user that executes the test is the user that Jenkins tasks run under.  So, if you are depending upon the existing Windows Authentication of the logged in user to access the database, if your Jenkins user does not have permissions, then the database connection will fail.

      Two possible solutions:

      1) Allow the user that Jenkins is running under to have access to the database

      2) Re-factor your test code and database security to use a "static" login rather than Windows authentication

      • Subbulakshmi's avatar
        Subbulakshmi
        Frequent Contributor
        7 years ago

        Hi,

         

        The user is having rights for executing database queries and Database is connected via separate user name and password.