Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: non understanding Error!!!

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Apr 2011
    Posts
    28

    Default non understanding Error!!!

    Hola,

    I have a transformation that works on informix Database like SGBD source. Sometimes the transformation runs without problems, others times I have this non-understanding error: The initialization of the step [nameoftablesource.0] failed!.

    Thx 4 ur help!!!

  2. #2
    Join Date
    Oct 2008
    Posts
    23

    Default

    i had this problem once, and apparently it was a fault of the source db... i kind of solved in putting a loop inside the job, which kept repeating the transformation until it worked. I admit it was a terrible solution, but it worked (i had no permission to modify any parameter in the source db, which was sql server 2005 btw.. so that's the low cost solution i used)

  3. #3
    Join Date
    Apr 2011
    Posts
    28

    Default

    I don't understand very well. can u please tell me how put the loop. The steps please?

  4. #4
    Join Date
    Oct 2008
    Posts
    23

    Default

    i linked the transformation to a dummy step (with FALSE, red link) and then the same dummy step back to the transformation (with black link). Then linked the transformation to the next step with TRUE, green link.
    This way i kept executing the transformation until it returned no error.

  5. #5
    Join Date
    Apr 2011
    Posts
    28

    Default

    I have the same problems. thx 4 ur help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.