Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Problem after updating the CMS to 12.15

Vote:
 

Got this strang error when init CMS after upgrade from 12.8 to 12.15:

SqlException: @Binary is not a parameter for procedure netContentListPaged

Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString, bool isInternal, bool forDescribeParameterEncryption, bool shouldCacheForAlwaysEncrypted)
Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, bool isAsync, int timeout, out Task task, bool asyncWrite, bool inRetry, SqlDataReader ds, bool describeParameterEncryptionRequest)
Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, TaskCompletionSource<object> completion, int timeout, out Task task, out bool usedCache, bool asyncWrite, bool inRetry, string method)
Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
EPiServer.DataAccess.Internal.ContentListDB.ReadPublishedList(DbCommand cmd)
EPiServer.Data.Providers.Internal.SqlDatabaseExecutor+<>c__DisplayClass24_0<TResult>.<Execute>b__0()
EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute<TResult>(Func<TResult> method)
EPiServer.DataAccess.Internal.ContentListDB.LoadSpecificContentInstances(IList<ContentReference> contentLinks, int languageBranchID)
EPiServer.Core.Internal.DefaultContentProvider.BatchLoad(IList<ContentReference> contentLinks, Func<IList<ContentReference>, IList<IContent>> dbLoader)
EPiServer.Core.Internal.DefaultContentProvider.LoadContents(IList<ContentReference> contentReferences, ILanguageSelector selector)
EPiServer.Core.ContentProvider.GetContentBatch(IList<ContentReference> batch, ILanguageSelector selector, ref List<IContent> contents, ref Dictionary<ContentReference, int> contentMap)
EPiServer.Core.ContentProvider.GetScatteredContents(IEnumerable<ContentReference> contentLinks, ILanguageSelector selector)
EPiServer.Core.Internal.ProviderPipelineImplementation.GetItems(ContentProvider provider, IList<ContentReference> contentLinks, LoaderOptions loaderOptions)
EPiServer.Core.Internal.DefaultContentLoader.GetChildren<T>(ContentReference contentLink, LoaderOptions loaderOptions, int startIndex, int maxRows)
EPiServer.Core.Internal.DefaultContentLoader.GetChildren<T>(ContentReference contentLink, LoaderOptions loaderOptions)
Krimprod.Mvc.Business.Services.RepositoryService.GetAll<T>(ContentReference rootLink)+MoveNext() in RepositoryService.cs
+

     var children = this._contentLoader.GetChildren<PageData>(rootLink);
#293565
Dec 22, 2022 21:41
Vote:
 

The problem was i had ref to Episerver.CMS only, in csproj. And the package had no ref to Episerver.CMS.Core. So that package didnt update.

So the solution is to att reference to EPiServer.CMS.Core, and update to latest (now 12.11)

Lesson learned: Add direct ref to packages in csproj.

        <PackageReference Include="EPiServer.CMS" Version="12.15.0" />
        <PackageReference Include="EPiServer.CMS.Core" Version="12.11.0" />
        <PackageReference Include="EPiServer.Framework" Version="12.11.0" />
        <PackageReference Include="EPiServer.Framework.AspNetCore" Version="12.11.0" />

Regards Luc

#293566
Dec 22, 2022 21:47
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* 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.