App Connect

Expand all | Collapse all


  • 1.  Logging

    Posted Thu July 29, 2021 12:11 PM
    I'm new to ACE and after reading the documentation it is still not clear for me how to enable logging to what my "code" is doing.  For example I would like to know how to check what the SQL of the MappingNode when Select Rows From Database is executed.

    Thank you,

    Diego Alcorta

  • 2.  RE: Logging

    Posted Fri July 30, 2021 06:26 AM
    Hi Diego,

    I would start with user trace,


    I find user trace most helpful to see what is happening within my ACE code.


    Martin Evans
    Integration Architect
    IBM Expert Labs

  • 3.  RE: Logging

    Posted 16 days ago

    there are several options (sorted from easiest to hardest to implement):
    • use trace node - built-in, no configuration, very slow, but usable even for production
    • user trace - built-in, almost no configuration (just 3 commands), very slow, but records everything what happens in a flow, not usable for production - limited "space" for log records, usable for "debugging" a flow
    • log statement - writes records to event log directly from ESQL, built-in, no configuration needed, I do not know performance characteristics but I assume that it is rather slow
    • monitoring events - publishes events to MQ topic which can be subscribed by external application which processes log records and stores them to DB, file, elasticsearch or whatsoever storage. Publishing of events is built-in but you must implement the processing application. Monitoring must be configured everytime a flow is deployed. 
    • external logging framework - usually some JAVA frameworks like Log4J2 or Logback, needs external libraries, needs external configuration and some level of custom built code. Mentioned logging frameworks provides quite large amount of flexibility in regards of configuring loggers, levels, layoust, appenders etc.

    Martin Citron

  • 4.  RE: Logging

    Posted 15 days ago
    Hello Diego,

    One useful log is the Activity Log. Activity Logs help you to understand what your message flows are doing. You can find everything in the following link:

    Enable the activity log and check if this is what you are looking for.

    Francisco A Buccafusca