Performance Issue Observed When Data Is Inserted Into S_VALDN_INST

(Doc ID 1946751.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel CRM - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.

Symptoms


When a data validation is triggered data is inserted into S_VALDN_INST.
During the insertion we see spike sin the database which is causing application slowness and thus causing performance issues to the user/Agent.


Expected Behavior:
-------------------

Only have History logging for events where Status =  Error. It seems that S_VALDN_INST table gets blown up with millions of records with   Status = 'Completed'.
Not willing to have Logging disabled as they still need to check for the Error events.



Actual Behavior:
------------------

Currently, The validation history can be reviewed via Site Map >  Administration  Data Validation > Validation History.
This shows the result of each rule evaluated. If the history is not required, then the Enable Log parameter in the business service context can
be set to N. However, the Validation History shows the results of all rules evaluated whether they return errors or not


 

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