August 7, 2013
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
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:
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.
Most Users Ever Online: 54
sun kim: 60
Guest Posters: 0
Newest Members:Tanzina Tanny, Allabasha shaik, Lindsey Mata, Jihene MAAZ, Charline Roche, Abhijeet Dutta
Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0