Error reading data from cosmosDB

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

I have the following configuration to read data from cosmosDB:

Connection looks fine however when I try to read the data from the collection I've got the following message.

Exception in component tMongoDBInput_2 (clk_trans)
java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 4
.*$**[^,]*:.*
    ^
	at java.util.regex.Pattern.error(Pattern.java:1957)
	at java.util.regex.Pattern.sequence(Pattern.java:2125)
	at java.util.regex.Pattern.expr(Pattern.java:1998)
	at java.util.regex.Pattern.compile(Pattern.java:1698)
	at java.util.regex.Pattern.<init>(Pattern.java:1351)
	at java.util.regex.Pattern.compile(Pattern.java:1028)
	at java.util.regex.Pattern.matches(Pattern.java:1133)
	at java.lang.String.matches(String.java:2121)
	at azure_to_postgres.clk_trans_0_1.clk_trans.tMongoDBInput_2Process(clk_trans.java:2455)
	at azure_to_postgres.clk_trans_0_1.clk_trans.tMongoDBConnection_1Process(clk_trans.java:2219)
	at azure_to_postgres.clk_trans_0_1.clk_trans$4.run(clk_trans.java:3104)
tLogCatcher_1 - tLogCatcher failed to process log message(s) due to internal error: java.lang.RuntimeException: File /tmp/clk_out__.csv does not exist or is invalid or is not a file.
java.lang.RuntimeException: File /tmp/clk_out__.csv does not exist or is invalid or is not a file.
	at azure_to_postgres.clk_trans_0_1.clk_trans.tLogCatcher_1Process(clk_trans.java:1935)
	at azure_to_postgres.clk_trans_0_1.clk_trans$TalendException.printStackTrace(clk_trans.java:428)
	at azure_to_postgres.clk_trans_0_1.clk_trans$TalendException.printStackTrace(clk_trans.java:409)
	at azure_to_postgres.clk_trans_0_1.clk_trans$4.run(clk_trans.java:3111)
[statistics] disconnected

I've tried the cosmosdb component with the same result. I am using the last version of Talend 7.3.1

could someone give me some lights on what I'm doing wrong? The same job has been setup for a normal mongoDB (not azure) and it works fine.

Thanks in advance

topic Error reading data from cosmosDB in Talend Studio

Error reading data from cosmosDB