I do not know if that is related, but I am getting a very similar error, my installation is bilingual (English/Arabic), current installation is 07.03.04 to upgrade - Version 07.04.00.
Prior to the attempt of upgrade I run the script "Fix PortalSettings issue in DNN 7.3.2 - 7.4.0"
Home page after upgrading
Server Error in '/' Application.
String was not recognized as a valid Boolean.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: String was not recognized as a valid Boolean.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[FormatException: String was not recognized as a valid Boolean.]
System.Boolean.Parse(String value) +14292488
System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +811
DotNetNuke.Collections.CollectionExtensions.ConvertValue(Object value) +263
DotNetNuke.Entities.Portals.PortalSettingsController.LoadPortalSettings(PortalSettings portalSettings) +939
DotNetNuke.Entities.Portals.PortalSettings.BuildPortalSettings(Int32 tabId, PortalInfo portal) +43
DotNetNuke.HttpModules.UrlRewrite.BasicUrlRewriter.RewriteUrl(Object sender, EventArgs e) +1907
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165
|
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212
Error log while updating
DotNetNuke
Upgrade
Current Version - 07.03.04
Upgrade - Version 07.04.00
1Account Info
2Upgrade
View Website
0:44 Minutes | 25% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.CoreMessaging_NotificationTypeActions' with unique index 'IX_CoreMessaging_NotificationTypeActions_Type'. The duplicate key value is (13, 1).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (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:311042db-31b6-4ae5-bb7f-1f57bd579186
Error Number:2601,State:1,Class:14
/* Remove Review action and add Approve, Reject */
DECLARE @NotificationTypeId INT
SELECT @NotificationTypeId = NotificationTypeId
FROM dbo.CoreMessaging_NotificationTypes
WHERE Name = 'ContentWorkflowNotification'
IF @NotificationTypeId IS NOT NULL
BEGIN
/* Delete Review notification action added int 7.3.0 */
DELETE FROM dbo.CoreMessaging_NotificationTypeActions WHERE NotificationTypeId = @NotificationTypeId AND NameResourceKey = 'Review'
/* Add Approve notification action */
INSERT INTO dbo.CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationTypeId,
'Approve',
'Approve',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Approve',
-1,
GETDATE(),
-1,
GETDATE()
)
/* Add Reject notification action */
INSERT INTO dbo.CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationTypeId,
'Reject',
'Reject',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Reject',
-1,
GETDATE(),
-1,
GETDATE()
)
END
System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.CoreMessaging_NotificationTypeActions' with unique index 'IX_CoreMessaging_NotificationTypeActions_Type'. The duplicate key value is (18, 1).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (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:311042db-31b6-4ae5-bb7f-1f57bd579186
Error Number:2601,State:1,Class:14
/* Add action to Start Workflow Notification */
DECLARE @NotificationStartWorkflowTypeId INT
SELECT @NotificationStartWorkflowTypeId = NotificationTypeId
FROM dbo.CoreMessaging_NotificationTypes
WHERE Name = 'ContentWorkflowStartWorkflowNotification'
IF @NotificationStartWorkflowTypeId IS NOT NULL
BEGIN
/* Add Submit notification action */
/* also uses the existing Approve method */
INSERT INTO dbo.CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationStartWorkflowTypeId,
'Submit',
'Submit',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Approve',
-1,
GETDATE(),
-1,
GETDATE()
)
/* Add Discard notification action */
/* also uses the existing Reject method */
INSERT INTO dbo.CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationStartWorkflowTypeId,
'Discard',
'Discard',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Reject',
-1,
GETDATE(),
-1,
GETDATE()
)
END
Retry View Logs
Updating Database
Updating Extensions
Visit Website