30. Database Tier - Invalid Objects

It is important not to have invalid objects in the IFS database. These checks will monitor if invalid triggers, packages, bodies or views exists. If invalid objects still exist it might impact business processes.

Multiple Instances: No

Interval: Every 5 minutes (288 times per day)

Status

Expression

Critical

If (Invalid Triggers > 0) or (Invalid Packages > 0) or (Invalid Bodies > 0) or (Invalid Views > 0)

Impact	An object is in an invalid state and might impact business processes.
Suggestion	Try to recompile (IEE: Solution Manager\System Information and Utilities\Oracle Objects\Compile Invalid Objects). Still error, check latest delivery, customization and configurations.

If not status Critical.

Unknown

Missing application response.

Metric & Service	Command line example
Invalid Triggers	java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_TRIGGERS -ca=0
Invalid Packages	java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_PACKAGES -ca=0
Invalid Bodies	java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_BODIES -ca=0
Invalid Views	java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_VIEWS -ca=0