Hello,
I have just updated the DNN installation of my sister, after having successfully upgraded mine. But on my sister upgrade (4.5.1 to 4.5.5), I have the following error in the
"Upgrade Log for version"
System.Data.SqlClient.SqlException: There is insufficient system memory to run this query.
Could not create constraint. See previous errors.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* add unique constraint */
ALTER TABLE dbo.Permission ADD CONSTRAINT
IX_Permission UNIQUE NONCLUSTERED
(
PermissionCode,
ModuleDefID,
PermissionKey
) ON [PRIMARY]
What's this, and what should I do ???
My sister do not have the same hosting provider than me, is it a problem with the hosting provider ???
DV FX