Maximo Open Forum

 View Only

 IFACETABLECONSUMER Not Working

  • Integrations
Ajay Kotapati's profile image
Ajay Kotapati posted 03-01-2024 18:19

Hi All,

IFACETABLECONSUMER cron task not reading data from the interface table. Below is the error in the logs but not sure what is the root cause for null pointer exception. Any clue on this ?

[DEBUG] [MAXIMO] [CID-CRON-1665] Method ACTION is called on IFACETABLECONSUMER.CCC1
[02/03/24 03:11:49:361 GST] 0014abd1 SystemOut     O &&& empty error
[02/03/24 03:11:49:361 GST] 0014abd1 SystemOut     O 02 Mar 2024 03:11:49:361 [ERROR] [MAXIMO] [CID-CRON-1665] 
java.lang.NullPointerException
    at psdi.iface.intertables.IfaceTbCronTask.releaseDBResources(IfaceTbCronTask.java:473)
    at psdi.iface.intertables.IfaceTbCronTask.checkProceed(IfaceTbCronTask.java:647)
    at psdi.iface.intertables.IfaceTbCronTask.processIfaceData(IfaceTbCronTask.java:813)
    at psdi.iface.intertables.IfaceTbCronTask.cronAction(IfaceTbCronTask.java:516)
    at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:2471)
    at psdi.server.CronTaskManager.access$1100(CronTaskManager.java:104)
    at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:3363)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:483)
    at java.util.concurrent.FutureTask.run(FutureTask.java:274)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:190)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
    at java.lang.Thread.run(Thread.java:809)

Thanks,

 Ajay

Michael Marsonet's profile image
Michael Marsonet posted 03-02-2024 14:52

Can you provide some more detail such as 

  1. Is this a new IFACETABLE or an existing one?
  2. Has a Maximo patch been applied recently?

You may want to try and recreate the IFACETABLE from External Systems as an initial debugging step. Make sure you select the backup option when you do this. If it has no issues creating the IFACE table then try re-running the Cron to see if that works. If the IFACE fails to create you likely will get a better error message that will hopefully point you in the right direction. Based on the error you provided there may be a lock on the table at the DB level. 

Mike

Related Content