Survey Forums

HomeHomeSurvey Project ...Survey Project ...Using Survey & ...Using Survey & ...This Textual reports error This Textual reports error
Previous
 
Next
New Post
9/12/2012 10:36 AM
 

Apparently  the other thread's page bugged on me, so I remade it. Please delete the other thread named: Textual reports error.

 This is the error I get when selecting Textual reports:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near ']'.
Incorrect syntax near '_3'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_120'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_123'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_124'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_132'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_152'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_246'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_311'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_312'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_601'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_602'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_603'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_621'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_689'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_713'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_788'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_789'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_790'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_808'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_888'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_889'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_890'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_925'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_926'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_983'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_987'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near ']'.
Incorrect syntax near '_1093'.
Incorrect syntax near the keyword 'FROM'.
Incorrect syntax near the keyword 'as'.

 

 

Why is this happening and how can I fix it?

 
New Post
9/12/2012 10:41 AM
 

this is the ending of the stack trace:

System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1753346
   System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295154
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +1325
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +175
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +140
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +88
   Votations.NSurvey.SQLServerDAL.Voter.GetVotersTextEntries(Int32 surveyId, Int32 pageNumber, Int32 pageSize, DateTime startDate, DateTime endDate) +349
   Votations.NSurvey.WebAdmin.FieldReporting.BindData() +148
   Votations.NSurvey.WebAdmin.FieldReporting.Page_Load(Object sender, EventArgs e) +213
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772 

 
New Post
9/17/2012 9:57 PM
 
Hello,

This may have to do with the changes you made earlier? You should certainly check the data that is saved and the effect it has on the queries (Stored procedures) used by the reports. These data seem to corrupt the correct working of the queries.

 
New Post
9/18/2012 9:42 AM
 

It used to be like that ever since I installed it, meaning before I touch stored procedures etc.

Note: In stored procedures I simply touched the vts_spVoterResumeSession one where it says:

WHERE SurveyID  = @SurveyID AND ResumeUid = @ResumeUid  Validated=1

and removed the Validated=1 .So basically its not something that would really make something like that.

 

 EDIT: Also I tried to figure out the numbers:

_3, _120, _123, etc... They are nowhere in my database. And I cleaned voters several times but the numbers remain the same. So that means they are either related to the questions or something else.

 

EDIT#2:  I imported one of the survey samples and it worked perfectly. I thought it might be the questions, so I was thinking that instead of having the questions themselves show up on the header of the table, perhaps to show the question ID. Where should I look for this part of the code that places the questions in the header? I thought it was FieldReporting.aspx but I cant seem to find any reference to it.

 

Also I am also working on the files I downloaded from codeplex, but Im having a problem. Say I want to modify the FieldReport.aspx  . This is connected to FieldReport.aspx.cs ,  FieldReport.aspx.resx, FieldReport.aspx.designer.cs etc but these are nowhere in the folders of the actual application. Is there some sort of compilation I need to apply or something?

 

EDIT#3:  Ok it seems that the problem is that the Answer Text field in the answer settings in designer mode cannot have braces '[' or ']'.

 
Previous
 
Next
HomeHomeSurvey Project ...Survey Project ...Using Survey & ...Using Survey & ...This Textual reports error This Textual reports error