SA-20521

Summary

pxRetriveReportdData activity is throwing an Oracle error recently.

Error Messages

There was a problem getting a list: code: 29516 SQLState: 99999 Message: ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3422
Bulk load of method java/util/regex/Pattern.pattern failed; insufficient shm-object space

Steps to Reproduce

Call pxRetriveReportdData activity from an activity.

Root Cause

Due to additional mount options on the shared memory device, /dev/shm, other than just the option named defaults.

Resolution

Examine the mount options in file /etc/fstab. If any additional mount options are observed after the word “defaults” for /dev/shm, such as nosuid, nodev, or noexec then this is likely the root cause.

For example:

none /dev/shm tmpfs defaults,nosuid,nodev,noexec 0 0

Remove these options from the entry in /etc/fstab:

none /dev/shm tmpfs defaults 0 0

Shut down the database instance, and reboot the system.  Restart the database instance.

Or

Disable the JIT compiler:

Alter system set JAVA_JIT_ENABLED=FALSE scope=both;