Setting Up Log Levels

You can configure a different log level for the plug-in and plug-in activities to trace different messages.

1. Navigate to the TIBCO_HOME\bw\version_number\config\design\logback directory, and open the logback.xml file.
2. Add the following node in the BusinessWorks Palette and Activity loggers area to specify a log level for the plug-in:
   • For SAP HANA Database JDBC palette:

     <logger name="com.tibco.bw.palette.saphanadb.jdbc.runtime">
         <level value="TRACE"/>
      </logger>

   • For SAP HANA Database OData palette:

     <logger name="com.tibco.bw.palette.saphanadb.odata.runtime">
         <level value="TRACE"/>
      </logger>

   The value of the level element can be Error, Info, Debug or Trace.

   Note: If you set the log level to Debug, the input and output for the plug-in activities are also displayed in the Console view. See Log Levels for more details regarding each log level.
3. Optional: Optional: Add one of the following nodes in the BusinessWorks Palette and Activity Loggers area to specify a log level for the activity.
   • For SAP HANA Database JDBC activities, set the following parameters:

     <logger name="com.tibco.bw.palette.saphanadb.jdbc.runtime.query">
         <level value="TRACE"/>
     </logger>

     <logger name="com.tibco.bw.palette.saphanadb.jdbc.runtime.delete">
         <level value="TRACE"/>
     </logger>

     <logger name="com.tibco.bw.palette.saphanadb.jdbc.runtime.insert">
         <level value="TRACE"/>
     </logger>

     <logger name="com.tibco.bw.palette.saphanadb.jdbc.runtime.update">
         <level value="TRACE"/>
     </logger>

   • For SAP HANA Database OData activity, set the following parameters:

     <logger name="com.tibco.bw.palette.saphanadb.odata.runtime.consumeodata">
         <level value="TRACE"/>
     </logger>

   Note: The activities that are not configured with specific log levels use the default log level of the plug-in.
4. To control the debug log level for the SAP HANA Database Configuration shared resource, set the following parameters:
   • For SAP HANA Database JDBC Connection shared resource:

     <logger name="com.tibco.bw.sharedresource.saphanadb.jdbc.runtime">
         <level value="TRACE"/>
      </logger>

   • For SAP HANA Database OData Connection shared resource:

     <logger name="com.tibco.bw.sharedresource.saphanadb.odata.runtime">
         <level value="TRACE"/>
      </logger>

5. Save the file.