Error occurs with a SQL Metric when you specify the Instance column with a column from SQL that returns a numeric value

Article:TECH153110  |  Created: 2011-02-10  |  Updated: 2011-03-04  |  Article URL http://www.symantec.com/docs/TECH153110
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



If you create a SQL Metric and specify in the Instance column option a column from SQL that returns a numeric value, then during polling Real-Time Performance Viewer (RTPV) indicates that the instance column is invalid and errors occur in debugger.


Error



[5476] [TRA] AgentProfiler: Not configured to profile metrics. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [ERR] CADOSql::GetDataType, Exception caught Error - 800A0CC1. 
[4204] [INF] metrics initialized, let's roll... 
[4204] [INF] Restart LogProcessThread.
 


Environment



Server with database and integer needed.

Server with database where some INT rows are in the tables.


Cause



Values are not displayed in RTPV because SQL columns which return INT values are processed incorrectly.


Solution



Do not use SQL INT type rows as Instance columns.




Article URL http://www.symantec.com/docs/TECH153110


Terms of use for this information are found in Legal Notices