IJ30814: LICENSE USAGE MONITOR - CONFLICTS BETWEEN MAXLICPRODAPPS TABLE AND MAXLICAPPACCESS TABLE

APAR status

• Closed as program error.

Error description

• PROBLEM:
  
  While troubleshooting the UserAnalyzerCronTask
  CronTask, I found the following errors in the log:
  
  [INFO]
  [MxProIFServer1] [CID-CRON-414124] BMXAA6719I - USER =
  (MAXADMIN) SPID = (555) app (null) object (MAXLICPRODAPPS) :
  select * from maxlicprodapps where maxprodid='MAXIMO'
  [INFO]
  [MxProIFServer1] [CID-CRON-414124] BMXAA6719I - USER =
  (MAXADMIN) SPID = (32) app (null) object (MAXLICAPPACCESS) :
  select * from maxlicappaccess where appname='RESLEVEL'
  [ERROR]
  [MxProIFServer1] [CID-CRON-414124] UserAnalyserCrontask found
  that application RESLEVEL is not present in MAXLICAPPACCESS
  table
  [INFO] [MxProIFServer1] [CID-CRON-414124] BMXAA6719I -
  USER = (MAXADMIN) SPID = (33) app (null) object
  (MAXLICAPPACCESS) : select * from maxlicappaccess where
  appname='CUSTAPP'
  [ERROR] [MxProIFServer1] [CID-CRON-414124]
  UserAnalyserCrontask found that application CUSTAPP is not
  present in MAXLICAPPACCESS table
  [INFO] [MxProIFServer1]
  [CID-CRON-414124] BMXAA6719I - USER = (MAXADMIN) SPID = (1078)
  app (null) object (MAXLICAPPACCESS) : select * from
  maxlicappaccess where appname='IPC'
  [ERROR] [MxProIFServer1]
  [CID-CRON-414124] UserAnalyserCrontask found that application
  IPC is not present in MAXLICAPPACCESS table
  
  The RESLEVEL App
  is the "Resource Level Management" application that supports
  Dynamic Job Plans. It should exist in MaxLicAppAccess.
  The IPC
  App was the old "Integrated Parts Catalog" application which I
  don't believe exists anymore. I don't think it should exist in
  MaxLicProdApps.
  CUSTAPP is not a real application. It is what
  MaxApps.OriginalApp is set to when a Custom Application is
  created. I don't think it should exist in MaxLicProdApps.
  I
  believe these errors are preventing the CronTask from counting
  users properly. Please advise.
  Rather than running the
  CronTask, you can check for conflicts by running the
  following:
  SELECT * FROM MaxLicProdApps LPA WHERE MaxProdID =
  'MAXIMO' and NOT EXISTS (SELECT 1 FROM MaxLicAppAccess LAA
  WHERE LAA.AppName = LPA.AppName) ;
  
  
  PERFORMANCE ISSUE:
  NO
  
  STEPS TO REPRODUCE:
  
  1- Go to System Properties
  Application;
  2- Filter by: mxe.db.url to find the
  hostname:port/SID to connect on Database;
  3- On database run
  the following queries SELECT * FROM MAXLICAPPACCESS LPA WHERE
  MaxProdID = 'MAXIMO' and NOT EXISTS (SELECT 1 FROM
  MaxLicAppAccess LAA WHERE LAA.AppName = LPA.AppName);
  MAXIMO	RES
  LEVEL	0	138	762003	MAXIMO
  MAXIMO	CUSTAPP	0	3	762064	MAXIMO
  MAXIM
  O	IPC	0	207	762118	MAXIMO
  
  
  SELECT * FROM MAXLICPRODAPPS WHERE
  AppName NOT IN (SELECT AppName FROM MaxLicAppAccess) ORDER BY
  1, 2 ;
  MAXIMO	CUSTAPP	0	3	762064	MAXIMO
  MAXIMO	IPC	0	207	762118
  MAXIMO
  MAXIMO	RESLEVEL	0	138	762003	MAXIMO
  
  SELECT * FROM
  MAXLICAPPACCESS WHERE AppName NOT IN (SELECT App FROM MaxApps)
  ORDER BY 1, 2 ;
  MAXIMO	CUSTAPP	0	3	762064	MAXIMO
  MAXIMO	DESIGNSP
  EC	0	246	762079	MAXIMO
  MAXIMO	IPC	0	207	762118	MAXIMO
  MAXIMO	PRO
  DUCT	0	245	762080	MAXIMO
  
  SELECT * FROM MAXLICAPPACCESS WHERE
  AppName ='PLUSDCREWM' Or AppName ='PLUSDCREWT' Or AppName
  ='PLUSDGISAD' Or AppName ='PLUSDINVIS' Or AppName ='PLUSDLABRP'
  Or AppName ='PLUSDQCKRP' Or AppName ='PLUSDWORKM'
  Note that
  the following applications PLUSDCREWM, PLUSDCREWT, PLUSDGISAD,
  PLUSDINVIS, PLUSDLABRP, PLUSDQCKRP and PLUSDWORKM are not
  present on table MAXLICAPPACCESS
  
  Custumer said: "The RESLEVEL
  App is the "Resource Level Management" application that
  supports Dynamic Job Plans. It should exist in
  MaxLicAppAccess.
  The IPC App was the old "Integrated Parts
  Catalog" application which I don't believe exists anymore. I
  don't think it should exist in MaxLicProdApps.
  CUSTAPP is not a
  real application. It is what MaxApps.OriginalApp is set to when
  a Custom Application is created. I don't think it should exist
  in MaxLicProdApps.
  I believe these errors are preventing the
  CronTask from counting users properly. Please
  advise."
  
  
  CURRENT ERRONEOUS RESULT:
  The RESLEVEL App is the
  "Resource Level Management" application that supports Dynamic
  Job Plans, is not in MaxLicAppAccess.
  RESLEVEL not present in
  MAXLICAPPACCESS is a bug
  
  
  EXPECTED RESULT:
  
  The RESLEVEL App
  is the "Resource Level Management" application that supports
  Dynamic Job Plans. It should exist in MaxLicAppAccess.
  RESLEVEL
  need to be present in MAXLICAPPACCESS
  
  ENVIRONMENT (SYSTEM
  INFO):
  Tivoli's process automation engine
  7.6.1.1-IFIX20201029-1332 Build 20190514-1348 DB Build
  V7611-365 HFDB Build HF7611-39,
  IBM Maximo Asset Management
  Work Centers 7.6.0.4 Build 20190514-1348 DB Build
  V7604-119,
  IBM Maximo Asset Management Scheduler 7.6.7.3 Build
  20190514-1348 DB Build V7673-78 HFDB Build HF7673-20,
  IBM Tpae
  Integration Framework 7.6.1.1-MIF_7611_IFIX.20201005-0929 Build
  20190422-1259 DB Build V7611-01,
  IBM Maximo Asset Management
  Scheduler Plus 7.6.7.3 Build 20190514-1348 DB Build
  V7673-01,
  IBM Maximo for Utilities 7.6.0.2-20201030-1909 Build
  20171128-1353 DB Build V7602-68 HFDB Build HF7602-13,
  IBM
  Maximo Spatial Asset Management 7.6.0.5-20201027-1144 Build
  20190522-1410 DB Build V7605-09 HFDB Build HF7605-09,
  IBM
  Maximo Asset Management 7.6.1.1 Build 20190514-1348 DB Build
  V7611-01,
  IoT Connection Utility 7.6.0.2 Build 20190426-2206 DB
  Build V7602-07 is starting.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * No users are effected. This defect adds an error entry in    *
  * log                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When an application is present in package file, but the      *
  * application is not present in that environment, License      *
  * Usage Monitor add an error entry in log.                     *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product_
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO SYSTEMS

• Fixed component ID

  5724R46AV

Applicable component levels