This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
We are running Maximo 7.6 and Cognos on DB2 and WebSphere. Using the Maximo 7.6 Cognos Feature Guide located here IBM Maximo 76 Cognos Feature Guide - United States http://www-01.ibm.com/support/docview.wss?uid=swg21697011
IBM Maximo 76 Cognos Feature Guide - United States http://www-01.ibm.com/support/docview.wss?uid=swg21697011 Question What features are available with the Maximo 76 Cognos BI Server tools? Answer In the Maximo® 7.6 Release, an integration to the IBM Cognos ® BI Reporting tools is available.
View on www-01.ibm.com http://www-01.ibm.com/support/docview.wss?uid=swg21697011
Preview by Yahoo
I have developed the sample report as defined starting on page 46. After registering the report in Maximo and running it from within the application i get the report prompt page as expected. I can see the Maximo where clause passed to the text box "where" prompt as follows:
( ( WORKORDER.STATUS LIKE '%INPRG%' AND ( WORKORDER.WOCLASS = 'WORKORDER' OR WORKORDER.WOCLASS = 'ACTIVITY' ) AND UPPER( WORKORDER.DESCRIPTION ) LIKE '%FINAL%' AND WORKORDER.HISTORYFLAG = 0 AND WORKORDER.ISTASK = 0 AND WORKORDER.SITEID = 'HOUSTON' ))
When I run the report with that where clause I get the following error:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-69'.UDA-SQL-0043 The underlying database detected an error during processing the SQL request.[IBM][CLI Driver][DB2/NT64] SQL0206N "WORKORDER.STATUS" is not valid in the context where it is used. SQLSTATE=42703
If I take the where clause provided in the text box prompt and remove all references to the object "WORKORDER" the report runs fine with the expected results.
( ( STATUS LIKE '%INPRG%' AND ( WOCLASS = 'WORKORDER' OR WOCLASS = 'ACTIVITY' ) AND UPPER( DESCRIPTION ) LIKE '%FINAL%' AND HISTORYFLAG = 0 AND ISTASK = 0 AND SITEID = 'HOUSTON' ))
Can anyone advise if this is a bug in the software or am I missing something to get the reference to the object removed from the where clause?
Any help would sure be appreciated.
Mike