Maximo List Archive

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.



Maximo 7.6 & Cognos Where Clause

From: mlevinson (2015-05-07 04:44)

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