Skip to Main Content
Status Released
Workspace CONNX
Created by Stephane Moreau
Created on Jul 27, 2021

missing datestamp/datetime for for lines in the connxjdbc64.log file

When a error is logged into the connxjdbc64.log, and when this error is logged in more than 1 line (with complementary information), only the first line have a datestamp.

Please find a example here below :

Mar 16 14:47:46.920 2018@LM_ERROR @ UPTIME:(00 02:49:19.321 ) IP:(10.198.140.106 ) TID:(3496203328)==> 2010(E): (40001): Unable to get record from table (CO_SL_PARAMETERS).
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream

------------------

So when we want to do a grep on a precise word (like "lock") in the log, we lost the datetime information, as this information is not logged for these precise lines...

[root@dvihcasc1r log]# grep lock connxjdbc64.log
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream
>>> Error Executing Query: STAT:5 ERR:98986 SQLSTATE:S1000 Error retrieving record. %E, target record currently locked by another stream


Our needs only consist to have a datetime for all the output message, even the complementary information lines.

Created on Brainstorm 3/23/2018 3:56
Brainstorm ID 5803