Uploaded image for project: 'DNN Platform'
  1. DNN-27463

Installation finished with SqlException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Complete
    • Affects Version/s: 7.1.0
    • Fix Version/s: 7.1.1
    • Component/s: Localization - Static
    • Labels:
      None
    • Severity:
      Major
    • Triage:
      Triaged
    • Documentation Required:
      No
    • Sprint:
      Sprint 0

      Description

      Hi,
      Installation finished with SqlException.
      Steps to reproduce:
      1. Install PE/EE package with German/Nederlands lannguage and Default/Mobile Template.
      2. Check log.resources file on Host Settings -> Logs page.
      Actual result:
      Error message is present
      2013-07-02 17:24:54,943 [DNN-PC36][Thread:40][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_HostSettings'. Cannot insert duplicate key in object 'dbo.HostSettings'.The statement has been terminated. at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.DataProvider.AddHostSetting(String SettingName, String SettingValue, Boolean SettingIsSecure, Int32 CreatedByUserID) at DotNetNuke.Entities.Controllers.HostController.Update(ConfigurationSetting config, Boolean clearCache)ClientConnectionId:943d35de-981d-4595-adc2-6ecbdefe2079"
       
      Note:
      mostly affected  combinations are:

      • PE German-Default template;
      • PE German-Mobile Template;
      • PE Nederlands-Default template;
      • PE Nederlands-Mobile Template.
        Occasionally happens for EE package with Spanish, Mobile Template; EE package with French, Mobile Template.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Natasha.zavorotny Natasha Zavorotny (Inactive)
            • Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support