#1 2010-02-23 18:03:25

cam
Guest

Oracle Output BulkExec

Hello,
i'm using a component OracleOutputBulkExec.
Since one week i work on Windows 7 32 system with talend 3.2

When i launch the script (.bat) which is using the component I have the following problem :
Exception in component tOracleOutputBulkExec_1_tOBE
java.lang.Exception.

The bulkexec component write a file on directory on windows and then insert all datas into Oracle database.
I create a file with tFileOutputDelimited without problem. that's why i think it's not a rights problem.

I don't have the problem on a Vista 32 system with the same talend version 3.2.

I hope somedy know the problem.

thanks in advance

#2 2010-02-24 04:48:30

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: Oracle Output BulkExec

Hello
Can you show us the whole exception message?

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 2010-02-24 09:32:01

cam
Guest

Re: Oracle Output BulkExec

hello,
look at the exceptions, i hope you can help me...

Démarrage du jobA_A_PiloteGeneral a 09:25 24/02/2010.

[statistics] connecting to socket on port 3601
[statistics] connected

-- 20100120-0550-MAT.txt --

-- chargement de ZMAT_DSOP --

SQL*Loader: Release 10.2.0.1.0 - Production on Mer. Févr. 24 09:25:45 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL*Loader-704: Erreur interne : ulconnect: OCIEnvCreate [-1]
Exception in component tOracleOutputBulkExec_1_tOBE
java.lang.Exception
    at integration_filiales.cb_a_chargementdsoarticlefilialedepuisfichierplatunicode_0_1.CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.tFileInputDelimited_1Process(CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.java:6739)
    at integration_filiales.cb_a_chargementdsoarticlefilialedepuisfichierplatunicode_0_1.CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.tOracleRow_1Process(CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.java:587)
    at integration_filiales.cb_a_chargementdsoarticlefilialedepuisfichierplatunicode_0_1.CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.tJava_1Process(CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.java:454)
    at integration_filiales.cb_a_chargementdsoarticlefilialedepuisfichierplatunicode_0_1.CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.runJobInTOS(CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.java:8185)
    at integration_filiales.cb_a_chargementdsoarticlefilialedepuisfichierplatunicode_0_1.CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.runJob(CB_A_ChargementDSOArticleFilialeDepuisFichierPlatUnicode.java:8066)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tRunJob_6Process(CA_B_SequenceurArticle_OneShot.java:687)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tOracleRow_1Process(CA_B_SequenceurArticle_OneShot.java:596)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tJava_1Process(CA_B_SequenceurArticle_OneShot.java:462)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.runJobInTOS(CA_B_SequenceurArticle_OneShot.java:2818)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.runJob(CA_B_SequenceurArticle_OneShot.java:2704)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1764)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_2Process(CA_A_SequenceurIterationArticle_OneShot.java:1663)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tFileList_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1438)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJobInTOS(CA_A_SequenceurIterationArticle_OneShot.java:3043)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJob(CA_A_SequenceurIterationArticle_OneShot.java:2933)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_2Process(A_B1_PiloteArticle.java:541)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_3Process(A_B1_PiloteArticle.java:455)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJobInTOS(A_B1_PiloteArticle.java:3808)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJob(A_B1_PiloteArticle.java:3702)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_2Process(A_A_PiloteGeneral.java:1596)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_3Process(A_A_PiloteGeneral.java:975)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_2Process(A_A_PiloteGeneral.java:911)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_8Process(A_A_PiloteGeneral.java:833)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_7Process(A_A_PiloteGeneral.java:693)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.runJobInTOS(A_A_PiloteGeneral.java:4723)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.main(A_A_PiloteGeneral.java:4564)
Exception in component tRunJob_6
java.lang.RuntimeException: Child job running failed
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tRunJob_6Process(CA_B_SequenceurArticle_OneShot.java:707)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tOracleRow_1Process(CA_B_SequenceurArticle_OneShot.java:596)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.tJava_1Process(CA_B_SequenceurArticle_OneShot.java:462)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.runJobInTOS(CA_B_SequenceurArticle_OneShot.java:2818)
    at integration_filiales.ca_b_sequenceurarticle_oneshot_0_1.CA_B_SequenceurArticle_OneShot.runJob(CA_B_SequenceurArticle_OneShot.java:2704)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1764)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_2Process(CA_A_SequenceurIterationArticle_OneShot.java:1663)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tFileList_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1438)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJobInTOS(CA_A_SequenceurIterationArticle_OneShot.java:3043)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJob(CA_A_SequenceurIterationArticle_OneShot.java:2933)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_2Process(A_B1_PiloteArticle.java:541)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_3Process(A_B1_PiloteArticle.java:455)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJobInTOS(A_B1_PiloteArticle.java:3808)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJob(A_B1_PiloteArticle.java:3702)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_2Process(A_A_PiloteGeneral.java:1596)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_3Process(A_A_PiloteGeneral.java:975)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_2Process(A_A_PiloteGeneral.java:911)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_8Process(A_A_PiloteGeneral.java:833)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_7Process(A_A_PiloteGeneral.java:693)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.runJobInTOS(A_A_PiloteGeneral.java:4723)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.main(A_A_PiloteGeneral.java:4564)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1784)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tRunJob_2Process(CA_A_SequenceurIterationArticle_OneShot.java:1663)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.tFileList_1Process(CA_A_SequenceurIterationArticle_OneShot.java:1438)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJobInTOS(CA_A_SequenceurIterationArticle_OneShot.java:3043)
    at integration_filiales.ca_a_sequenceuriterationarticle_oneshot_0_1.CA_A_SequenceurIterationArticle_OneShot.runJob(CA_A_SequenceurIterationArticle_OneShot.java:2933)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_2Process(A_B1_PiloteArticle.java:541)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.tRunJob_3Process(A_B1_PiloteArticle.java:455)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJobInTOS(A_B1_PiloteArticle.java:3808)
    at integration_filiales.a_b1_pilotearticle_0_1.A_B1_PiloteArticle.runJob(A_B1_PiloteArticle.java:3702)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_2Process(A_A_PiloteGeneral.java:1596)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_3Process(A_A_PiloteGeneral.java:975)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tSleep_2Process(A_A_PiloteGeneral.java:911)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_8Process(A_A_PiloteGeneral.java:833)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.tRunJob_7Process(A_A_PiloteGeneral.java:693)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.runJobInTOS(A_A_PiloteGeneral.java:4723)
    at integration_filiales.a_a_pilotegeneral_0_1.A_A_PiloteGeneral.main(A_A_PiloteGeneral.java:4564)

-- Concatenation des fichiers OUT-MAT --

-- Concatenation des fichiers OUT_CUS --
[statistics] disconnected
Job A_A_PiloteGeneral terminé à 09:25 24/02/2010. [Code sortie=0]

#4 2010-02-25 03:54:57

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: Oracle Output BulkExec

Hello
I see you have the same problem when you worked on Vista before on [Forum, topic 7173] OracleOutputBulkExec : erreur OCIEnvCreate. To solve it, you have download the 10203_vista_w2k8_x86_production_client.zip (616,757,461 bytes). Can you try to find and download the related patch file for windows 7?

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

#5 2010-02-25 14:44:23

cam
Guest

Re: Oracle Output BulkExec

Thanks for your answer.
Indeed I had the same problem with vista.
I already look in oracle support but the last version is the version i installed for vista... This is the version for Vista and Server 2008.
I don't found any version for windows 7.

thanks

#6 2010-02-26 11:39:48

cam
Guest

Re: Oracle Output BulkExec

hello
is there somebody who have a windows 7 compatible version ?

thanks

Board footer

Powered by FluxBB