How to fix "datasource serviceImpl.error_0009" in pentaho?
I login to pentaho using admin username and password, then go to file> new> datasource, select "SQL QUERY" then enter my database and test it to connect to the database, it will be successful. When I try to test a new datasource using sql query I type " select 1 from mytable
" and it gives me this error:
datasourceServiceImpl.error_0009 request validation failed: request validation failed {0}
That's all it gives me and I don't know how to fix it.
Biserver-ce-5.1.0.0-752 works for me
Stop the server.
Change the driver mysql .. \ tomcat \ lib "mysql-connector-java-5.1.17.jar"
driver folder "mysql-connector-java-5.1.25-bin.jar"
.
Reboot the server and it should work.
I fixed the problem by removing the ";" at the end of my request.
I got this error and found it was as easy as having two columns with the same name in my SELECT statement.
Install mysql-connector-java-gpl-xxxmsi Put in lib folder mysql-connector-java-xxxjar