Value too long for character type: 8001 - Connection?

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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