topic Re: tSalesforceInput : manual query bug in Talend Studio

tSalesforceInput : manual query bug

aimarsouris — Sat, 16 Nov 2024 07:31:06 GMT

Hi,

When I modify my manual query in tSalesforce (TOS ESB 7.0.1), I always get the axception below and need to delete the component and create a new one (with exactly the same query) in order to make it work. It looks like a bug, did anyone experienced the same situation?

Best

Exception in component tSalesforceInput_1 (myJob)
java.io.IOException: [MalformedQueryFault [ApiQueryFault [ApiFault exceptionCode='MALFORMED_QUERY'
exceptionMessage='line 1:0 no viable alternative at character '"''
extendedErrorDetails='{[0]}'
]
row='1'
column='0'
]
]

Re: tSalesforceInput : manual query bug

TRF — Fri, 05 Oct 2018 12:38:19 GMT

As soon as it works for other versions, it sounds like a bug

Re: tSalesforceInput : manual query bug

jzhao — Fri, 19 Oct 2018 03:10:31 GMT

Hi,

From the exception, I don't think this is a bug. I think the soql is not correct one.

You can check your sql in https://workbench.developerforce.com/query.php

I can reproduce this kind of error message with a wrong soql.

If this is not answer your question. It would be better that show your soql or job screenshot.

We can help you check your job and soql.

Thanks.

Re: tSalesforceInput : manual query bug

aimarsouris — Tue, 23 Oct 2018 15:01:00 GMT

Hi @jzhao

Although that might happen to me sometimes 😉 this error happens also with correct SOQL every time I have to modify the manual query in an existing tSalesforceInput. I'm actually using Workbench pretty frequently aswell.

Anyway, I think I found a turnaround by deactivating the component before modifying the SOQL.

Best