#3 ODBC crashes when querying Log table

[Anonymous]

I have a simple query that i need to bring into our BI suite that pulls in the log information (ALL_SCHEDULER_JOB_RUN_DETAILS) from my oracle database. Every time the query is run the tool crashes with no error message generated. When querying the data via toad for oracle the query executes perfectly its just ODBC that has a problem.

I was wondering if there is a setting that can be adjusted to allow ODBC to query this table. I have been searching all over the internet for an answer or a fix to this issue and have not found anything on it, hopefully someone on here can help.

Here are the system details:
Oracle Client: Oracle 11g
Ingestion tool: ODBC Query Tool
https://sourceforge.net/projects/odbc-query-tool/
Query:

Select trunc(log_date) as Update_Date,JOB_NAME,
MAX(STATUS) as MOST_RECENT_UPDATE_STATUS,
Max(ERROR#) ENCOUNTERED_ERROR,
Sum(1) as UPDATES_RUN,
MAX(RUN_DURATION) as UPDATE_DURATION
from ALL_SCHEDULER_JOB_RUN_DETAILS
where OWNER = 'RPT'
group by JOB_NAME,trunc(log_date)
order by Job_NAME,trunc(log_date) desc

[e_jim]

Hi there! This is the author of ODBC query tool here. It's hard to diagnose the problem without having the same dataset, but I have two questions:

1. How many records is this particular query returning? Perhaps it's very large and some buffer might be overrun, but I somehow doubt it
2. Do you get the same error when running the same query with some other tool which connects over ODBC? Please try that and report back...