Try our conversational search powered by Generative AI!

XForm: Error when xform property targets paginated xform

Fixed in

EPiServer.CMS.UI 9.3.1

(Or a related package)

Created

Sep 15, 2015

Updated

Jun 27, 2018

Area

CMS UI

State

Closed, Fixed and tested


Description

Could be a .NET 4.6 related issue

  1. On a page/block, select an XForm on Page 2 in the paginated list.
  2. Save and publish the page/block.
  3. Go back and open the XForm Selector again.

Expected: To see the XForm selected on Page 2.
Actual: SQL select exception.

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.<ExecuteList>b_2f() +565
EPiServer.Data.Providers.<>c_DisplayClass1`1.<Execute>b_0() +51
EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +922
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) +1613

[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