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

Oracle Bulk loader failing for timestamp with sixth precision column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.2 GA
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Oracle 11g
      Spoon 5.0.2
      Windows 7 64bit
    • Story Points:
      3
    • PDI Sub-component:
    • 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.
    • Sprint Team:
      Pervach
    • Operating System/s:
      Windows 7

      Description

      Problem:

      Oracle bulk loader works successfully as long as there is no column involving timestamps. Was able to duplicate issue.

      Description:

      timestamps columns with 6 precision fail with the oracle bulk loader
      I have the "supports the time stamp data type" marked in the Advanced Database connection as I need all of the timestamp. (Screen Shot attached)

      If I un-check "supports the timestamp data type" in the Advanced Database connection then the Oracle Bulk loader runs good and partial timestamp (3 precision) gets loaded. (Screen shot attached)

        Attachments

          Activity

            People

            Assignee:
            alena_khamitsevich Alena Khamitsevich (Inactive)
            Reporter:
            tblanton Travis Blanton (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h
                4h