No rows returned - [Cache ODBC][State : HYC00][Native Code 469]
Hi,
I get this error [Cache ODBC][State : HYC00][Native Code 469] and zero rows returned with the following query.
SELECT "Timestamp","Skillset" FROM "dbo"."iSkillsetStat"
WHERE (Timestamp >= '2020-06-29 00:00:00'
AND Timestamp < '2020-06-30 00:00:00')
I'm using Qlik Attunity Replicate to extract data, the query was formatted by the tool. The query will return data in excel and SSIS, but not using Replicate.
So far I've tried using two ODBC drivers
-----------------------------------------------------
Driver Name: CacheODBC64.DLL
Unicode Client Version: 2017.2.2.865.0
Compiled at: Jun 25 2018 10:31:42
ODBC Version: 02.50
Locale Setting: English_United Kingdom.1252
-----------------------------------------------------
Driver Name: CacheODBC3564.DLL
Unicode Client Version: 2017.2.2.865.0
Compiled at: Jun 25 2018 10:32:27
ODBC Version: 03.51
Locale Setting: English_United Kingdom.1252
-----------------------------------------------------
Here's hoping someone can help with this issue
Regards,
Dave
in your query, I see "Timestamp" and Timestamp
Check the status of SUPPORT_DELIMITED_IDENTIFIERS parameter
Next check the date type of your column named Timestamp.
easiest SELECT top 5 "Timestamp","Skillset" FROM "dbo"."iSkillsetStat"
also try SELECT Timestamp,Skillset FROM dbo.iSkillsetStat
without any quoted columns
I can't disable quoting of identifiers with the Replicate tool. However, I can run both quoted and unquoted versions of the query successfully with Microsoft SSIS, that is whilst using the same ODBC driver.
I managed to solve the problem as follows
-- current day
WHERE (Timestamp >= {fn CONVERT(CURRENT_DATE,SQL_TIMESTAMP)}
AND Timestamp < {fn CONVERT(DATEADD(dd,1,CURRENT_DATE),SQL_TIMESTAMP)} )
-- previous day
WHERE
(Timestamp >= {fn CONVERT(DATEADD(dd,-1,CURRENT_DATE),SQL_TIMESTAMP)}
AND Timestamp < {fn CONVERT(CURRENT_DATE,SQL_TIMESTAMP)});