The SCC_CG_ATTDET Table Grows Very Large From Failed Runs of SCC_COMMGEN (Doc ID 1258686.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On : CS9 version, Communication Generation

Find the record SCC_CG_ATTDET can grow quite large (95G+). Failed runs of SCC_COMMGEN contribute to the size as using the reset communication process does not delete the rows from that record. Additionally the rows in records SCC_CG_ATTENV, and SCC_CG_ATTREL also are not being deleted by reset communications.

EXPECTED BEHAVIOR
-----------------------
Expect these records to have extraneous data removed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Reset Communication
2 View the data still in the records

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can have Commgen fail due to lack of space.

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