Command line parameters
Hi,
I have been using Kettle for a week now and I like this tool so far.
However, I am having trouble trying to get command line parameters to work correctly.
Basically, I want to be able to pass 2 dates as parameters to my transformation. After reading a few threads on this forum, I was able to resolve the errors like 'index column not found' etc, successfully.
Although, I do not get any errors now, I don't see any output either. My transformation runs successfully and I am able to see the following in my log file -
2008/10/26 22:56:30:831 EDT [INFO] DefaultFileReplicator - Using "/tmp/vfs_cache" as temporary files store.
Unable to find kettle engine jar file to set build date. (ignored)
INFO 26-10 22:56:31,180 - Final - Dispatching started for transformation [Final]
INFO 26-10 22:56:31,188 - Final - This transformation can be replayed with replay date: 2008/10/26 22:56:31
INFO 26-10 22:56:31,487 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=1, E=0)
INFO 26-10 22:56:33,851 - contri.0 - Finished reading query, closing connection.
INFO 26-10 22:56:33,856 - contri.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
INFO 26-10 22:56:33,861 - Pan - Finished!
INFO 26-10 22:56:33,861 - Pan - Start=2008/10/26 22:56:30.898, Stop=2008/10/26 22:56:33.861
INFO 26-10 22:56:33,861 - Pan - Processing ended after 2 seconds.
INFO 26-10 22:56:33,861 - Final -
INFO 26-10 22:56:33,862 - Final - Process Get System Info'.0 ended successfully, processed 1 lines. ( 0 lines/s)
INFO 26-10 22:56:33,862 - Final - Process contri'.0 ended successfully, processed 1 lines. ( 0 lines/s)
INFO 26-10 22:56:33,862 - Final - Process output'.0 ended successfully, processed 0 lines. ( 0 lines/s)
The query I am using in my table input step, does return rows if run in Oracle, but there's nothing being written to the output .csv file that I'm writing to in my transformation...and I cannot figure out why!
Below is the query in my step -
SELECT * FROMAND LAST_MOD_DATE < ?
CON
WHERE LAST_MOD_DATE >= ?
and this is how I'm running the .ktr file -
nohup pan.sh -file /home/sramsetty/Final.ktr "05-Aug-2008" "02-Oct-2008" -norep > final.log 2>&1 &
I am attaching my transformation file here and will greatly appreciate any help I can get on this. We have a really tight schedule for our development and again, any help is highly appreciated.
Thanks,
Sowj.
Reply With Quote
