Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error reading data from cosmosDB

I have the following configuration to read data from cosmosDB:

 

0683p000009MaRt.png

 

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

Labels (2)
0 Replies