IBM Support

IJ02311: SECURITYRESTRICTID IS PASSING TO QUERY TO WITH , AS THOUSAND SEPERATOR IN WHERE CLAUSE FOR SECURITYRESTRICT OBJECT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Securityrestrictid is passing to query to with , as thousand
    seperator in where clause for securityrestrict object.
    
    Steps
    =====
    1. Log in with maxadmin
    2. go to Users application
    3. Select any user.  (wilson)
    4. Go to Security profile
    5. Select any leaf level attribute --> select- BEDFORD
    
    ERROR:
    ========
    Database Error 911 shown when section Data Restrictions is
    expanded in tab Security Profile in application Users.
    
    Snippet of logs:
    ================
    Still in the query value 1,471 is coming instead of 1471.
    
     [9/21/17 10:12:10:022 CEST] 00000031 SystemOut     O 21 Sep
    2017
     10:12:10:022 [INFO] [MAXIMOTESTUI] [] BMXAA6719I - USER =
    (HPEMMASA)
     SPID = (201) app (null) object (SECURITYRESTRICT) : select *
    from
     securityrestrict  where groupname in (select groupname from
    groupuser
     where userid =  'SNYHOLM' )
    
     [9/21/17 10:12:10:426 CEST] 00000031 SystemOut     O 21 Sep
    2017
     10:12:10:426 [INFO] [MAXIMOTESTUI] [] BMXAA6719I - USER =
    (HPEMMASA)
     SPID = (148) app (null) object (SECURITYRESTRICT) : select
    count(*)
    from
     securityrestrict  where securityrestrictid in
    (274,236,56,240,241,234,227,48,272,239,1,471,331,330,242,243,273
    )
    
    Application effected
    ====================
    securityrestrict
    
    Analysis
    ========
    The code is doing a getString instead of a getLong which is
    causing the issue.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When over 1000 security restrictions exist, Maximo may       *
    * encounter errors expanding the UI tree in the Users          *
    * application, under Security Restrictions.                    *
    ****************************************************************
    * 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

    IJ02311

  • Reported component name

    SYSTEM CONFIG

  • Reported component ID

    5724R46S1

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-01

  • Closed date

    2017-12-04

  • Last modified date

    2017-12-04

  • 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



Document information

More support for: Maximo Asset Management

Software version: 750

Reference #: IJ02311

Modified date: 04 December 2017