Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem with annexed archives in email

  1. #1

    Default Problem with annexed archives in email

    What so good afternoon.
    I have problems with a work; this is what would have to do:

    - First it obtains data of the data base.
    - It keeps the information within a file in excel (that until now does not exist).
    - After creating the file in excel and keeping the information it must send the file through email to an account.
    - When it has finalized to send must it erase the file recently created.

    What Kettle does is that all the scheme seems to be fulfilled well; ah exception of this situation:

    When kettle to create the nonannexed file, kettle for the first time the file to the electronic mail.
    Now if we cleared the fact that it must erase the file and executed the then work again; Kettle when detecting that the
    file already exists adds the new if now annexed information and the file to the mail.

    Reason why kettle cannot be creating, sending and eliminating the file at issue; if not that must only add and send;
    which leaves with a file that estara increasing of size whenever the process runs.

    This is bug?

    Here logs:
    - This it is of when kettle it must create the file:
    2007/07/11 17:02:28 - MeteValoresReporte - Transformation has allocated 2 threads and 1 rowsets.
    2007/07/11 17:02:28 - Excel Output.0 - Starting to run...
    2007/07/11 17:02:28 - TomaValores.0 - Signaling 'output done' to 1 output rowsets.
    2007/07/11 17:02:28 - TomaValores.0 - Finished reading query, closing connection.
    2007/07/11 17:02:28 - GenPostCube - Connection to database closed!
    2007/07/11 17:02:28 - TomaValores.0 - Finished processing (I=9, O=0, R=0, W=9, U=0, E=0)
    2007/07/11 17:02:28 - Excel Output.0 - Signaling 'output done' to 0 output rowsets.
    2007/07/11 17:02:28 - Excel Output.0 - Finished processing (I=0, O=10, R=9, W=0, U=0, E=0)
    2007/07/11 17:02:28 - Dpanaderia_CreaReporteArchivos - Starting entry [EnviarReporte]
    2007/07/11 17:02:28 - Thread[Dpanaderia_CreaReporteArchivos (Dpanaderia_CreaReporteArchivos (Thread-19396)),5,main] - exec(26, 0, EnviarReporte.0)
    2007/07/11 17:02:30 - Dpanaderia_CreaReporteArchivos - Finished jobentry [EnviarReporte] (result=true)

    - This it is when the created file already this and we left kettle single adds the new rows:
    2007/07/11 17:07:51 - MeteValoresReporte - Transformation has allocated 2 threads and 1 rowsets.
    2007/07/11 17:07:51 - Excel Output.0 - Starting to run...
    2007/07/11 17:07:51 - TomaValores.0 - Signaling 'output done' to 1 output rowsets.
    2007/07/11 17:07:51 - TomaValores.0 - Finished reading query, closing connection.
    2007/07/11 17:07:51 - GenPostCube - Connection to database closed!
    2007/07/11 17:07:51 - TomaValores.0 - Finished processing (I=9, O=0, R=0, W=9, U=0, E=0)
    2007/07/11 17:07:51 - Excel Output.0 - Signaling 'output done' to 0 output rowsets.
    2007/07/11 17:07:51 - Excel Output.0 - Finished processing (I=0, O=10, R=9, W=0, U=0, E=0)
    2007/07/11 17:07:51 - Dpanaderia_CreaReporteArchivos - Starting entry [EnviarReporte]
    2007/07/11 17:07:51 - Thread[Dpanaderia_CreaReporteArchivos (Dpanaderia_CreaReporteArchivos (Thread-20887)),5,main] - exec(26, 0, EnviarReporte.0)
    2007/07/11 17:07:51 - EnviarReporte - Added file '///usr/local/Kettle-2.5/Temp/Reporte de Archivos del Cubo Ventas Panaderia (2007-07-11).xls' to the mail message.
    2007/07/11 17:07:54 - Dpanaderia_CreaReporteArchivos - Finished jobentry [EnviarReporte] (result=true)

    How they will see first does not send anything, but the second if.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    What's wrong with erasing the file after sending successfully... there is a delete file job entry.

    Regards,
    Sven

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.