I have been having big problems with the scheduler, in that everytime I turn it on error massages appear in the event viewer... and nothing actually seems to run although it says it does (eg forum emails shown in database table are not sent, and schedule history says it was successful but no emails were there to send).

The error showing is:

There should be no reason for a 'real' timeout, and both scheduled items show in the history as having run.

What I am thinking of doing, in an attempt to resolve this (but I would like to run the latest DNN anyway) is upgrade to v4.8.2 from v4.6.2.

Can this be done direct, or do I first have to upgrade to v4.7 and run the installation/upgrade script?

Also... looking in the last upgrade log it says:

Upgrade Status Report
00:00:00.031 - Upgrading to Version: 4.6.2
00:00:00.109 -   Executing Script: 04.04.01.SqlDataProvider Error! (see 04.04.01.log for more information)
00:00:00.843 -   Executing Script: 04.05.00.SqlDataProvider Error! (see 04.05.00.log for more information)
00:00:04.281 -   Executing Script: 04.05.01.SqlDataProvider Success
00:00:04.562 -   Executing Script: 04.05.02.SqlDataProvider Error! (see 04.05.02.log for more information)
00:00:05.687 -   Executing Script: 04.05.03.SqlDataProvider Success
00:00:06.062 -   Executing Script: 04.05.04.SqlDataProvider Error! (see 04.05.04.log for more information)
00:00:06.234 -   Executing Script: 04.05.05.SqlDataProvider Success
00:00:06.265 -   Executing Script: 04.06.00.SqlDataProvider Success
00:00:08.515 -   Executing Script: 04.06.01.SqlDataProvider Success
00:00:08.546 -   Executing Script: 04.06.02.SqlDataProvider Success
00:00:08.562 - Performing General Upgrades
00:00:10.484 - Installing Package File LiveID_01.00.00_Install:  Success
00:00:11.265 - Installing Package File OpenID_01.00.00_Install:  Success

I would like to resolve this, so it runs clean when I next upgrade.  Taking it just a step at a time, the first logs show:

log 4.4.1->

System.Data.SqlClient.SqlException: Ambiguous column name 'PortalId'.
Ambiguous column name 'PortalId'.
   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)

CREATE procedure dbo.[tacuk_GetPortalRoles]

 @PortalId     int

AS
 SELECT R.RoleId,
     R.PortalId,
     R.RoleGroupId,
     R.RoleName,
     R.Description,
     'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
     'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
     'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
     'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
     'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
     'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
     'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
     'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
     RSVPCode,
     IconFile
 FROM dbo.tacuk_Roles R
 LEFT OUTER JOIN dbo.tacuk_Lists L1 ON R.BillingFrequency = L1.Value
 LEFT OUTER JOIN dbo.tacuk_Lists L2 ON R.TrialFrequency = L2.Value
 WHERE  ( PortalId = @PortalId OR PortalId is null )
  AND L1.ListName='Frequency'
  AND L2.ListName='Frequency'
 ORDER BY R.RoleName

 and Log 4.5 ->

System.Data.SqlClient.SqlException: The object 'IX_tacuk_TabPermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
   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)

ALTER TABLE dbo.tacuk_TabPermission
 DROP COLUMN RoleID

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.tacuk_TabPermission' is specified more than once.
   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)

ALTER TABLE dbo.tacuk_TabPermission ADD
 RoleID int NULL

System.Data.SqlClient.SqlException: The object 'IX_tacuk_ModulePermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
   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)

ALTER TABLE dbo.tacuk_ModulePermission
 DROP COLUMN RoleID

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.tacuk_ModulePermission' is specified more than once.
   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)

ALTER TABLE dbo.tacuk_ModulePermission ADD
 RoleID int NULL

System.Data.SqlClient.SqlException: The object 'IX_tacuk_FolderPermission' is dependent on column 'RoleID'.
ALTER TABLE DROP COLUMN RoleID failed because one or more objects access this column.
   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)

ALTER TABLE dbo.tacuk_FolderPermission
 DROP COLUMN RoleID

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'RoleID' in table 'dbo.tacuk_FolderPermission' is specified more than once.
   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)

ALTER TABLE dbo.tacuk_FolderPermission ADD
 RoleID int NULL

Where might I start in fixing what those relates to? Could these have led to the problems? Are they likely to cause further problems with upgrading?

Any help is appreciated.

Thanks

David

Hi Sebastian

I have done this and compared the files and they all seem to be fine.

Just ran the update (felt comfortable with full backups ;-) and so far all is well. No errors showed and appears to be running. Have a bit to go through, but hoping the scheduler problem will have been sorted... fingers crossed.

Thanks