We are using Pentaho 9.3.

Pentaho will work fine, but occasionally we will get an error message "Error connection to database [database_name]. Unable to get database metadata from this database connection".

The job that it occurs on is random each time.

Has anyone else had this happen to them? We are using SQL queries to do the data manipulation and then using a table output step to output the data.

Edit #1:

DBA confirmed nothing looks wrong in the database itself, but on the application.

We are using Pentaho 9.3.

Pentaho will work fine, but occasionally we will get an error message "Error connection to database [database_name]. Unable to get database metadata from this database connection".

The job that it occurs on is random each time.

Has anyone else had this happen to them? We are using SQL queries to do the data manipulation and then using a table output step to output the data.

Edit #1:

DBA confirmed nothing looks wrong in the database itself, but on the application.

• pentaho
• pentaho-spoon
• pentaho-data-integration

Share Improve this question Follow edited Mar 28 at 14:06 Chicken Sandwich No Pickles asked Mar 28 at 4:11 Chicken Sandwich No PicklesChicken Sandwich No Pickles 3,4021313 gold badges6565 silver badges126126 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Are you certain that there is no issue on the DB side, usually this occurs when there is connection reset happen with DB. Check the db logs as well for any connection failures.