We're updating the issue view to help you get more done. 

EVOQSOCIAL: Upgrading Catalyst >> Error in 07.04.00.log.resources

Description

When I upgraded Catalyst from Social (Suite) 2.1.0 to 3.0.0.284, the following error was seen on the auto-upgrade page:

1 0:00:00.403 - Executing Script:07.04.00.SqlDataProvider Error! (see 07.04.00.log.resources for more information)

07.04.00.log.resources file contained the following error:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the CHECK constraint "CK_PortalSettings_CultureCode". The conflict occurred in database "data_catalyst210a", table "dbo.PortalSettings", column 'CultureCode'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, 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 DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:47d39986-470b-4055-88ad-11305d55fc6f IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE parent_object_id = OBJECT_ID(N'dbo.[PortalSettings]') AND name = N'CK_PortalSettings_CultureCode') ALTER TABLE dbo.[PortalSettings] ADD CONSTRAINT [CK_PortalSettings_CultureCode] CHECK (CultureCode != '')

In the database, running the following query showed one row:

1 Select * from PortalSettings where CultureCode = ' '

PortalID

SettingName

SettingValue

CreatedByUserID

CreatedOnDate

LastModifiedByUserID

LastModifiedOnDate

CultureCode

0

Search_ReindexRequestedOn

2014-05-07 19:03:07.688

-1

2013-10-11 15:04:17.793

3

2014-05-07 19:03:06.733

QA Test Plan

Status

Assignee

Mohit Kukreja

Reporter

Mohit Kukreja

Story Size

M

Severity

Show Stopper

Triage

New

Reported in Build #

Fixed in Build

Includes Code Fix

No

Documentation Required

No

Story Points

3

Epic Link

Components

Sprint

None

Fix versions

Affects versions

7.4.0

Priority

High