No rows returned - [Cache ODBC][State : HYC00][Native Code 469]

Primary tabs

ODBC, SQL, Caché

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

Replies

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)});