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

Recent Upgrade causing Issues

4 Answers 100 Views

General Discussions

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

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

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

Accepted

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Recent Upgrade causing Issues

4 Answers, 1 is accepted