iFinity

Products » Support Forums 
  Search

Support Forums

HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...SQL2K Incompatibility?SQL2K Incompatibility?
Previous
 
Next
New Post
7/28/2009 8:42 PM
 
Ken Tarwood
Just Learning

Joined: 7/24/2009
Posts: 6

Sorry for the delay Bruce - just noticed the reply this AM.

 

We're currently running 04.09.04 CE.

 

 

Thanks,

Ken
 
New Post
8/4/2009 8:15 PM
 
Ken Tarwood
Just Learning

Joined: 7/24/2009
Posts: 6

Bruce,

 

Here's a bit of an update: I realized the arithmetic overflow was coming from the ifty_ilm_GetTabs sproc so I did a little debugging and saw that it was inserting (among other things) tabs' taborder and level into a temporary table. I checked my Tabs table and it looks like some of the "TabOrder" values go as high as 10037. I'm guessing this is where the glitch is occuring because I tried executing the following:

create table #taborder (tabId int, tabOrder int,parentTabId int, parentOrder int, tabLevel int)
SELECT t.tabOrder * power(10,5 - coalesce(p.tabLevel + 1, t.[Level]) + 2)
FROM Tabs t
left join #tabOrder p
on t.ParentId = p.TabId
where t.portalId = 0
and ((p.tabLevel + 1 = 0 and t.ParentId is not null)
or  (t.[Level] = 0 and t.ParentId is null))

And got the same error:

Server: Msg 8115, Level 16, State 2, Line 3
Arithmetic overflow error converting expression to data type int.

Thanks for the help!
 
New Post
8/5/2009 10:45 AM
 
Bruce Chapman
Chief Poster

Joined: 3/9/2006
Posts: 3122

Ken - thanks a lot for this extra information.  I had tried so far in vain to recreate the error, so this might point me in the right direction.   You don't have any taborder values of zero , do you?
 
New Post
8/5/2009 7:36 PM
 
Ken Tarwood
Just Learning

Joined: 7/24/2009
Posts: 6

Bruce,

 

Nope - the lowest value is 1.

 

Thanks!

Ken
 
New Post
8/25/2009 12:50 PM
 
Bruce Chapman
Chief Poster

Joined: 3/9/2006
Posts: 3122

Ken

I've been working on this one, but so far a satisfactory solution has eluded me.  You did identify the right spot, but I haven't had much luck in working out a different way to achieve the same thing.   I hope to have it solved soon.  The problem is actually related to DNN 5 installs, and I think your installation is DNN 4.x.  If this is the case, you don't need the extra queries, as all of the calculations causing the problem as simply a way to attempt to get a satsifactory order for the return of the tab list for the UI.  For a temporary fix, you can rewrite the query to just return the tabs using the 'tabOrder' as per the Tabs table. 

Either that, or I should have a fix out in the next couple of days.

-Bruce
 
 Page 2 of 3
Previous123Next 
Previous
 
Next
HomeHomeDotNetNuke Modu...DotNetNuke Modu...Inline Link Mas...Inline Link Mas...SQL2K Incompatibility?SQL2K Incompatibility?


Support Guidelines.. Please read before posting

To get support on iFinity products and services, please search the forums for the the answer to the problem you are seeking. If you cannot find a solution, post a question in the relevant forum.   Ensure that you specify the relevant versions of the problem, and the actual error message or a detailed description of the problem.    You will need to register with this site to post on the forum.  If you have a Microsoft Live (Hotmail/Passport) account you can use that.  If you have a Open Id account you can use that.  If you neither of these, you will need to register a user Id and password.

Services

iFinity is a Microsoft Bizspark Member

All site content copyright © iFinity 2006-2011 Terms Of Use Privacy Statement