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

Recent Upgrade causing Issues

4 Answers 38 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Reddy
Top achievements
Rank 1
Reddy asked on 15 Aug 2012, 06:48 PM
We recently purchased a Test Studio license and installed the latest version (2012.1.719.0). There are some scripts that i had created and successfully ran in the older version during my trial version but now i am not able to run them. I am getting the below error in the log

'8/15/2012 2:47:55 PM' - System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ArtOfTest.Common.Design.Data.DbDataSource.GetDataUnfiltered(DataInfo testBindingInfo)
   at ArtOfTest.WebAii.Design.Execution.DataContext.InitializeDataSource(String outDirectory)
   at ArtOfTest.WebAii.Design.Execution.ExecutionContext.SetCurrentTestAndData(Test test, Boolean canInitializeDataSource)
   at ArtOfTest.WebAii.Design.Execution.ExecutionEngine.InternalExecuteTest(Test test, TestResult initializationResult)
   at ArtOfTest.WebAii.Design.Execution.TestExecuteProxy.ExecuteTest(ExecuteTestCommand command)
ClientConnectionId:00a4fab7-c798-40a6-a2fe-0734a1ce481c

Thank you,
Nithin

4 Answers, 1 is accepted

Sort by
0
Reddy
Top achievements
Rank 1
answered on 16 Aug 2012, 12:49 PM
I was able to fix the earlier issue which was caused because there was a change in the path of the Test Studio projects. My files were located on my local system earlier but now they have all been moved to a network drive while Test Studio was on my local. I moved all my project folders to a different folder on my local and was able to resolve that. But i am having another issue with the Data Binding property

Looks like the Data Binding Issue is being caused because i used a T-SQL statement for Data Binding. My statements read as follows "SELECT * FROM [AQSMPL_TestData].[dbo].[PolicyAccess] as p, [AQSMPL_TestData].[dbo].[PolicyInfo] as q where p.PolicyNumber=q.PolicyNumber" or "Select * from HistoryTable order by CurrentPolicyNumber"

The Error i am getting is "Unable to show the data. Error: Incorrect syntax near ')'."


0
Accepted
Cody
Telerik team
answered on 16 Aug 2012, 02:30 PM
Hi Nithin,

I am sorry you have run into this problem. We accidentally introduced a regression in build 2012.1 719. I am emailing you a link to my DropBox folder which contains an updated version with this problem fixed.

All the best,
Cody
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
0
Paul
Top achievements
Rank 1
answered on 17 Aug 2012, 08:15 PM
I am getting this same issue. Could I also get that Dropbox link?

Thanks
0
Cody
Telerik team
answered on 17 Aug 2012, 08:33 PM
Hi,

No need any longer. Today we released a new internal build that contains this fix. You can download it yourself after logging on to your Telerik.com account:
http://www.telerik.com/account/your-products/internal-builds.aspx?type=2&mvid=2897&pid=846 

Kind regards,
Cody
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Tags
General Discussions
Asked by
Reddy
Top achievements
Rank 1
Answers by
Reddy
Top achievements
Rank 1
Cody
Telerik team
Paul
Top achievements
Rank 1
Share this question
or