All
Accepted answers
Pradip Patoliya · Jul 8, 2018 go to post

I have already verified the data with LAB person and we have confirmed that the problem with special character single quotes '. 

Pradip Patoliya · Jul 8, 2018 go to post

Up to 256 no issue because there is no special character single quotes in callbackcomment field. but 257 row has callbackcomment field with single quotes and it is given the error. verify below screenshot.

Pradip Patoliya · Jul 8, 2018 go to post

When I was selecting other field, there was no error. The problem is only with "CallbackComment" filed.

Pradip Patoliya · Jul 8, 2018 go to post

Thanks for the Answer. But I'm new to this cache domain, Could you please provide me the modified query that i can run using management portal.

Pradip Patoliya · Jul 8, 2018 go to post

Sorry Community, I was trying to hide some information because of our company policies.

Below is the brief  details.

We have application which has one script. That script is using SQL query which i have already mentioned. so that SQL query is giving us the error like "ODBC read failed" in that application.  So i have verified the Inter System ODBC connection and that is working fine. So for more investigation, I have connected to cache database using cache management portal. There i have set the ODBC mode and I have executed that same SQL query,  And i got the error "CSP application closed the connection before sending the response". So manually i have verified the data and found out that whenever single quotes is come in data, it is giving this error. SO this is the scenario.

Please give your suggestion and let me know if you have any question.

Thanks in Advance. 

Pradip Patoliya · Jul 7, 2018 go to post

1. Yes, We have index on PhoneDateODBC

2. As i have mentioned that i am using the Intersystem ODBC driver to connect the cache database. And it is failed to read special character single quotes. so please gives some details about that.