Tuesday Aug 14, 2012

Is There a User Interface to Manage LOG_IT Logging Actions?

The only way to configure LOG_IT is to update the data in the LOG_IT_PARAMS table.

First see if LOG_IT logging is available in that version for the procedure

SELECT * FROM log_it_params WHERE pname = 'API_CREATE_ORA_DEM_USER'

To update the logging level to 3 for the API procedure it to run.

UPDATE LOG_IT_PARAMS
SET logging_level = 3
WHERE pname = 'API_CREATE_ORA_DEM_USER';

COMMIT;

Check the update is there.
SELECT * FROM log_it_params WHERE pname = 'API_CREATE_ORA_DEM_USER'

This should run a trigger that re-creates LOG_IT with 'API_CREATE_ORA_DEM_USER' added to an IF condition.

When you run the procedure to test it should create a log table 'LOG_API_CREATE_ORA_DEM_USER'

IF LOG_IT did not get rebuilt to include 'API_CREATE_ORA_DEM_USER' then rebuild it manually

EXEC BUILD_LOG_IT_PROCEDURE; -- rebuilds log_it
EXEC BUILD_ORDER_COMPILE -- Makes a list of invalid procedures.
EXEC COMPILE_ALL; -- recompiles all the invalid procedures.
 
See document 1408753.1 Demantra LOG_IT Setup Excecution Explanation ORA Errors Detailed Log Production

About

This blog delivers the latest information regarding performance and install/upgrade. Comments welcome

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today