November Happy Hour will be moved to Thursday December 5th.

Error when trying to pick XForm

Vote:
 

I get this error when I hit the ... button that should show a list of XForms. The site is upgraded from EPiServer 6 to 8.11
It only occurs on one of the sites (the one in pruduction sadly)

Has anyone seen this and if so,is there a cure?

Server Error in '/' Application.

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. 
  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: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

Source Error: 


 An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 



[SqlException (0x80131904): An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3242916
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +345
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4927
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +92
   System.Data.SqlClient.SqlDataReader.get_MetaData() +102
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +552
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3140
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +554
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +98
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +307
   EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.ExecuteReader(Query query, IDbCommand command, ProviderCallContext providerCallContext) +138
   EPiServer.Data.Dynamic.Providers.<>c__DisplayClass30`1.b__2f() +565
   EPiServer.Data.Providers.<>c__DisplayClass2f`1.b__2e() +56
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +882
   EPiServer.Data.Dynamic.Linq.Query`1.Execute() +317
   EPiServer.Data.Dynamic.Linq.Query`1.System.Collections.IEnumerable.GetEnumerator() +14
   EPiServer.XForms.XForm.GetXformsList(IEnumerable formsPropsList) +108
   EPiServer.UI.Edit.XFormSelect.GetPages(String formFolder, Boolean myFormsOnly, String formId, String sortExpression, Int32 maximumRows, Int32 startRowIndex, Int32& rowCount) +1553

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +128
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +146
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +951
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1916
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +26
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +139
   System.Web.UI.WebControls.GridView.OnPreRender(EventArgs e) +45
   System.Web.UI.Control.PreRenderRecursiveInternal() +107
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Control.PreRenderRecursiveInternal() +204
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4171

  


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.81.0  



#141956
Nov 25, 2015 11:16
Vote:
 

Upgrade the EPiServer.UI, worked for me: http://world.episerver.com/documentation/Release-Notes/ReleaseNote/?releaseNoteId=CMS-1460

#142244
Dec 07, 2015 13:05
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.