Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.3.0 GA (4.5.0 GA Suite Release), 5.0.0 GA (5.0.0 GA Suite Release)
    • Component/s: None
    • Labels:
    • Environment:
      windows7
    • 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.
    • Browser:
      Google Chrome 21.x
    • Operating System/s:
      Windows 7

      Description

      I'm trying to get a simple 3-step ETL flow to run.
      1) Read in data from an exisiting MongoDB Collection [success]
      2) Write to a text file [success]
      3) Write out back to MongoDB [fail]

      Could you suggest why step3 is failing?
      Thanks
      err msg below

      2012/11/18 18:21:54 - Transformation metadata - The shared object fie [null] is empty!
      2012/11/18 18:21:54 - mongo_Out - Transformation is pre-loaded.
      2012/11/18 18:21:54 - Spoon - Transformation opened.
      2012/11/18 18:21:54 - Spoon - Launching transformation [mongo_Out]...
      2012/11/18 18:21:54 - Spoon - Started the transformation execution.
      2012/11/18 18:21:54 - mongo_Out - Dispatching started for transformation [mongo_Out]
      2012/11/18 18:21:54 - mongo_Out - Nr of arguments detected:0
      2012/11/18 18:21:54 - mongo_Out - This is not a replay transformation
      2012/11/18 18:21:54 - Transformation metadata - Natural sort of steps executed in 0 ms (3 time previous steps calculated)
      2012/11/18 18:21:54 - mongo_Out - I found 3 different steps to launch.
      2012/11/18 18:21:54 - mongo_Out - Allocating rowsets...
      2012/11/18 18:21:54 - mongo_Out - Allocating rowsets for step 0 --> MongoDb Input
      2012/11/18 18:21:54 - mongo_Out - prevcopies = 1, nextcopies=1
      2012/11/18 18:21:54 - mongo_Out - Transformation allocated new rowset [MongoDb Input.0 - Text file output.0]
      2012/11/18 18:21:54 - mongo_Out - Allocated 1 rowsets for step 0 --> MongoDb Input
      2012/11/18 18:21:54 - mongo_Out - Allocating rowsets for step 1 --> Text file output
      2012/11/18 18:21:54 - mongo_Out - prevcopies = 1, nextcopies=1
      2012/11/18 18:21:54 - mongo_Out - Transformation allocated new rowset [Text file output.0 - MongoDb Output.0]
      2012/11/18 18:21:54 - mongo_Out - Allocated 2 rowsets for step 1 --> Text file output
      2012/11/18 18:21:54 - mongo_Out - Allocating rowsets for step 2 --> MongoDb Output
      2012/11/18 18:21:54 - mongo_Out - Allocated 2 rowsets for step 2 --> MongoDb Output
      2012/11/18 18:21:54 - mongo_Out - Allocating Steps & StepData...
      2012/11/18 18:21:54 - mongo_Out - Transformation is about to allocate step [MongoDb Input] of type [MongoDbInput]
      2012/11/18 18:21:54 - MongoDb Input.0 - distribution activated
      2012/11/18 18:21:54 - MongoDb Input.0 - Starting allocation of buffers & new threads...
      2012/11/18 18:21:54 - MongoDb Input.0 - Step info: nrinput=0 nroutput=1
      2012/11/18 18:21:54 - MongoDb Input.0 - output rel. is 1:1
      2012/11/18 18:21:54 - MongoDb Input.0 - Found output rowset [MongoDb Input.0 - Text file output.0]
      2012/11/18 18:21:54 - MongoDb Input.0 - Finished dispatching
      2012/11/18 18:21:54 - mongo_Out - Transformation has allocated a new step: [MongoDb Input].0
      2012/11/18 18:21:54 - mongo_Out - Transformation is about to allocate step [Text file output] of type [TextFileOutput]
      2012/11/18 18:21:54 - Text file output.0 - distribution activated
      2012/11/18 18:21:54 - Text file output.0 - Starting allocation of buffers & new threads...
      2012/11/18 18:21:54 - Text file output.0 - Step info: nrinput=1 nroutput=1
      2012/11/18 18:21:54 - Text file output.0 - Got previous step from [Text file output] #0 --> MongoDb Input
      2012/11/18 18:21:54 - Text file output.0 - input rel is 1:1
      2012/11/18 18:21:54 - Text file output.0 - Found input rowset [MongoDb Input.0 - Text file output.0]
      2012/11/18 18:21:54 - Text file output.0 - output rel. is 1:1
      2012/11/18 18:21:54 - Text file output.0 - Found output rowset [Text file output.0 - MongoDb Output.0]
      2012/11/18 18:21:54 - Text file output.0 - Finished dispatching
      2012/11/18 18:21:54 - mongo_Out - Transformation has allocated a new step: [Text file output].0
      2012/11/18 18:21:54 - mongo_Out - Transformation is about to allocate step [MongoDb Output] of type [MongoDbOutput]
      2012/11/18 18:21:54 - MongoDb Output.0 - Starting allocation of buffers & new threads...
      2012/11/18 18:21:54 - MongoDb Output.0 - Step info: nrinput=1 nroutput=0
      2012/11/18 18:21:54 - MongoDb Output.0 - Got previous step from [MongoDb Output] #0 --> Text file output
      2012/11/18 18:21:54 - MongoDb Output.0 - input rel is 1:1
      2012/11/18 18:21:54 - MongoDb Output.0 - Found input rowset [Text file output.0 - MongoDb Output.0]
      2012/11/18 18:21:54 - MongoDb Output.0 - Finished dispatching
      2012/11/18 18:21:54 - mongo_Out - Transformation has allocated a new step: [MongoDb Output].0
      2012/11/18 18:21:54 - mongo_Out - This transformation can be replayed with replay date: 2012/11/18 18:21:54
      2012/11/18 18:21:54 - mongo_Out - Initialising 3 steps...
      2012/11/18 18:21:54 - MongoDb Input.0 - Running on slave server #0/1.
      2012/11/18 18:21:54 - MongoDb Output.0 - Running on slave server #0/1.
      2012/11/18 18:21:54 - Text file output.0 - Running on slave server #0/1.
      2012/11/18 18:21:54 - Text file output.0 - Parent folder exists file:///C:/kettle/data-integration!
      2012/11/18 18:21:54 - Text file output.0 - Opening output stream in nocompress mode
      2012/11/18 18:21:54 - Text file output.0 - Opening output stream in default encoding
      2012/11/18 18:21:54 - Text file output.0 - Opened new file with name [file.txt]
      2012/11/18 18:21:54 - mongo_Out - Step [MongoDb Input.0] initialized flawlessly.
      2012/11/18 18:21:54 - mongo_Out - Step [Text file output.0] initialized flawlessly.
      2012/11/18 18:21:54 - mongo_Out - Step [MongoDb Output.0] initialized flawlessly.
      2012/11/18 18:21:54 - MongoDb Input.0 - Starting to run...
      2012/11/18 18:21:54 - mongo_Out - Transformation has allocated 3 threads and 2 rowsets.
      2012/11/18 18:21:54 - MongoDb Output.0 - Starting to run...
      2012/11/18 18:21:54 - Text file output.0 - Starting to run...
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : java.lang.NullPointerException
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutputData.checkTopLevelConsistency(MongoDbOutputData.java:676)
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.processRow(MongoDbOutput.java:133)
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      2012/11/18 18:21:54 - MongoDb Output.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source)
      2012/11/18 18:21:54 - MongoDb Input.0 - Finished processing (I=0, O=0, R=0, W=7, U=0, E=0)
      2012/11/18 18:21:54 - MongoDb Output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
      2012/11/18 18:21:54 - mongo_Out - mongo_Out
      2012/11/18 18:21:54 - mongo_Out - mongo_Out
      2012/11/18 18:21:54 - Text file output.0 - Finished processing (I=0, O=8, R=7, W=7, U=0, E=0)
      2012/11/18 18:21:54 - Spoon - The transformation has finished!!
      2012/11/18 18:21:54 - mongo_Out - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
      2012/11/18 18:21:54 - mongo_Out - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sdhayes stuart hayes
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: