Unable to see data in DB connect

[rakesh44]

Below is the date mentioned in DB query Input , but am getting only few months data

Am getting only Jun-17, Jul-17, May-17, Apr-17,Mar-17,Feb-17,Jan-17 rest month data is missing

DB Query:
To_char(fdml.as_of_date, 'Mon-YY') IN ('Jan-17, 'Feb-17', 'Mar-17', 'Apr-17', 'May-17', 'Jun-17', 'Jul-17', 'Aug-17', 'Sep-17', 'Oct-17', 'Nov-17', 'Dec-17', 'Jan-18', 'Feb-18', 'Mar-18', "Apr-18', 'May-18', 'Jun-18', 'Jul-18', 'Aug-18', 'Sep-18', 'Oct-18', 'Nov-18')

[rakesh44 · Accepted solution]

This is caused because of fetch size default is 300 , when i increase it issue is resolved

[inventsekar]

Are you running it as a regular user or splunk admin?

<<< Am getting only Jun-17, Jul-17, May-17, Apr-17,Mar-17,Feb-17,Jan-17 >>>
how many results you get? is there any limits.conf issue?

[rakesh44]

Appreciate for both reply , able to find out issue. I re-run the query with specific date & time & removed * from execution frequency and hence fetch the data with month wise , after that i disabled the query.
Good Learning.Thanks

[kmaron]

does the data exist if you run the query outside of DB connect?