PSA: 12.1 with Oracle seemingly not deactivating JOBP

Discussion created by Carsten_Schmitz on Feb 5, 2018
Latest reply on Feb 12, 2018 by Carsten_Schmitz

Anyone on Oracle with 12.1? Remember the funky error message from my V12.1 findings?

It appears it's not just when you manually want to deactivate a job plan. It appears the system can not deactivate JOBP either, I suspect this has to do with Oracle. Would appreciate a shout if someone else is on Oracle with 12.1 (or 12.0 maybe) about your mileage.

Currently our 12.1 system has 16000 active JOBP and overall 50000 objects in a non-deactivated state after about three weeks, because seemingly no job plans are ever deactivated:


Of course, nobody will readily see this, because the counters in the activity window (not just the list, but the overall counters also) only count to 500. If you add all the categories of the counters, it's always 500:


Uhm, well.

In any case, I bumped the severity of the open incident.

Best regards,

edit, p.s.: just to be sure I'm not barking up the wrong tree, I made a totally empty JOBP and set it to "always deactivate". I ran it. It triggers the log message, and does not deactivate.