Not able to log more than 1024 char in Activitylog.FullMessage field

, ,
1

Hi All,

I am getting below error when ever I try to log message to TN and if message length is more than 1024 chars. Is there any limitation for the FullMessage in ActivityLog table or is it possible to increase the the field size. We are currently working on wM9.6 environment.

“[TNS.0000.2054I] Data for column ActivityLog.FullMessage will not fit. So, truncating it from 8171 characters to 1024 characters.”

Quick hep would be really appreciated.

2

Hi Rajesh,

the messahe is not really an error, but just a info, that the message being logged does not fit into the column and that will be shortened before inserting.

This means that only the first 1024 characters are persisted, the rest will get lost due to truncation.

You can try to increase the length of the column:

  • alter table ActivityLog modify FullMessage varchar2(4000)

Restart the IS to be sure that the caches get refreshed accordingly.

Regards,
Holger

3

Hi Thomsen,

Thanks for the quick reply. We are using wM 9.6 version. We will take appropriate step either we will truncate the message before sending it to TN or alter the table as suggested by you.

Regards,
Rajesh.

4

Hi Rajesh,

there is no need to truncate the message, this automatically done by the IS.

This is what is also stated in the error message:
“[TNS.0000.2054I] Data for column ActivityLog.FullMessage will not fit. So, truncating it from 8171 characters to 1024 characters.”.

Regards,
Holger