reset the t_log sequence values

Products

• CA Business Service Insight

Issue/Introduction

While entries exist in the t_log table, they cannot be viewed in the User Interface - an error is returned that a number is too large.

Environment

Release:
Component: OBLCRE

Cause

This is caused when the sequence number in the t_log table goes over the 32-bit signed integer limit, and requires the values to be reset.

Resolution

First shutdown the service "Oblicore - LogServer" on the App server. 
Then truncate the table t_log in the database. 
Then drop the sequence seq_sla_log. 
Then execute this script to recreate the sequence: 

CREATE SEQUENCE oblicore.SEQ_SLA_LOG 
START WITH 1000 
MAXVALUE 9999999999 
MINVALUE 1000 
CYCLE 
CACHE 25 
NOORDER; 

GRANT select ON oblicore.SEQ_SLA_LOG to role_usr_reg_privs; 

Finally, it is possible to restart the "Oblicore - LogServer" service to collect log entries for inserting into the database again.