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

None

Status

Assignee

Mohit Kukreja

Reporter

Mohit Kukreja

Story Size

M

Severity

Show Stopper

Triage

New

Reported in Build #

Fixed in Build

Dev Owner

None

Includes Code Fix

No

Documentation Required

No

Trouble Ticket

None

Requires More Info

None

Journal URL

None

QA Story Points

None

QA Owner

None

Injected

None

Automation Required

None

Code Review Owner

None

Story Points

3

Components

Sprint

None

Fix versions

Affects versions

7.4.0

Priority

High