Help with Splunk DB connect Rising search

[dorbi]

i have this search:

SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),'  ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY" 
WHERE C_CREATED_DATE_TIME > ?
ORDER BY C_CREATED_DATE_TIME ASC

and i want to add 

and

clause to the where section.

for some reason it doesn't work.

i tried:

SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),'  ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY" 
WHERE C_CREATED_DATE_TIME > ?
and C_CREATED_DATE_TIME > convert(varchar,'2022-08-31',121) 
ORDER BY C_CREATED_DATE_TIME ASC

and i tried:

SELECT
C_ID,
REPLACE(REPLACE(REPLACE(REPLACE(C_XML,'"',''''), CHAR(13), ''), CHAR(10), ''),'  ','') as C_XML,
C_TENANT_ID,
C_MESSAGE_PRIORITY,
C_CREATED_DATE_TIME,
C_WAS_PROCESSED,
C_LOGICAL_ID
FROM "ElbitErrorHandlingDB"."dbo"."COR_INBOX_ENTRY" 
WHERE C_CREATED_DATE_TIME > convert(varchar,'2022-08-31',121) 
AND C_CREATED_DATE_TIME > ?
ORDER BY C_CREATED_DATE_TIME ASC

both didn't worked.

any advice?

[dorbi · Accepted solution]

The problem was with the data itself (heavy).

Issues can be closed