[shawkins]

If you can still reproduce this in squirrel, then can you set the squirrel File->Global Preferences->SQL option of Debug to either writer or stream - and post the client's full stacktrace from the exceptions above.

Thanks,

Steve

[aswathkhan]

Sorry for the delayed response as I had to move my focus on certain business priorites. Now I'm back.

Hi Steve,

     Please find the attached log from the Squirrel SQL's JDBC Debug SQL Writer.

Hi Ramesh,

    Local VDB - I have the client and the VDB deployed in the same machine

    Remote VDB - I have the VDB & client in different machines. I'm trying to access the VDB after deploying the VDB in the remote server than that of the client

I could able to figure out the issue that the problem is with the data. I tried accessing the CSV files after masking it uniformly across all the columns, to my surprise I could access it remotely with out any issue. So there is a problem with the data, I tried finding out but could not. But I went through each and every one of the 30,000 records manually, I could not find any thing abnormal with the data, so there is something different as I could access the same set of data when I have the VDB in the same machine as that of the client.

Thanks,

Aswath

[shawkins]

Aswath,

The log doesn't show anything abnormal from a client perspective.  The exception is from the text table node - which I will update to include the line number. 

Steve

[rareddy]

Aswath,

Can you share your taxt data file? I was not sure if I already asked this question. If you can share along with your VDB may be can recreate and see what the issue is.

Ramesh..