topic Box connection through talend in Talend Studio

Box connection through talend

skapoor1 — Fri, 15 Nov 2024 23:27:40 GMT

Hi,

I m trying to connect to box sandbox through Talend ,but m getting below exception-

is it due to sandbox that its not able to resolve the host ,do I need to provide proxy server details ?

Exception in component tBoxGet_1 (BOX_Connectivity)

com.box.restclientv2.exceptions.BoxRestException

at com.box.boxjavalibv2.BoxRESTClient.handleException(BoxRESTClient.java:183)

at com.box.boxjavalibv2.BoxRESTClient.execute(BoxRESTClient.java:118)

at com.box.boxjavalibv2.BoxRESTClient.execute(BoxRESTClient.java:72)

at com.box.boxjavalibv2.resourcemanagers.AbstractBoxResourceManager.getResponseAndParse(AbstractBoxResourceManager.java:118)

at com.box.boxjavalibv2.resourcemanagers.BoxItemsManagerImpl.getItem(BoxItemsManagerImpl.java:55)

at com.box.boxjavalibv2.resourcemanagers.BoxFoldersManageImpl.getFolder(BoxFoldersManageImpl.java:56)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxGet_1Process(BOX_Connectivity.java:748)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxConnection_1Process(BOX_Connectivity.java:612)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.runJobInTOS(BOX_Connectivity.java:1305)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.main(BOX_Connectivity.java:1105)

Caused by: java.net.UnknownHostException: api.box.com

Re: Box connection through talend

Anonymous — Thu, 02 Dec 2021 09:51:07 GMT

Hello,

Are you able to ping your Host successfully? If it fails, could you try to resolve the issue by adding api.box.com to the /etc/hosts file on your machine, or by updating the host name on the DNS server?

Best regards

Sabrina

Re: Box connection through talend

skapoor1 — Thu, 02 Dec 2021 10:14:35 GMT

that IP address itself is throwing error -request timed out ..

Re: Box connection through talend

Anonymous — Fri, 03 Dec 2021 05:35:03 GMT

Hello,

You could try changing the live server address to a straight IP address (e.g. change local host to 127.0.0.1 in /etc/hosts), so that it doesn't have to perform an address lookup.

Are you using talend subscription solution? If so, you could create a support case on talend support portal so that our colleagues from support team would give you a remote assistance through support cycle with priority.

Best regards

Sabrina

Re: Box connection through talend

skapoor1 — Fri, 03 Dec 2021 08:31:23 GMT

Thaks Sabrina,yes its asubscription solution, I am able to connect to box using proxy but getting below error while accessing the file -

[statistics] connecting to socket on port 3336

[statistics] connected

Exception in component tBoxGet_1 (BOX_Connectivity)

java.lang.Exception: No file found in All Files/test1.txt

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxGet_1Process(BOX_Connectivity.java:739)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxConnection_1Process(BOX_Connectivity.java:622)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.runJobInTOS(BOX_Connectivity.java:1273)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.main(BOX_Connectivity.java:1073)

[FATAL]: ggo_bi.box_connectivity_0_1.BOX_Connectivity - tBoxGet_1 No file found in All Files/test1.txt

java.lang.Exception: No file found in All Files/test1.txt

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxGet_1Process(BOX_Connectivity.java:739)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.tBoxConnection_1Process(BOX_Connectivity.java:622)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.runJobInTOS(BOX_Connectivity.java:1273)

at ggo_bi.box_connectivity_0_1.BOX_Connectivity.main(BOX_Connectivity.java:1073)

[statistics] disconnected

Re: Box connection through talend

Anonymous — Fri, 03 Dec 2021 09:09:21 GMT

Hello,

Are you using OAUTH2 to connect to box? Usually expired certificate or token causes such errors, Please find the below article for reference:

https://stackoverflow.com/questions/9578129/exception-javax-net-ssl-sslpeerunverifiedexception-peer-not-authenticated

Could you please confirm the Access token was working when you executed the job and try with fresh access token and let me know if it works fine?

Best regards

Sabrina