I would recommend to turn on logging on the PI OLEDB Provider. You can do that by passing parameters in the connection string. Please refer to the documentation for that.
Maybe this will give more details about what is happening.
Also, it would be useful to know what provider and version you are using? OLEDB Enterprise or OLEDB Provider classic?
I would like to highlight here that the PI System is not a relational database. And OLEDB Product are a commodity to access the data as if it was a relational database. This makes a big difference.
This also means that you need to have a relatively good understanding of what is happening behind when writing your queries.
The type of tool you are trying to configure may generate unsupported queries and also sub-optimal queries and performance may suffer from that.
I also normally recommend these readings when working with OLEDB Products:
I hope this helps and please let us know how it goes on your end