KB42250: "[ERROR: pg_atoi: error in "2011-01": cant parse "-01"]" error message is seen in the DSSErrors.log while executing a report or running a subscription in MicroStrategy 9.x

SYMPTOM:
 
The following error message is seen in the DSSErrors.log while executing a report or running a subscription in Strategy 9.x:
 

2013-01-03 09:00:01.737-05:00 Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ERROR:  pg_atoi: error in "2011-01": can't parse "-01" Connection String:
DSN=DSN##;DATABASE=DB###;SERVERNAME=SERVER##;UID=LOGIN;PORT=5480;READONLY=0;SQLBITONEZERO=0;LEGACYSQLTABLES=0;
NUMERICASCHAR=0;SHOWSYSTEMTABLES=0;LOGINTIMEOUT=0;QUERYTIMEOUT=0;DATEFORMAT=1;SECURITYLEVEL=preferredUnSecured;CACERTFILE=;. SQL Statement: ...

 
CAUSE:
 
This Netezza error is due to the comparison of non-matching data types in the "where" clause of the SQL statement.
 
ACTION:
 
Change the column alias for that object to an integer type data type.