Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Maximo 7.6 & Cognos Where Clause
Removing the object reference from the Maximo where clause passed to Cognos
May 7, 2015
7:47 am
Avatar
craving94509
Member
Members
Forum Posts: 13
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

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:

RQP-DEF-0177
space.gif
    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

 

May 8, 2015
1:58 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13577

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1528

Posts: 4195

Newest Members:

yoga bagus, CoET.bobo, sopra sopra, Tamizan Alibhai, Alan Drake, Ibrahim Abdalla

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0