Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19197

Table output - Exception handling - improve logging of root cause exception

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: Unknown
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      In the TableOutput step handler ( TableOutput.java), method:writeToTable, the exception handler does additional work like db.commit , db.rollback - where new SqlException or KettleException can be thrown inside the method exception handler itself. In this scenario, before the method exception handler can even format and report the actual exception details to the callers, the exception due to this additional work interrupts proper error logging, as it throws out from within the outer handler. With the result, we know the cause of why rollback was called for example, but not the details of original exception as to why it is doing a rollback or error handling. Suggest adding error handling of parent exception, before any additional recovery or error handling work is performed.

        Attachments

          Activity

            People

            Assignee:
            project admin Triage
            Reporter:
            krishnasdfw Shank Krish
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: