Developer forum

Forum » CMS - Standard features » Indie Collation Problem

Indie Collation Problem

E-mail notifications
Marius Tudor
Marius Tudor
Reply
Posted on 20/01/2020 15:48:51

Hello,

We have the following issue when using the Item Publisher for Hindu culture website :

System.Data.SqlClient.SqlException (0x80131904): Invalid collation 'Indic_General_90'.
   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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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 Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Content.Items.Queries.Repository.SelectInternal(IEnumerable`1 ids, Query query)
   at Dynamicweb.Content.Items.Queries.Repository.SelectByIds(IEnumerable`1 ids, Query query, Boolean checkPermissions, Boolean includeInheritedItems)
   at Dynamicweb.ItemPublisher.Frontend.GetItems()
   at Dynamicweb.ItemPublisher.Frontend.List()
   at Dynamicweb.ItemPublisher.Frontend.GetContent()
   at Dynamicweb.Frontend.Content.GetModuleOutput(Paragraph paragraph, PageView pageview)
ClientConnectionId:9430660b-513a-4088-99c6-c3304a927b51
Error Number:448,State:1,Class:16

We looked in Dynamicweb's source code in Dynamicweb.Data/Helpers.cs, in v9.7 (see the attached screenshot) and there is this invalid culture Indic_General_90, which is not recognized on SQL Server. There should've been Indic_General_90_CI_AS or another combination.

Regards,

Marius

 

Screenshot_2020-01-20_at_16.33.10.png

Replies

 
Nicolai Pedersen
Posted on 20/01/2020 16:42:51
Reply

Good find.

I have created bug TFS#74484 and made the change and sent it to test. You will be able to upgrade Dynamicweb.Data to the next release of the package to solve the problem.

BR Nicolai

 
Marius Tudor
Marius Tudor
Posted on 21/01/2020 12:17:27
Reply

Thank you, 

Looking forward for the next update.

Best Regards, 

Marius

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 05/02/2020 13:20:59
Reply

Hi Marius

The problem regarding #74484 "Wrong collation for Hindu culture on website settings" has now been resolved in Dynamicweb version 9.7.6

To upgrade please choose this version from download:

http://doc.dynamicweb.com/releases-and-downloads/releases

Let me know if you need any more help regarding this

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 
Marius Tudor
Marius Tudor
Posted on 05/02/2020 13:30:56
Reply

Hi Kristian, 

Thank you.

 

 

You must be logged in to post in the forum