This is a migrated thread and some comments may be shown as answers.

Scheduling Registration Fail

10 Answers 53 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kiran
Top achievements
Rank 1
Kiran asked on 28 Oct 2013, 06:20 PM
Hi -

I have Telerik Test Studio [Version: 2012.2.1420] installed on Windows Server 2008 R2 OS. I am facing a weird issue of scheduling with the application. i have SQL Express Version [2012] installed too.

The problem -

I am trying to schedule a test on the same machine where both execution & scheduling servers are present. From the Project -> Scheduling tab, I click on 'Connect' option. here I specified the local machine's URL to connect to. The service URL is something like "http://<LOCAL HOST>:8009/TestStudio/SchedulingService.

The 'Test Connection' function is successful. The Schedule runs from the local version of one of my test. However when I try to 'REGISTER', I get an error. The error description is in the attached screenshot. Can someone please help resolve this issue?

Thanks,
-Kiran

10 Answers, 1 is accepted

Sort by
0
Cody
Telerik team
answered on 31 Oct 2013, 08:33 PM
Hi Kiran,

That error message means you need to fix the logon permissions for that user within your SQL Server (SQL Express in this case). Some how the login credentials for the user "TestUser" has expired. We usually see this on full corporate SQL Servers where it's mandatory to change the password every N days. If the password isn't changed within that time you run into this particular error.

FYI, the connection succeeds because it's not actually trying to login at that time. It's only opening a TCP connection to your SQL Server to verify it is connectable.

Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Kiran
Top achievements
Rank 1
answered on 01 Nov 2013, 03:48 PM
Hi Cody - Thank you for the reply. While I do understand what you said about checking the SQL server 'testuser' account. I am unable to figure out which SQL server Test Studio is trying to connect to. The person who installed it is no more with the company I work for. So, is there a way I can figure this out?

Also, are there any step by step instructions on how I can get a test/test list scheduled to be run on a machine that has the run-time libraries? This would immensely help me in scheduling and get the work done.

Thanks,
-Kiran
0
Cody
Telerik team
answered on 01 Nov 2013, 10:35 PM
Hi Kiran,

The only way to find out what it's currently using is by cracking open the config file our Storage service loads. That file is stored at:
C:\Program Files (x86)\Telerik\Test Studio\StorageService\CloudStorageSelfHost.exe.config
When you open it up, look at the connection string. For example:

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="autofac" type="Autofac.Configuration.SectionHandler, Autofac.Configuration"/>
  </configSections>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
    </startup>
  <connectionStrings>
    <add name="Storage" connectionString="server=(local)\SQLEXPRESS;Integrated Security=true;DATABASE=TestStudioStorage" providerName="System.Data.SqlClient"/>
  </connectionStrings>
  <appSettings>
    <add key="aspnet:UseTaskFriendlySynchronizationContext" value="true"/>
    <add key="webpages:Version" value="2.0.0.0"/>
    <add key="webpages:Enabled" value="false"/>
    <add key="PreserveLoginUrl" value="true"/>
    <add key="ClientValidationEnabled" value="true"/>
    <add key="UnobtrusiveJavaScriptEnabled" value="true"/>
    <add key="CloudStorageServiceHostUri" value="http://localhost:8492/v1"/>
    <add key="FailedDocumentSaveLocation" value="FailedDocuments"/>
    <add key="SaveFailedDocuments" value="true"/>
    <add key="EnableCORS" value="true"/>
    <add key="Access-Control-Allow-Origin" value="*"/>
  </appSettings>
  <autofac>
    <modules>
      <module type="Telerik.TestStudio.Authentication.Modules.LocalInstallNoAuthModule, Telerik.TestStudio.Authentication.LocalInstallationAuthentication"/>
      <module type="SQLStorageAdapter.Modules.SQLStorageAdapterModule, SQLStorageAdapter"/>          
      <!--<module type="MongoStorageService.Modules.MongoStorageAdapterModule, MongoStorageService" />-->
    </modules>
  </autofac>
  <system.web>
    <httpRuntime maxRequestLength="16383"/>
  </system.web>
</configuration>

If you want to change it, and use our UI to change it, you'll have to re-run the installer.

are there any step by step instructions on how I can get a test/test list scheduled to be run on a machine that has the run-time libraries

By this, do you mean by just copying the binaries to a machine and hope it will run? This is not possible. You must install Test Studio using our installer in order for it to work. This is because our installer also:

  • Sets required registry keys
  • Installs required browser add-ons
Once installed you'll want to setup Test Studio scheduling and/or execution servers.
Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Kiran
Top achievements
Rank 1
answered on 04 Nov 2013, 02:03 PM
Hi Cody,

Thank you for the reply. Unfortunately I am not able to locate the folder "StorageService" on my machine [We have a full licensed version of Telerik]. Do you know what is the reason? So, once I figure that out only then I will be able to check as to which SQL server the installation is pointing to.

Secondly, when I said Step-by-Step instructions for scheduling, I meant how I can do the actual scheduling itself. I do have a full licensed version of telerik (both Developer and Run time licenses). I did refer to the "Scheduling & Execution Servers" link prior to posting this issue. But, it was of not much use. On all the machines where Telerik was installed, we did configure them to serve Scheduling too. 

So, at this point I do not know what other options I have to rectify the issue. 

Thanks,
-Kiran
0
Cody
Telerik team
answered on 04 Nov 2013, 02:24 PM
Hi,

I'd like to look at this problem on your computer via GoToMeeting. Let me know what time zone you are in and your availability and I'll setup the meeting. I'm in Austin, TX which is Central Time (GMT -6).


Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Kiran
Top achievements
Rank 1
answered on 04 Nov 2013, 02:29 PM
Hi Cody - 

I am in Virginia - EST. You can setup the meeting anytime today before 5 PM EST except between 2:30 to 3 PM.

Thanks,
-Kiran
0
Cody
Telerik team
answered on 04 Nov 2013, 02:52 PM
Hi Kiran,

How about Noon EST?

1.  Please join my meeting, Monday, November 04, 2013 at 11:00 AM Central Standard Time.
https://global.gotomeeting.com/join/653498093

2.  Use your microphone and speakers (VoIP) - a headset is recommended.  Or, call in using your telephone.

Dial +1 (805) 309-0012
Access Code: 653-498-093
Audio PIN: Shown after joining the meeting

Meeting ID: 653-498-093


Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Kiran
Top achievements
Rank 1
answered on 04 Nov 2013, 02:55 PM
Hi Cody - 

Thanks for setting up the meeting. I will join the meeting at 12 PM EST. Would it be possible to discuss few other questions I have regarding test execution, reporting, error handling etc in the meeting? Please let me know. 

Thanks,
-Kiran
0
Cody
Telerik team
answered on 04 Nov 2013, 03:02 PM
Hi,

Yes, if we have time. I only have 30 minutes.

Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Cody
Telerik team
answered on 04 Nov 2013, 05:41 PM
Hi Kiran,

Just to document the outcome of our meeting:

  • I discovered you're actually using 2012.2.1420 (the ticket was marked 2013.1 911)
  • We tried to reconfigure your scheduling server to use the local SQL Express. Your SQL account does not have permissions needed to set this up. You will work with your IT department to resolve this.
  • You will upgrade to 2013 version of Test Studio. I recommend getting our latest internal build, 2013.1.1002. It is very stable.
  • I showed you how to view detailed test results.
  • You talked about how you had to use a desktop click in one specific case. I need to see the application before I can troubleshoot why. We ran out of time to work on this. We'll come back to this after you upgrade. Please put this problem on a different ticket since it's unrelated to scheduling.
Regards,
Cody
Telerik
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
Tags
General Discussions
Asked by
Kiran
Top achievements
Rank 1
Answers by
Cody
Telerik team
Kiran
Top achievements
Rank 1
Share this question
or