i upgradethe client to 11.0 and now i have issue with one ORACLE DB , i found the error in the debug file and as far as i understand it not success to query the data , i try to find out why , and run the query from PLSQL and i found out that the collector client add "to_timestamp" function to the query because the bookmark field is date , but the for some reason it add 'T' between the date and time , and because of that the query failed
this is the error in debug file :
ERROR 1 SQLClient::GetNextRecordData Failed to retrieve next record
this is the select it trying to run:
SELECT SOME_VIEW.A, SOME_VIEW.B, SOME_VIEW.C, SOME_VIEW.D, SOME_VIEW.EVENTDATE, FROM DATABASE.SOME_VIEW WHERE ((EVENTDATE>= to_timestamp('2018-11-13T15:52:49','YYYY-MM-DD HH24:MI:SS.FF'))) order by SOME_VIEW.EVENTDATE
when i try to run this query in PLSQL i'm getting error that this function has to include only numeric
if i remove the 'T' the query is running,
what can i do to get it work with this client ?
with collector client in version 10 it was working fine.
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.
Community Help Hub
New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.