pxRetriveReportdData activity throws Oracle error
pxRetriveReportdData activity is throwing an Oracle error recently.
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.
Due to additional mount options on the shared memory device, /dev/shm, other than just the option named defaults.
ResolutionExamine 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.
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.
Disable the JIT compiler:
Alter system set JAVA_JIT_ENABLED=FALSE scope=both;
Published March 5, 2016 - Updated October 8, 2020
Was this useful?
100% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.