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

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

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