tSybaseOutput not committing

Four Stars

tSybaseOutput not committing

Hi guys,

 

I started to work on a process (screenshot in appendix) that runs on a remote server, imports a csv file, adds a load date with tMap and loads the data into a Sybase IQ table. I can connect to the remote server, deploy the job, read the file there and add the load date, but I can't pass anything to the table. The job gets to the tSybaseOutput component and never commits and throws the error:

 

tSybaseOutput_1 ASA Error -1010019: A Query node may not modify objects in the main IQ Store. 

 

I know the data is being passed correctly because, if I replace the tSybaseOutput with a tOracleOutput with the same schema, everything passes to the Oracle table. Does anyone have an idea on how to fix this?

 

Thanks

Moderator

Re: tSybaseOutput not committing

Hello,

What's talend build version you are using? Would you mind also posting your tSybaseOutput component setting screenshot on forum which will be helpful for us to address your issue?

Note: Please mask your sensitive data.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: tSybaseOutput not committing

Hi,

 

I'm using Talend Data Integration (the paid version). And here are the screenshots of basic and advanced settings of the tSybaseOutput.

 

Thanks

Moderator

Re: tSybaseOutput not committing

Hello,

What's talend build version you are using? V 6.4.1?

The supported sybase DB version by talend components for talend data integration V 6.4.1 are

12.5

12.7

15.2

15.5

15.7

16.0

Please have a look at this online installation guide about:TalendHelpCenter: Supported systems, databases and business applications by Talend components to see if your sybase db version is in the list.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download