You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tOracleOutputBulkExec : does not work in a Webservice ?
#1 2009-04-23 19:59:21
- nSmolyniec
- Member
- Company: Soft Solutions
- Registered: 2009-03-23
- Posts: 91
tOracleOutputBulkExec : does not work in a Webservice ?
Hello,
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.
Best regards,
Nicolas
T.O.S. Version : 3.0.4
Generated language : Java
O.S. : Win XP SP3
Offline
#2 2009-04-24 04:49:55
Re: tOracleOutputBulkExec : does not work in a Webservice ?
Hello Nicolas
What's your error info?
I have tried to reproduce your problem but it works fine on local machine with TOS3.0.4
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2009-04-24 09:21:00
- nSmolyniec
- Member
- Company: Soft Solutions
- Registered: 2009-03-23
- Posts: 91
Re: tOracleOutputBulkExec : does not work in a Webservice ?
Hi Shong,
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
LOAD DATA^M
CHARACTERSET 'UTF8'^M
INFILE '/tmp/talend/files/out.csv'^M
BADFILE '/tmp/talend/files/out.csv.bad'^M
DISCARDFILE '/tmp/talend/files/out.csv.dsc'^M
INTO TABLE ssdx_eng.ESSAI_SSDX_IN_SUPPLIER_METI^M
INSERT^M
FIELDS TERMINATED BY ";"^M
TRAILING NULLCOLS^M
(FOU_CDFO,
FOU_NM,
FOU_NVOI,
...
Do you think that's the pb, and where do you think it comes from ?
Thank you.
Best regards,
Nicolas
Last edited by nSmolyniec (2009-04-24 10:44:30)
T.O.S. Version : 3.0.4
Generated language : Java
O.S. : Win XP SP3
Offline
#4 2009-04-24 11:27:29
- nSmolyniec
- Member
- Company: Soft Solutions
- Registered: 2009-03-23
- Posts: 91
Re: tOracleOutputBulkExec : does not work in a Webservice ?
Hi again,
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.
Best regards,
Nicolas
Last edited by nSmolyniec (2009-04-24 11:28:24)
T.O.S. Version : 3.0.4
Generated language : Java
O.S. : Win XP SP3
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tOracleOutputBulkExec : does not work in a Webservice ?