This forum is obsolete

This support forum has been replaced by a news version. You can browse old posts in this forum, but please post your questions to the new forum by clicking on "Support" in the top level menu.

Support Forum
Subject: 04.01.00.SqlDataProvider Error on Install
Prev Next
You are not authorized to post a reply.

Author Messages
Brandon Hartsell
Posts:131
Diamond Member

11/11/2010 7:42 AM  
Pengtsen,

I got this error when I installed UVG 4.1.

: SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. 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.UVG_CommercialPick @PortalId int, @CategoryId int, @CurrentUserRoles nvarchar(200), @Max int AS --The probability to pick a commercial, 0 ~ 100 DECLARE @PickProbability int set @PickProbability = 100 --Varibles below should not be changed --The @Rnd varible betweens 0 to 99 DECLARE @Rnd int Select @Rnd = Cast(RAND() * 100 As Int) if @Rnd < (100 - @PickProbability) return create table #UVG_TEMP (ItemId int not null) --Postroll, Preroll, Background, BottomThird insert into #UVG_TEMP SELECT TOP 1 ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 AND dbo.UVG_CommercialIsAppliable(AudienceRoles, ApplyTo, @CurrentUserRoles) = 1 And Type = 3 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() insert into #UVG_TEMP SELECT TOP 1 ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 AND dbo.UVG_CommercialIsAppliable(AudienceRoles, ApplyTo, @CurrentUserRoles) = 1 And Type = 4 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() set rowcount @Max insert into #UVG_TEMP SELECT ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 AND dbo.UVG_CommercialIsAppliable(AudienceRoles, ApplyTo, @CurrentUserRoles) = 1 And Type = 1 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() insert into #UVG_TEMP SELECT ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 AND dbo.UVG_CommercialIsAppliable(AudienceRoles, ApplyTo, @CurrentUserRoles) = 1 And Type = 2 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() set rowcount 0 SELECT * FROM dbo.UVG_Commercial WHERE ItemId IN(SELECT ItemId FROM #UVG_TEMP) drop table #UVG_TEMP

I tried manually runing that script and I get the same error. On my development server videos still play. But on my live server I initially got TypeError: Error #1090 when I tried to play a video. I copied over the contents of \DesktopModules\UltraVideoGallery from the development server and that didn't help. I used the web.config from the development server and that didn't fix the issue. I then copied the entire DNN install from development over to the live server and pointed IIS to that copy after changing the sql connection strings and that fixed the issue. Both the live and the development site were identical before installin UVG on both. So my questions are:

1. why is 04.01.00.SqlDataProvider failing?
2. do I need to worry about it since the UVG seems to be working correctly.
3. what do you think the issue was before I copied over the DNN install from my development server?
Pengtsen R
Posts:13551


11/16/2010 12:14 AM  
please completely unisntall UVG and install UVG 4.1 again, do you still get this problem?

Pengtsen R
http://www.bizmodules.net
Brandon Hartsell
Posts:131
Diamond Member

11/16/2010 8:14 AM  
How do I do this without losing all my videos?
Pengtsen R
Posts:13551


11/17/2010 3:16 PM  
you should have fixed it, don't you?

Pengtsen R
http://www.bizmodules.net
Brandon Hartsell
Posts:131
Diamond Member

11/17/2010 3:21 PM  
yes it runs now. not clear on why this resolved but it runs now.
Pengtsen R
Posts:13551


11/17/2010 3:40 PM  
ok, let me know if you still have trouble with it.

Pengtsen R
http://www.bizmodules.net
You are not authorized to post a reply.
Forums > Ultra Video Gallery > General Questions > 04.01.00.SqlDataProvider Error on Install

Copyright © 2005-2013 BizModules Contact us