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

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 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