Product(s):	APM Implementation and Performance Management
	Version(s):	all
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A
	Defect Number:	080272

Defect Description

Issue 080272 - Does not Contain filtering operator on HTML attribute column causes application to crash

Steps to Reproduce

When selecting to view a configuration, the server crashes with the following error:

1. An error has occurred.

   database.cpp(2919):

   Failed Assert: Database Statement Error:

   DBErrorType = 'dbStatement'

   Native SQL Code = 402

   ODBC sqlstate = 37000

   ODBC errortext = '[Microsoft][SQL Server Native Client 10.0][SQL Server]The data types text and varchar are incompatible in the equal to operator.'

Workaround

Advise users to not use DOES NOT CONTAIN column filter on columns that are HTML fields (typically Description fields)

Fixed in R7.7

Original Author:

Giselle Crawford