topic Salesforce Job fails with errors "tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier at [row,col {unknown-source}]: [2,81059]" in Talend Studio

Salesforce Job fails with errors "tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier at [row,col {unknown-source}]: [2,81059]"

sr11 — Sat, 16 Nov 2024 06:09:37 GMT

We have a job which accesses Salesforce and loads the same into SQL Server DB. For the last 2-3 days. This job is scheduled to run 24/7 on hourly basis. The Job has been failing with the below similar errors last 2-3 days. Each time, the job fails at a diffrent Salesforce Input component. And during the day, it fails 2-3 times, out of the 24 hour schedule.

Any inputs as to what it might be ?

tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier
at [row,col {unknown-source}]: [2,81059]
Exception in component tSalesforceInput_2

tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block in end tag
at [row,col {unknown-source}]: [6,9947]

Thanks in advance

Re: Salesforce Job fails with errors "tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier at [row,col {unknown-source}]: [2,81059]"

Anonymous — Tue, 16 Apr 2019 08:35:14 GMT

Hello,

We need more information to address your issue. Are you using a bulk query? Could you please post your job design screenshots on forum?

Best regards

Sabrina

Re: Salesforce Job fails with errors "tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier at [row,col {unknown-source}]: [2,81059]"

sr11 — Fri, 10 May 2019 16:26:08 GMT

Hi Sabrina

Thank you for your response on this query,

Not using Bulk query mode. I have about 7-8 Jobs which access the Salesforce Objects and loads into SQL Server Database. Each job is accessing different Salesforce entities and these jobs run sequentially.

So the error is random and not always at the same Job. Each time its a different job and runs successfully the next run.

Trying to understand if this is an issue at Salesforce end or some other issue.

Thanks

Sophia

Re: Salesforce Job fails with errors "tSalesforceInput_2 com.ctc.wstx.exc.WstxEOFException: Unexpected end of input block; expected an identifier at [row,col {unknown-source}]: [2,81059]"

TRF — Fri, 10 May 2019 16:53:38 GMT

Sounds like a network error such as a microcut which by definition occurs randomly.