Error When Synchronizing Business Object: PagingGrccChannelManager:511 Error occurred while creating a Page. (Doc ID 1933410.1)

Last updated on OCTOBER 10, 2014

Applies to:

Oracle Transaction Controls Governor - Version 8.6.5 and later
Information in this document applies to any platform.

Symptoms

On :  8.6.5 version, While running TCG sync at model level it is erroring out.

When attempting to run a TCG sync for  a model with BO of journal entries
the following error occurs.

ERROR
-----------------------
When the BO of journal entries sync mark me the following error:

2014-09-23 22:57:30,246 ERROR [pool-49-thread-1] PagingGrccChannelManager:511 Error occurred while creating a Page.
oracle.apps.grc.reasonerio.exception.PageIOException: Problem to build PageChannel.
at oracle.apps.grc.reasonerio.file.page.PageManager.createNewPage(PageManager.java:105)
at oracle.apps.grc.reasonerio.file.page.PagingGrccChannelManager.expandChannel(PagingGrccChannelManager.java:508)
at oracle.apps.grc.reasonerio.file.page.PageChannelController.(PageChannelController.java:79)
at oracle.apps.grc.reasonerio.file.page.PagingGrccChannelManager.createChannel(PagingGrccChannelManager.java:466)
at oracle.apps.grc.reasonerio.file.page.PagingGrccChannelManager.createChannel(PagingGrccChannelManager.java:447)
at oracle.apps.grc.reasonerio.file.io.sort.TemplateSorter.preSort(TemplateSorter.java:245)
at oracle.apps.grc.reasonerio.file.io.sort.TemplateSorter.sort(TemplateSorter.java:191)
at oracle.apps.grc.reasonerio.graph.blockbytype.BBTGraphFactory.sort(BBTGraphFactory.java:285)
at oracle.apps.grc.reasonerio.berkeley.TcgEtlSortingService$NodeSorter.run(TcgEtlSortingService.java:559)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.io.FileNotFoundException: /grcrep/ETL/temp.repository/paging_2182814574009088925/grcc_pr_file.007 (Too many open files)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to GRC application.
2. Go to CCM-> Create Transaction Model
3.  Add BO of journal entries and add some filters.
4. Run sync at model level. Can see the error in the grc.log.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this particular BO in their model.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms