Talend community forum / Oracle Output BulkExec

cam · 2010-02-23 18:03:25

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

shong · 2010-02-24 04:48:30

Hello
Can you show us the whole exception message?

Best regards

shong

cam · 2010-02-24 09:32:01

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]

shong · 2010-02-25 03:54:57

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

cam · 2010-02-25 14:44:23

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

cam · 2010-02-26 11:39:48

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

thanks

Announcement

Unanswered posts

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

Oracle Output BulkExec

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

Re: Oracle Output BulkExec

#3 2010-02-24 09:32:01

Re: Oracle Output BulkExec

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

Re: Oracle Output BulkExec

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

Re: Oracle Output BulkExec

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

Re: Oracle Output BulkExec

Board footer