IBM Support

IJ02788: WITH MXE.DB.USESITELISTINQUERY SET TO 1,bad sql code generated when SystemOrgType = SystemSite

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • PROBLEM:
With system property mxe.db.UseSiteListInQuery set to 1,
bad sql code generated when SystemOrgType = SystemSite.

STEPS TO REPRODUCE:
System property mxe.db.UseSiteListInQueryset to 0 - Add a
result set to the Start
Center that is based off WORKORDER - it will pass SQL similar
to:

select count(*) from ( select * from workorder where exists
((select
siteid from siteauth a1,groupuser b1,maxgroup
m1,applicationauth t1
where b1.userid = :L0 and b1.groupname=a1.groupname and
b1.groupname=m1.groupname and m1.indep
endent = :L1 and a1.groupname = t1.groupname and t1.app = :L2
and ...

or (jobplan.siteid is null and jobplan.orgid is null)) left
outer join
asset on workorder.assetnum = asset.asse
tnum and workorder.siteid = asset.siteid left outer join
locations on
workorder.location = locations.location and workorder.siteid =
locations.siteid left outer join ci on workorder.cinum =
ci.cinum left
outer join failureremark as f on
workorder.wonum = f.wonum and workorder.siteid = f.siteid where
(

When mxe.db.UseSiteListInQueryis set to 1:

Open a SR - try to close the SR when you don't have Authorize
Group for
All sites - the following SQL will be passed:

[9/27/17 19:01:36:538 UTC] 000013c3 SystemOut O 27 Sep 2017
19:01:36:416 [ERROR] [maximo_ui3] [] BMXAA6714E - The data for
the next
reco
rd in the mboset could not be retrieved for the SQL query
select * from
pmsccr where (pmsccrnum= '') and (((orgid is null and siteid is
nul
l
com.ibm.db2.jcc.am.SqlSyntaxErrorException: An unexpected token
"'CHAD4'" was found following "is null) or exists (". Expected
tokens
may include: "<values>".. SQLCODE=-104, SQLSTATE=42601,
DRIVER=4.11.69


at com.ibm.db2.jcc.am.jn.executeQuery(jn.java:658)
at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3186)
at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2798)
at psdi.mbo.MboSet.fetchMbos(MboSet.java:2755)
at psdi.mbo.MboSet.getMbo(MboSet.java:2002)
at psdi.mbo.MboSet.isEmpty(MboSet.java:4264)
at
com.ibm.ism.pmsc.cr.SRStatusChangeListener.eventAction(SRStatusC
hangeLis
tener.java:137)
at
psdi.server.event.EventTopic$Subscription.eventAction(EventTopic
.java:72
3)
at psdi.server.event.EventTopic.eventAction(EventTopic.java:291)
at
psdi.server.event.EventTopicTree.genericSubsAction(EventTopicTre
e.java:1
422)
at
psdi.server.event.EventTopicTree.eventAction(EventTopicTree.java
:730)
at psdi.mbo.StatefulMbo.fireEvent(StatefulMbo.java:808)



CURRENT ERRONEOUS RESULT:  Maximo generated sql has errors.

EXPECTED RESULT:  Maximo generated sql will not have errors.

ADDITIONAL INFO:
It appears to be caused by SiteOrgRestriction class.  This
problem is specific to SITEORGTYPE=
SYSTEMSITE.

ENVIRONMENT (SYSTEM INFO):
Rational Team Concert and Rational ClearQuest Integration for
IBM
Control Desk 7.6.0.0202 Build BUILD DB Build V7511-00
Survey Management for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7511-01
Service Desk Classification Content for IBM Control Desk
7.6.0.0202
Build 201507210000 DB Build V7511-00
TPAE OSLC Object Structure 7.6.1.0 Build 20160907_132614-0500
DB Build
V7610-15
Quick Configuration for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7511-00
IBM Maximo for Service Providers 7.6.0.0 Build 20141125-1930 DB
Build
V7600-05
Screen Capturer for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7530-00
IBM Maximo Anywhere 7.6.1.0 Build 20160907_132639-0500 DB Build
V7610-10
Asset Management for IBM Control Desk 7.6.0.0202 Build
201507210026 DB
Build V7600-06
Instant Messaging Integration for IBM Control Desk 7.6.0.0202
Build
201507210000 DB Build V7200-02
Service Desk for IBM Control Desk 7.6.0.0202 Build 201507210000
DB
Build V7600-02
Incident Management for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7530-02
IBM Maximo Asset Management 7.6.0.1 Build 20150611-1135 DB Build
V7601-01
Service Catalog for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7600-05
SLA Hold for IBM Control Desk 7.6.0.0202 Build 201507210000 DB
Build
V7530-01
Self Service Center for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7520-01
Tivoli's process automation engine 7.6.0.1 Build 20150611-1135
DB Build
V7601-65
Service Portal for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7540-25
IBM TPAE Integration Framework 7.6.0.1 Build 20150610-1800 DB
Build
V7601-07
IBM Endpoint Manager Integration Enablement 7.6.0.0202 Build
201507210000 DB Build V7530-09
Service Desk Integration MEA for IBM Control Desk 7.6.0.0202
Build
201507210000 DB Build V7530-00
Configuration Items CMS LIC for IBM Control Desk 7.6.0.0202
Build
201507210000 DB Build V7511-00
Service Desk Everyplace for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7510-03
Release management for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7600-01
Configuration management for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7530-02
SmartCloud Provisioning and SmartCloud Orchestration Integration
7.6.0.0202 Build 201507210000 DB Build V7511-04
Service Request Management for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7600-01
Solution for IBM Control Desk 7.6.0.0202 Build 201507210000 DB
Build
V7520-02
IBM Maximo Mobile 7.5.1.0-20160219-1431 Build 20130603-1027 DB
Build
V7510-05 HFDB Build HF7510-05
User interface widgets for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7600-02
Data Integration and Context Menu Service Configuration 7.5.0.0
Build
20090911D2 DB Build V7117-07
Change management for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7540-03
Common process components for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7600-03
IBM Endpoint Manager Integration Configuration 7.6.0.0202 Build
201507210000 DB Build V7530-11
Search for IBM Control Desk 7.6.0.0202 Build 201507210000 DB
Build
V7530-01
Instant Messaging for IBM Control Desk 7.6.0.0202 Build
201507210000 DB
Build V7530-00
Configuration items for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7600-01
Advanced Workflow Components for IBM Control Desk 7.6.0.0202
Build
201507210000 DB Build V7600-01
OSLC Support for IBM Control Desk 7.6.0.0202 Build
201507210026M DB
Build V750-06
TPM Integration Module for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7510-01
IBM Tivoli Integration Composer for IBM Control Desk 7.6.0.0202
Build
201507210026 DB Build V7560-01
Problem Management for IBM Control Desk 7.6.0.0202 Build
201507210000
DB Build V7540-01
Live Chat for IBM Control Desk 7.6.0.0202 Build 201507210000 DB
Build
V7530-01
Tivoli Remote Diagnostics for IBM Control Desk 7.6.0.0202 Build
201507210000 DB Build V7511-00

DB2/LINUXX8664 10.5 (SQL10055)

Local fix

  • na

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* When the system property 'mxe.db.UseSiteListInQuery' is set  *
* to 1 or 2, under certain circumstances, invalid SQL may be   *
* generated against an object with siteorgtype of SYSTEMSITE.  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Problem conclusion

  • The fix for this APAR is included in the following package:
                        | Release 7.6.1.0 of Base Services.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IJ02788
    • 

  • Reported component name
    SYSTEM CONFIG
    • 

  • Reported component ID
    5724R46S1
    • 

  • Reported release
    760
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-12-20
    • 

  • Closed date
    2018-01-17
    • 

  • Last modified date
    2018-01-17
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    SYSTEM CONFIG
    • 

  • Fixed component ID
    5724R46S1
    • 



Applicable component levels


    

  • R760  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            17 January 2018
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback