I have been tracking an issue for a while now where the remote desktop that we are running our tests from randomly disconnects from our scheduling and execution servers every few days and has to be manually reconnected. We also get a "A test list is waiting to be executed on the execution machine..." error popup when we load test results making me think the server is somehow hung up on a testlist. In the last couple of days our scheduled tests have stopped running altogether, even though our servers are still connected and the tests are still scheduled. Researching these issues I have learned that I need to check the Telerik.TestStudio.Scheduling.Log for errors, but this log does not exist in our system and if someone has moved it I cannot find it. I also learned from other similar threads (like http://www.telerik.com/forums/scheduled-tests-not-executing) that I should create a new SQL database, but I cannot find the option to change database connection settings. Can anyone please provide assistance in locating our error logs and changing our database name? I know these should be simple tasks, so I apologize in advance if the solution is a simple one.
3 Answers, 1 is accepted
0
Hi Chris,
...but I cannot find the option to change database connection settings...
Unfortunately we don't have an easy UI for changing the connection string. You can still do it by going directly to the config file, opening it in any text editor and modifying the string in there. Then stop and restart the Telerik Storage Service.
The default location for this config file is at:
C:\Program Files (x86)\Telerik\Test Studio\StorageService\CloudStorageSelfHost.exe.config
If you open it up in Notepad you will find a line like this:
<add name="Storage" connectionString="server=(local)\SQLEXPRESS;Integrated Security=true;DATABASE=TestStudioStorage" providerName="System.Data.SqlClient"/>
Modify the value of connectionString to what you think is appropriate. Putting in a different value for DATABASE will cause our storage service to automatically create a new database by that name for you. No need for you to create the DB before hand.
Regards,
Cody
Telerik
...but I cannot find the option to change database connection settings...
Unfortunately we don't have an easy UI for changing the connection string. You can still do it by going directly to the config file, opening it in any text editor and modifying the string in there. Then stop and restart the Telerik Storage Service.
The default location for this config file is at:
C:\Program Files (x86)\Telerik\Test Studio\StorageService\CloudStorageSelfHost.exe.config
If you open it up in Notepad you will find a line like this:
<add name="Storage" connectionString="server=(local)\SQLEXPRESS;Integrated Security=true;DATABASE=TestStudioStorage" providerName="System.Data.SqlClient"/>
Regards,
Cody
Telerik
0
Engage QA
Top achievements
Rank 1
Rank 1
answered on 19 Jun 2016, 07:45 PM
Hey,
I'm having a similar issue to this, our tests were running regularly and reliably, then for no apparent reason they stopped, i cant find any errors and logging on reads:
[06/20 07:32:09,Telerik.TestStudio.ExecutionManagerService.exe(1308:20),Execution] JobRunner.RunJobAsync() : TestList loaded for job ID = 5d25d4f6-3e9f-4c37-8dab-96317d899ae3
[06/20 07:32:09,Telerik.TestStudio.ExecutionManagerService.exe(1308:20),Execution] JobRunner.RunJobAsync() : Job started, ID = 5d25d4f6-3e9f-4c37-8dab-96317d89
Then the job vanishes from the results page, and there is no trace of it. I dont want to have to create a new test database. is there anything else i can do to resolve this?
Thanks
0
Hi,
Thank you for contacting Telerik Support Team.
To be able to provide a proper advice we will require further information. Please let me know if that happens to a particular test/test list or it is randomly terminated each time? If there is anything unusual you could share with us might be useful for the investigation.
Which is the version of Test Studio you are using currently? Please bear in mind that we have migrated to MongoDB for storage services and SQL is no longer supported.
Please enable both application and remote execution logs and provide them after an execution that failed. Please consider clearing them before you start so that they contain recordings for the particular run.
If you are using a recent version of Test Studio I would like to ask you for the MongoDB log file as well - you will find it under C;\mongoDB and will be named mongo-server.log. It might be quite large since it is not usually cleared.
Please let me know if the above information suits your query. Otherwise please share further details to be able to assist you. Thank you for your cooperation! I hope to hear from you soon.
Regards,
Elena Tsvetkova
Telerik
Thank you for contacting Telerik Support Team.
To be able to provide a proper advice we will require further information. Please let me know if that happens to a particular test/test list or it is randomly terminated each time? If there is anything unusual you could share with us might be useful for the investigation.
Which is the version of Test Studio you are using currently? Please bear in mind that we have migrated to MongoDB for storage services and SQL is no longer supported.
Please enable both application and remote execution logs and provide them after an execution that failed. Please consider clearing them before you start so that they contain recordings for the particular run.
If you are using a recent version of Test Studio I would like to ask you for the MongoDB log file as well - you will find it under C;\mongoDB and will be named mongo-server.log. It might be quite large since it is not usually cleared.
Please let me know if the above information suits your query. Otherwise please share further details to be able to assist you. Thank you for your cooperation! I hope to hear from you soon.
Regards,
Elena Tsvetkova
Telerik