[resolved] java.io.IOException: The semaphore timeout period has expired

[Anonymous]

Am receiving this exception:

Exception in component tMSSqlOutputBulkExec_4_tMOB
java.io.IOException: The semaphore timeout period has expired
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(Unknown Source)
at sun.nio.cs.StreamEncoder.writeBytes(Unknown Source)
at sun.nio.cs.StreamEncoder.implWrite(Unknown Source)
at sun.nio.cs.StreamEncoder.write(Unknown Source)
at java.io.OutputStreamWriter.write(Unknown Source)
at java.io.BufferedWriter.flushBuffer(Unknown Source)
at java.io.BufferedWriter.write(Unknown Source)
at java.io.Writer.write(Unknown Source)
at bcbsla.job3_gen_tranhis_bh_0_2.job3_gen_tranhis_bh.tMSSqlInput_1Process(job3_gen_tranhis_bh.java:23585)
at bcbsla.job3_gen_tranhis_bh_0_2.job3_gen_tranhis_bh.runJobInTOS(job3_gen_tranhis_bh.java:26948)
at bcbsla.job3_gen_tranhis_bh_0_2.job3_gen_tranhis_bh.runJob(job3_gen_tranhis_bh.java:26854)
at bcbsla.income_0_2.income.tRunJob_2Process(income.java:500)
at bcbsla.income_0_2.income.tRunJob_4Process(income.java:438)
at bcbsla.income_0_2.income.tRunJob_1Process(income.java:335)
at bcbsla.income_0_2.income.runJobInTOS(income.java:786)
at bcbsla.income_0_2.income.main(income.java:680)
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at bcbsla.income_0_2.income.tRunJob_2Process(income.java:520)
at bcbsla.income_0_2.income.tRunJob_4Process(income.java:438)
at bcbsla.income_0_2.income.tRunJob_1Process(income.java:335)
at bcbsla.income_0_2.income.runJobInTOS(income.java:786)
at bcbsla.income_0_2.income.main(income.java:680)

----------------------------------------------------------------------------------------
The exception occurred at following line in the code:
outtMSSqlOutputBulkExec_4_tMOB.write(OUT_DELIM_tMSSqlOutputBulkExec_4_tMOB);
------------------------------------------------------------------------------------------------------
outtMSSqlOutputBulkExec_4_tMOB is a java.io.BufferedWriter outtMSSqlOutputBulkExec_4_tMOB
I am using a BulkInsert component and the error seems to have occurred when the job was writing to the text file it creates for bulk insert.

Has anyone seen this before? Any help will be greatly appreciated.
Thanks.

[Anonymous]

Hello guy
Which version of TOS do you use? Can you connect successully to your db with tMssqlConnection component?
Best regards
shong

[Anonymous · Accepted solution]

We figured out it was a network issue. The job was writing to a file in a shared drive on the network and the machine must have lost connection to the network in the middle of the job. We did not encounter the problem once we started using a local directory. Thanks.