Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Please help with intermitent errorsPlease help with intermitent errors
Previous
 
Next
New Post
6/7/2009 2:26 AM
 

Hi,

I've encountered a very, very strange situation in my application. I say strange because the errors are **intermitent** and I cannot find out the cause why they occur.

I've pass a sqlcommand to the DB (Sql 2005) trying to get a bigint (column ID_Facultate) from a single table. The problem is that I've got a string (Lecture name) that has nothing to do with the that table.

Also, when I get these errors, **all** my modules (accessing another database from the same sql2005 instance) are going crazy, while the DNN is fine...

In the SQL Profiler everything seems fine (the last executing rows seem to be the ones sent by my application)

Here are some links to 3 captured screens during the errors and the code I've used . Please note the Watch1 with the **very wrong** string value where I expected some integer

http://www.unitbv.ro/cata/errors/2.jpg
http://www.unitbv.ro/cata/errors/3.jpg
http://www.unitbv.ro/cata/errors/1.jpg


Please HELP !!!!!

Catalin

 
New Post
6/7/2009 3:29 AM
 

This is most likely a db error and not an error with your code ....if you have moved the database but only used copy tables and values THEN the database incremental fields are not set properly .... this field that normally increments by itself doesn't anymore .... try to move you 100% functional database with making a backup and restore this backup in a new location THEN you code would very much likely start working again with the new databse location ..... try this and keep us posted how this are going for you

/Johan Hyra vattenskoter

 
New Post
6/7/2009 3:35 PM
 

we have checked the DB with the DBCC command and there are no errors. Also we do regular (at every 8 hours) automatic backups and we use some of these bak for development on other machines. I do not think this is the cause because we would be aware of errors on restore...

Catalin

 
New Post
6/7/2009 4:30 PM
 

In screen dump nr 2 there is a SQL statement that says: SELECT ID_Facultate From Facultate where PortalID=   ... this means you are grabbing all posts of Facultate there is in the db inside a certain portalID ... BUT you only retrieve the field ID_Facultate according to your SQL Statement .... BUT in the VS debugger watch window you have code that says idr.fieldcount=4 ?? ... how is this possible .... then you have idr[0] is a string but this doesn't seam right when looking in your SQL statement .... doesnät this has something to do with why your code is breaking?

/Johan Hyra vattenskoter

 
New Post
6/8/2009 2:07 AM
 

These that you mentioned are exactly my problems.... strange, isn't it ?

Catalin

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Please help with intermitent errorsPlease help with intermitent errors


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out