RegisterLogin
 Search  
Customer Service

  You are here:  Customer ServiceForums   

The Doyle ITS Forums are designed for:

  • General discussion around Doyle ITS products or services
  • Enhancement requests - If you believe a Doyle ITS product should include a new feature, describe it here.
  • Functionality questions - Ask any "how to" questions about Doyle ITS products
  • Support issues - If you encounter a defect, do not hesitate to report it here
  • Product How-To - Doyle ITS product documentation will be posted in each product's forum

SearchForum Home
  DNN Module Support  Roster  Install 1.2.2 e...
 Install 1.2.2 exception/failure
 
 8/17/2008 10:10:12 AM
User is offlineintelligentnetware
4 posts


Install 1.2.2 exception/failure

During the install of Roster 1.2.2 I got this error:

StartJob Start Sql execution: 01.02.01.SqlDataProvider file

Failure SQL Execution resulted in following Exceptions:

System.Data.SqlClient.SqlException: Invalid object name 'dbo.DoyleITS_Roster_GetItemCount'. 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 procedure [dbo].[DoyleITS_Roster_GetItemCount] @OwnerId int, @ItemName nvarchar(100), @Admin bit as if (@ItemName is not null) begin if (@ItemName = 'RosterType') begin select lst.RosterListId as ItemId, lst.[Text] as [Name], lst.SortOrder, count(r.RosterTypeId) as [Count] from [dbo].[DoyleITS_Roster] r inner join [dbo].[DoyleITS_Roster_List] lst on r.RosterTypeId = lst.RosterListId where r.ModuleId = @OwnerId and (@Admin = 1 or r.Published = 1) group by lst.RosterListId, lst.[Text], lst.SortOrder order by lst.SortOrder end else if (@ItemName = 'RosterTermMember') begin select t.RosterTermId as ItemId, t.TermName as [Name], count(rmt.RosterMemberId) as [Count] from [dbo].[DoyleITS_Roster_Term] t inner join [dbo].[DoyleITS_Roster_MemberTerm] rmt on t.RosterTermId = rmt.RosterTermId where t.RosterId = @OwnerId group by t.RosterTermId, t.TermName end else begin select 0 as ItemId, '' as [Name], 0 as [Count] end end else begin select 0 as ItemId, '' as [Name], 0 as [Count] end 
EndJob End Sql execution: 01.02.01.SqlDataProvider file

Your thoughts?

 8/17/2008 4:49:34 PM
User is offlineintelligentnetware
4 posts


Re: Install 1.2.2 exception/failure

I've re-installed the module and the second time it passed without error.

 

  DNN Module Support  Roster  Install 1.2.2 e...
Home | DNN Modules | Resources | Customer Service
  Copyright ©2005-2010 Doyle ITS   Terms Of Use  Privacy Statement