topic Re: Unable to fetch data from tservicenowinput though connection is done in Talend Studio

Unable to fetch data from tservicenowinput though connection is done

Pardhu123 — Fri, 14 Feb 2020 09:52:11 GMT

I want to update specific table is Servicenow via Talend. For this first i want to fetch the data from servicenow. Now, i am failing to fetch the data using input component.

It is giving the error as:

Exception in component tServiceNowInput_1 (US4)
org.json.JSONException: A JSONObject text must begin with '{' at 1 [character 2 line 1]
at org.json.JSONTokener.syntaxError(JSONTokener.java:429)
at org.json.JSONObject.<init>(JSONObject.java:193)
at org.json.JSONObject.<init>(JSONObject.java:320)
at dummy.us4_0_1.US4.tServiceNowInput_1Process(US4.java:1327)
at dummy.us4_0_1.US4.runJobInTOS(US4.java:2172)
at dummy.us4_0_1.US4.main(US4.java:1959)

Re: Unable to fetch data from tservicenowinput though connection is done

Anonymous — Fri, 17 Apr 2020 19:37:14 GMT

I am receiving the same error as the original poster--would like assistance with this!

Re: Unable to fetch data from tservicenowinput though connection is done

Anonymous — Fri, 17 Apr 2020 21:35:37 GMT

I believe my ServiceNow instance was asleep and that was the cause of a successful connection followed by unsuccessful fetching of table rows. After waking up my instance my code is working!