PI96958: COM.IBM.PAYDIR.DATA.OBJECTS.LOGINDEFINITION OBJECT IS RETURNING GROUPS AS NULL THOUGH THE USER BELONG TO SO MANY GROUPS

3.0.6.0-FTM-ACH-MP-iFix0002

APAR status

• Closed as program error.

Error description

• when we are trying to hit any single call from the SOAP UI with
  the
  LogniUserExit turned on, LoginDefinition object is returning
  group as
  null which may be causing the problem in authenticating the
  user and in
  return getUserPrincipal() object is getting  null (may be) and
  its
  failing at the LoginUserExit
  
  please check the logs for your reference and I am attaching
  code as
  well for code reference
  
  Also, please check the below, user is part of the group
  ---------------------------------------------------------------
  select * from ftm.users where fname like '%fxhadmin%
  ----------------------------------------------------------------
  ---
  
   USERPK  USERID    LNAME          FNAME     EMAIL  PHONE
  LANGUAGELOCALE  FORMATLOCALE  TIMEZONE  SYSUSER  APPID
  LASTLOGIN                ROWTS  CREATED
  CREATED_BY
  LAST_MODIFIED               MODIFIED_BY  LOCKED  LOCK_MODIFIED
  ALLOW_LOCK  ALLOW_DELETE  SHOW_IN_INTERNAL_MSG
   ------  --------  -------------  --------  -----  -----
  --------------  ------------  --------  -------  -----
  -----------------------  -----  --------------------------
  ----------
  --------------------------  -----------  ------  -------------
  ----------  ------------  --------------------
        1 fxhadmin Administrator fxhadmin NULL  NULL  en_US
  en_US        UTC            1     0 2018-04-16 20:29:35.714
  3855 2016-
  09-19 21:02:51.449211 NULL       2018-04-06 18:34:56.291621 NULL
  NULL   NULL          N          N            Y
  ----------------------------------------------------------------
  --
  select * from ftm.user_group_lnk where userpk = 1
     select * from ftm.user_group_lnk
     where userpk = 1
  
  ----------------------------------------------------------------
  -
   USERPK  GROUPID
   ------  -------
        1     141
  
  ----------------------------------------------------------------
  ---
  
  then the group is select * from ftm.groups where groupid = 141
  
  ----------------------------------------------------------------
  -----
   GROUPID  GPNAME            GPDESC
  SYSGROUP  APPID  ROWTS
   -------  ----------------  ----------------------------------
  --------  -----  -----
       141 Webservice Users Default group for Webservice Users
      1
     22     1
  
  ----------------------------------------------------------------
  ----
    select * from ftm.permissions
     where permid in
     (select permid from ftm.group_perm_lnk
     where groupid in
     (select groupid from ftm.user_group_lnk
     where userpk in
     (select userpk from ftm.users
     where fname like '%fxhadmin%')))
  ----------------------------------------------------------------
  --
  
  PERMID PERMNAME PERMDESC PERMCODE FAMID SYSPERM ROWTS FCN_ENT_ID
  1385 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 266 1 1 NULL
  1377 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 263 1 1 NULL
  1376 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 262 1 1 NULL
  1375 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 261 1 1 NULL
  1374 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 260 1 1 NULL
  1373 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 259 1 1 NULL
  1372 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 258 1 1 NULL
  1371 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 257 1 1 NULL
  1370 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 256 1 1 NULL
  1369 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 255 1 1 NULL
  1323 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 242 1 1 NULL
  1324 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 243 1 1 NULL
  1325 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 244 1 1 NULL
  1326 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 245 1 1 NULL
  1327 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 246 1 1 NULL
  1328 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 247 1 1 NULL
  1333 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 248 1 1 NULL
  1334 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 249 1 1 NULL
  1335 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 250 1 1 NULL
  1336 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 251 1 1 NULL
  1344 svc.perm.webservice.ExecuteAll.name
  svc.perm.webservice.ExecuteAll.
  desc ExecuteAll 252 1 1 NULL
  

Local fix

• NA
  

Problem summary

Problem conclusion

• Fixed a problem when logging into webservices which resulted in
  issues with the login user exit.
  

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

  ACH SERVICES FT

• Fixed component ID

  5725S7630

Applicable component levels