title: How do I fix "datasource serviceImpl.error_0009" in pentaho?
body: <p>I log into pentaho using the administrator's username and password, then go into file > new > datasource select "SQL QUERY", then type in my database and test it for database connection, it is successful. When I try to test the new datasource with the sql query, I type in "<code>select 1 from mytable</code>" and it gives me this error:</p>
  
  <blockquote>
    <p>datasourceServiceImpl.error_0009
    query validation failed: query validation failed {0}</p>
  </blockquote>
  
  <p>This is all that it is giving me and I don't know how to fix this.</p>
  
  <p>I have biserver-ce-5.1.0.0-752 running</p>