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]

Hi

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

SR

[Anonymous]

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

[sr11]

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

[TRF]

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