IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Mon February 23, 2015 07:51 AM

    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.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 2.  RE: Not able to log more than 1024 char in Activitylog.FullMessage field

    Posted Mon February 23, 2015 10:18 AM

    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


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 3.  RE: Not able to log more than 1024 char in Activitylog.FullMessage field

    Posted Tue February 24, 2015 01:18 AM

    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.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 4.  RE: Not able to log more than 1024 char in Activitylog.FullMessage field

    Posted Tue February 24, 2015 06:52 AM

    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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


Related Content