000029050 - DB2 data feed error in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029050
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.0
Platform: Windows
IssueError is received with this log message:
3 3 0 1 5.5.0.1279 VMIMN14GLBSMQC ArcherTech.DataFeed Unknown SQL type - -360. /LM/W3SVC/1/ROOT/Archer-1-130601748477118247 111114-152242-0543 System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Unknown SQL type - -360. System.Data at System.Data.Odbc.TypeMap.FromSqlType(SQL_TYPE sqltype) at System.Data.Odbc.OdbcDataReader.BuildMetaDataInfo() at System.Data.Odbc.OdbcDataReader.GetSchemaTable() at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetSchemaSetForDataReader(IDataReader reader) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetDatabaseQuerySchemaSet(XDocument configXDoc) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetSchemaSetWithConfig(Stream streamConfigAndSource)
CauseThis issue occurs when the wrong type of data is passed into a specific column in SQL.
In the example below, we were trying to input a sting into an int type through the use of a CASE statement.
CASE
     WHEN table.column = value THEN 1
     WHEN table.column <> value THEN 'NoValue'
END

Where the column being inserted into is an int type.
WorkaroundChange your data condition to account for the proper data type. 

To extend on our example from the 'cause':

 
CASE
     WHEN table.column = value THEN 1
     WHEN table.column <> value THEN 0
END

Attachments

    Outcomes