ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
UIM : audit probe : Wrong Event Time in audit log
Article ID: 186332
Updated On:
Products
DX Unified Infrastructure Management (Nimsoft / UIM)
Issue/Introduction
Wrong and incorrect Event Time is displayed in audit probe GUI
Cause
Data conversion issue in between UIM database and audit probe.
Environment
This issue is confirmed in any version of audit probe with the following senario.
- UIM database is Oracle.
- NLS_LANGUAGE and NLS_TERRITORY are set to regional value, such as Japanese/Japan.
(*) The following query help to verify :
select value from v$parameter where name = 'nls_language';
select value from v$parameter where name = 'nls_territory';
- UIM database is Oracle.
- NLS_LANGUAGE and NLS_TERRITORY are set to regional value, such as Japanese/Japan.
(*) The following query help to verify :
select value from v$parameter where name = 'nls_language';
select value from v$parameter where name = 'nls_territory';
Resolution
Please create the following trigger for UIM database schema.
This trigger dynamically alters NLS values for only audit probe session, which resolves data conversion issue.
(*) sample file (audit_probe_incorrect_event_time.sql) attached to the case.
*********************************************************************************************
create or replace trigger T00258961 after logon on database
declare probe_name varchar2(100);
begin
select program into probe_name
from v$session where audsid=userenv('sessionid');
if (probe_name like '%audit%') then
execute immediate 'ALTER SESSION SET NLS_LANGUAGE=AMERICAN';
execute immediate 'ALTER SESSION SET NLS_TERRITORY=AMERICA';
end if;
end;
/
*********************************************************************************************
This trigger dynamically alters NLS values for only audit probe session, which resolves data conversion issue.
(*) sample file (audit_probe_incorrect_event_time.sql) attached to the case.
*********************************************************************************************
create or replace trigger T00258961 after logon on database
declare probe_name varchar2(100);
begin
select program into probe_name
from v$session where audsid=userenv('sessionid');
if (probe_name like '%audit%') then
execute immediate 'ALTER SESSION SET NLS_LANGUAGE=AMERICAN';
execute immediate 'ALTER SESSION SET NLS_TERRITORY=AMERICA';
end if;
end;
/
*********************************************************************************************
Attachments
Feedback
Yes
No
Powered by
