KB185: Profile containing Marquee may some times throw a DBNull...

Expand / Collapse
 

KB185: Profile containing Marquee may some times throw a DBNull exception



Symptoms:

Occasionally, a profile containing a Marquee will cause an exception to occur.  This exception will be similar to "The value for column 'Abandoned' in table 'tblQueueNow' is DBNull.", with the column name possibly being different.

Cause:

 

This error occurs when the marquee fetches the data for a particular variable (related to the column in the error message), and this column is DBNull (contains no data) for the device in question.  Under normal circumstances, this value should never be empty, as the state will always contain data.  However, under a narrow and peculiar set of circumstances, it is possibly to temporarily enter such a state.

Resolution:

The component responsible for fetching the data will now return the "unknow" value when this situation occurs.  Instead of throwing an error, the message will contain '??' or a related value until we receive valid data and the message updates itself.

How to apply this fix:

This hotfix must be installed on your Enterprise Server and you must be running version 5.1 SP3
Download the hotfix to your server from here: KB185
Double click the .exe file and follow the instructions.

 



Rate this Article:
     
Tags:

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Sunday, January 23, 2011
Last Modified By: kmiddlemiss
Type: HOTFIX
Article not rated yet.
Article has been viewed 2,627 times.
Options