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 Problem 6.2.5 > 7.3.4: 7.00.00 sqldataproviderUpgrade Problem 6.2.5 > 7.3.4: 7.00.00 sqldataprovider
Previous
 
Next
New Post
1/24/2015 8:21 AM
 

Hi

I have made a Upgrade from a 6.2.5 Installation to a 7.3.4 DNN. The are several Portals in the Installation.

There is a Problem with the 7.00.00 sqldataprovider scripts. The error Log says:

System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'PortalID', table 'CL70032_mssqlc3992d823c8c99dfe1b257123d48dd75.usre2d685f0bbb3ef661bf9c2eb2d3e5741.ModulePermission'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection. (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:b600b481-e279-4d82-ac2d-f0e9219e5965
Error Number:515,State:2,Class:16

ALTER TABLE usre2d685f0bbb3ef661bf9c2eb2d3e5741.ModulePermission
    ALTER COLUMN PortalID int NOT NULL

Several symtpons are now in the running installation:

  • Very slow response time per page (5-15seconds)
  • Can't save settings change in a portal (f.e. name of a portal)
  • WISIWIG Editor not visible

Can somebody help me, what can I do.

Greetings from Switzerland
Daniel

 
New Post
1/25/2015 4:18 AM
 
Daniel,
please run the following Statement in Host > SQL to identify the rows with offending permissions:
SELECT * FROM usre2d685f0bbb3ef661bf9c2eb2d3e5741.ModulePermission WHERE PortalID Is NULL

IF it Returns just very few rows, you may run the following Statements to fix it:
DELETE FROM usre2d685f0bbb3ef661bf9c2eb2d3e5741.ModulePermission WHERE PortalID IS Null;
GO
ALTER TABLE usre2d685f0bbb3ef661bf9c2eb2d3e5741.ModulePermission
ALTER COLUMN PortalID int NOT NULL
GO

You might need to rerun the full script afterwards and all subsequent ones, to make sure,you get the proper Version of all procedures.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/25/2015 11:09 AM
 

Dear Sebastian

I run the first SQL-Query: No results ( Die Abfrage hat keine Ergebnisse gelieferrt.)

Shoudl I rerun als the Query in "07.00.00.SqlDataProvider".

Greetings
Daniel

 
New Post
1/25/2015 11:22 AM
 

I have also see in the DNN event log some entries like:

  • Host Alert , UpgradeNet Upgraded Site to NET 4.0 
  • Web Server Updated ,Server Updated SERVER25 IISAppName /LM/W3SVC/259/ROOT/cms Last Activity Da

 Is the system doing something in the backgroud?

Greeting
Daniel

 

 
New Post
1/25/2015 2:20 PM
 

Hi

I have found in the DNN Event log other entries, that may help:

  • THREAD ID:32, TYPE:DotNetNuke.Services.Social.Messaging.Scheduler.CoreMessagingScheduler, DotNetNuke, EXCEPTION:Invalid object name 'usre2d685f0bbb3ef661bf9c2eb2d3e5741.ScheduleItemSettings'.
  • AssemblyVersion:7.3.4, PortalID:-1, PortalName: UserID:-1, UserName: ,ActiveTabID:-1, ActiveTabName:, RawURL:, AbsoluteURL:, AbsoluteURLReferrer:, UserAgent:, DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke, ExceptionGUID:513d0e49-66f1-44ae-b008-71e5f3373594, InnerException:Invalid object name 'usre2d685f0bbb3ef661bf9c2eb2d3e5741.ScheduleItemSettings'., FileName:, FileLineNumber:0, FileColumnNumber:0, Method:System.Data.SqlClient.SqlConnection. , StackTrace:, Message:
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'usre2d685f0bbb3ef661bf9c2eb2d3e5741.ScheduleItemSettings'.
    at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)...

Greetings
Daniel

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade Problem 6.2.5 > 7.3.4: 7.00.00 sqldataproviderUpgrade Problem 6.2.5 > 7.3.4: 7.00.00 sqldataprovider


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.