topic Re: How to Perform Bulk Insert from SybaseASE to Sybase IQ in Talend Studio

How to Perform Bulk Insert from SybaseASE to Sybase IQ

Anonymous — Mon, 15 Apr 2013 11:09:37 GMT

HI,
I want to insert a bulk data from Sybase ASE table to sybase IQ table, For this i have used tsybaseinput to get the data from sybase ASE table and using tsybaseOutputBulkExec component, when i run this job i am getting the folowing error
Exception in component tSybaseIQOutputBulkExec_1_tSBE
com.sybase.jdbc3.jdbc.SybSQLException: ASA Error -1006133: File does not exist. File: /apps/sybaseiq/D:/Software & Other/softwares/TOS_DI-r99274-V5.3.0M3/workspace/sybaseIQ_bulk.txt
-- (hos_ion.cxx 182)
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source)
at talendsample.datedimension_0_1.Datedimension.tSybaseInput_1Process(Datedimension.java:1268)
at talendsample.datedimension_0_1.Datedimension.runJobInTOS(Datedimension.java:1491)
at talendsample.datedimension_0_1.Datedimension.main(Datedimension.java:1359)

Pls refer the link for the Screen Shot for reference, Am i using the correct component,
Please suggest to fix this issue..
http://s15.postimg.org/vwlxp1dwr/Bulk.png

Regards,
Siva

Re: How to Perform Bulk Insert from SybaseASE to Sybase IQ

Anonymous — Tue, 16 Apr 2013 10:47:06 GMT

Hi Siva

/apps/sybaseiq/D:/Software & Other/softwares/TOS_DI-r99274-V5.3.0M3/workspace/sybaseIQ_bulk.txt

As the error shows, the file does not exist, the path looks abnormal, can you check it?
Shong

Re: How to Perform Bulk Insert from SybaseASE to Sybase IQ

Anonymous — Thu, 18 Apr 2013 14:48:12 GMT

Hi shong,
I have specified the link for the screen shot, path which is displaying in the error is not specified any where,
Please refer the screen shot..
http://s17.postimg.org/4x0ri9jmn/Bulk_Comp.png
Kindly assist..
Regards
Siva

Re: How to Perform Bulk Insert from SybaseASE to Sybase IQ

Anonymous — Tue, 07 May 2013 10:27:17 GMT

Hi,
we have identified the problem, Issue is that tsybaseoutputbulkexec will work only if the database has been installed in the same machine(will work fine in a server) , due to this limitation /apps/sybaseiq/ path has been added to the file directory
Regards,
Siva