Click here to Skip to main content
15,896,154 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

i am getting System.Collections.ListDictionaryInternal exception in asp.net code.this exception is comming once in a while not contineously.

i am getting this exception while reading information from the table.

i am using sql 2005 as backend.

can anybody help me to solve this issue?

detailed Exception is as shown below:

21-12-2009 03:01:12:421 ERR Exception while reading Queue Exists details from txpm0qud & column 5 : 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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at TescoPrintManager.LPDListener.SQLRead(String tableName, String Query, String Parameter, Int32 columnToRead)

any help on this?

Thanks and Regards
Vidhya
Posted
Updated 20-Dec-09 20:37pm
v2

1 solution

I've had this too, I think there's a bug in some of the collections. I had a bug the first time I tried to do a lookup, but afterwards it was fine, so I added a try/catch that did a meaningless lookup, and it sometimes blows up, but then my code runs fine. If that doesn't work for you, you could try posting the actual error message, and the code.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900