Large Amount Of Archive Log Files Are Generated During Mgp Process And Compose/Apply Cycle Error (Doc ID 1199103.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.3.0.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2013***

Symptoms

On : 10.3.0.3.0 version, Mobile Server

When attempting to Compose/apply the data the MGP fails with the error Ora-00942 and it does not truncate the CLG$tables which increase the Amount of Archives.


ERROR
-----------------------
ORA-00942


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. start MGP
2. All the MGP Cycle fails with the Error Ora-00842
3. the MGP does not truncate the clg$tables and keep all their records which are composing again and increase the Amount of Archives.


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