R12.2 Apps DBA. Powered by Blogger.

Unable to Run a specific Control R12.2

No comments :
LOG FILE
-----------------------
Filename = grc.log
See the following error:
jobId = 1995
2015-12-21 04:21:58,299 DEBUG [Thread-10] JobRunService:284 Found JobRun in persistence for jobId = 1995, isFinished(): true
2015-12-21 04:21:58,301 ERROR [GrcExecutorThread-1] i:179 Error occured while persisting into berkeley db.
java.lang.OutOfMemoryError: Java heap space
at java.lang.reflect.Array.newInstance(Array.java:70)
at oracle.jdbc.driver.BufferCache.get(BufferCache.java:229)
at oracle.jdbc.driver.PhysicalConnection.getCharBuffer(PhysicalConnection.java:12333)
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3084)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13251)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:881)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
EXPECTED BEHAVIOR
-----------------------
Control Analysis to be complete as expected
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to the GRC
2. CCM > Manage Control >
3. Select the control " P2P: Enter Requisition and Enter Purchase Order "
3. Run and monitor the job Setup and Administration > Manage job
Solution:
To Implement the solution, perform the below steps on the non-production instance first1
note : Ensure backup plans are in place1
1. Login to the Application
Setup and Administration > Manage Application Configuration > properties tab,
please update the number of cores to 8 which is 1 now
ie., currently system has number cores 8 * number process 8 = 8*8
2. Bring down the application server
3. Move the logs - grc.log and Adminserver.log to backup
4. Update limits.conf as per the installation guide
http://docs.oracle.com/cd/E51797_01/doc.8651/e52268.pdf
Section : Prerequisites
page : 1-2
5. Bounce the OS
6. Make the below changes for DB as recommended
http://docs.oracle.com/cd/E51797_01/doc.8651/e52268.pdf
Section : Creating GRC and DA Schemas
page : 1-3
expected values :
deferred_segment_creation FALSE
processes 3000
7.Increase the temp storage to min 8GB
8. Retest the issue by running controls
9. Once satisfied Migrate the solution to other instance.

1. In the front end, properties tab,
please update the number of cores which is 1 now
2. Update limits.conf as per the installation guide
http://docs.oracle.com/cd/E51797_01/doc.8651/e52268.pdf
Section : Prerequisites
page : 1-2
3. Update DB parameters
http://docs.oracle.com/cd/E51797_01/doc.8651/e52268.pdf
Section : Creating GRC and DA Schemas
page : 1-3
deferred_segment_creation FALSE
processes 3000
4.Increase the temp storage to min 8GB
5. Retest the issue

No comments :

Post a Comment

Note: only a member of this blog may post a comment.