You are not logged in.
I'm encountering a pb with the attached job.
Launched with Talend, it works well.
When I export it to a Webservice, it does not work anymore (I can't check if there is the same pb axported to a .sh because JVM is not setup for the moment).
As you can see, I've used the "tBuffer" component : Just to check some variables.
The connection is ok (((String)globalMap.get("tOracleConnection_1_ERROR_MESSAGE")) = null).
My filename and file path are good.
I've checked the input data of the tOracleOutputBulkExec component, it is ok (and ((String)globalMap.get("tFileInputDelimited_1_ERROR_MESSAGE")) = null).
About the "tOracleOutputBulkExec" component, here is what I get : ((String)globalMap.get("tOracleOutputBulkExec_1_ERROR_MESSAGE")) = null. So, no pb either.
Should i report a bug ?
Thank you in advance.
What's your error info?
I have tried to reproduce your problem but it works fine on local machine with TOS3.0.4
I have no error info, that's the pb.
I perform a "drop table if exists and create" before inserting rows... which works.
However, No data are inserted into DB, whereas it works launched with Talend in Local.
About the SQL Loader files, I've got the temps file, the .ctl file, but no log file.
However, maybe I've got a clue now. There are "^M" characters at the end of my file and path names :
OPTIONS (ROWS=5000, PARALLEL=false, BINDSIZE=20000000, READSIZE=20000000)^M
INTO TABLE ssdx_eng.ESSAI_SSDX_IN_SUPPLIER_METI^M
FIELDS TERMINATED BY ";"^M
Do you think that's the pb, and where do you think it comes from ?
Last edited by nSmolyniec (2009-04-24 10:44:30)
From what I've found, "^M" is a carriage return for Windows, which is not interpreted by Unix.
I'm pretty sure the error comes from here : my Webservice runs on Unix.
There is probably something wrong in your manner of generating the ".ctl" file.
Last edited by nSmolyniec (2009-04-24 11:28:24)