Recent Upgrade causing Issues

[Reddy]

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

[Reddy]

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 ')'."

[Cody]

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

[Paul]

I am getting this same issue. Could I also get that Dropbox link?

Thanks

[Cody]

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