I have a script that fetches recently changed records from NS, via the ODBC connection. About the middle of the day yesterday, I started receiving sporadic ODBC errors that I've never seen before.
For example, at 4:10am this statement was executed (... denotes a bunch of columns I'm selecting):
SELECT ... FROM customers WHERE last_modified_date > '2015-03-11 07:14:59';
It failed with this error:ERROR -- : HY000 (10169) [unixODBC][DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Error getting the literal value of right operand.[10169] (ODBC::Error)
But then at 4:40am, the same statement was executed again successfully.If it wasn't sporadic, I'd think there was something wrong with my date format. But as it is, I'm thinking it might be something else.Has anyone else seen this?