Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade to 4.5.5 for my sister -->System.Data.SqlClient.SqlException ...Upgrade to 4.5.5 for my sister -->System.Data.SqlClient.SqlException ...
Previous
 
Next
New Post
8/6/2007 7:10 AM
 
Declic Video


Joined: 11/25/2006
Posts: 1069

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
 
New Post
8/6/2007 10:56 AM
 
Guy Jascht

Joined: 7/26/2006
Posts: 262

Declic Video wrote

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. ...



Hmm, maybe you have really short of memory - what system do you have / what provider do you've and how much space is granted?

 
 
New Post
8/6/2007 12:10 PM
 
Declic Video


Joined: 11/25/2006
Posts: 1069

She is with Ultimahosts.net
And I had confirmation of the provider...

Hello,

This error relates to a restriction on our MSSQL server which stops long running queries. This is basically designed to ensure that the server is not overloaded. The solution to this is to update your database locally and then restore it to our MSSQL servers. You can do this via our backup and restore function.

The other solution is that we can give you some space on a different MSSQL server which doesn't have the above restrictions. You would still need to backup and restore to the server as well.

If you have any questions please let me know.

 

Not so great...

DV FX
 
New Post
8/6/2007 2:57 PM
 
Guy Jascht

Joined: 7/26/2006
Posts: 262

Regarding the insufficient memory it's limited by the settings of your mssql server - it make some (a lot of)  sense when you developon your workstation; when you're using a well setuped server that's a minor aspect.

But now SQL query: it tells you that the table Permission which has an indice will be changed by the triple PermissionCode, ModuleDefID, PermissionKey is unique but not grouped (NONCLUSTERED). Below do you find SQL Statement when you create this table- the interesting thing is the constraint. But why do you think that this statement stresses your memory - normally are 10 - 20 lines in this table ??? 

USE [DNN]
GO
/****** Objekt: Table [dbo].[dnn_Permission] Skriptdatum: 08/06/2007 20:34:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dnn_Permission](
[PermissionID] [int] IDENTITY(1,1) NOT NULL,
[PermissionCode] [varchar](50) NOT NULL,
[ModuleDefID] [int] NOT NULL,
[PermissionKey] [varchar](20) NOT NULL,
[PermissionName] [varchar](50) NOT NULL,
CONSTRAINT [PK_dnn_Permission] PRIMARY KEY CLUSTERED
(
[PermissionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_dnn_Permission] UNIQUE NONCLUSTERED
(
[PermissionCode] ASC,
[ModuleDefID] ASC,
[PermissionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
 
New Post
8/6/2007 3:00 PM
 
Declic Video


Joined: 11/25/2006
Posts: 1069

Excuse me jascht, I am not so strong with SQL, and I have not understood your question/advice...
I do not think anything, I have just copied the answer from my provider, telling me that the server is restricted to avoid big query which creates problems....

Should I run the query that you indicate to solve the problem once upgraded ???

 

DV FX
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade to 4.5.5 for my sister -->System.Data.SqlClient.SqlException ...Upgrade to 4.5.5 for my sister -->System.Data.SqlClient.SqlException ...


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out