12-06-2016 09:31 AM
I have a weird problem with RapidMiner server and Postgresql hosted in AWS. Basically , sometimes processes fail to fetch/read data from a postgresql database giving the error:
SEVERE: Process failed: com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//DB/advancedanalytics/Example Sets/analytics_data.conditions'. Reason: Requested repository DB does not exist..
The trouble is if I ran the same process on RapidMiner studio, it executes successfully and at some point the problem would clear by itself on RapidMiner server.
Is there a known problem on RapidMiner server and postgresql connectivity?
Solved! Go to Solution.
12-06-2016 10:08 AM
I use PostgreSQL with a RapidMiner server all the time. Both local and remote databases.
You're loading the example set from the //DB virtual repository. Could you try to use Read Database instead? It would at least give you better error messages.
12-07-2016 04:02 AM
Thanks for your suggestion. Read database gives a similar error, as you said it gives a better error message - it tells me the relation/table does not exist, however I can actually access this table in pgAdmin and also the same process runs in RapidMiner studio, so it has got to be something to do with RapidMiner server.
SEVERE: Process failed: com.rapidminer.operator.UserError: Database error occurred: ERROR: relation "conditions" does not exist
It just baffles me.
12-07-2016 07:46 AM
Good to know. Thank you for providing the solution.
I never had problems like this with a non-cloud PostgreSQL database. Maybe the Amazon stuff is doing something behind the scenes that sometimes fails.