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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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