topic Re: Value too long for character type: 8001 - Connection? in Talend Studio

Value too long for character type: 8001 - Connection?

Anonymous — Sat, 16 Nov 2024 05:50:37 GMT

I am getting the following error. Is it possible that my host string is too long?

docdb-2019-04-24-18-01-22.cluster-cg2ulmlxoqaj.eu-west-1.docdb.amazonaws.com

Exception in component tRunJob_1 (process_data_warehouse)
java.lang.RuntimeException: Child job running failed.
java.lang.RuntimeException: Child job running failed.
com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=docdb-2019-04-24-18-01-22.cluster-cg2ulmlxoqaj.eu-west-1.docdb.amazonaws.com:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketReadTimeoutException: Timeout while receiving message}, caused by {java.net.SocketTimeoutException: Read timed out}}]
at aws_jembi_warehouse.process_data_warehouse_0_1.process_data_warehouse.tRunJob_1Process(process_data_warehouse.java:8054)
at aws_jembi_warehouse.process_data_warehouse_0_1.process_data_warehouse.runJobInTOS(process_data_warehouse.java:12935)
at aws_jembi_warehouse.process_data_warehouse_0_1.process_data_warehouse.main(process_data_warehouse.java:12700)
ERROR: Value too long for character type
Detail:
-----------------------------------------------
error: Value too long for character type
code: 8001
context: Value too long for type character varying(255)
query: 275365
location: funcs_string.hpp:286
process: query1_126_275365 [pid=7722]
-----------------------------------------------

Re: Value too long for character type: 8001 - Connection?

Anonymous — Wed, 15 May 2019 23:24:54 GMT

Hi,

Could you please try to execute the same operation with IP address of the server? This will make sure that the issue is indeed due to length of server name.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Value too long for character type: 8001 - Connection?

Anonymous — Thu, 16 May 2019 08:53:11 GMT

Hi Nikhil,

We have now ruled out that the length of the connection string is the issue.

Unfortunately these AWS links are ELBs so they do not have a static IP.

But thanks regardless for the assistance.

All the best,

Anton