Box connection through talend

[skapoor1]

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

[Anonymous]

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

[skapoor1]

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

[Anonymous]

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

[skapoor1]

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

[Anonymous]

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-...

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