topic Re: Qlik Sense CLOB 100 character load limit? in Connectivity & Data Prep

Qlik Sense CLOB 100 character load limit?

Fri, 24 Mar 2017 20:02:07 GMT

Hi there,

I am using Qlik Sense 3.1 SR1 in a server environment. I am pulling from Oracle R12 via OLE DB drivers. Everything works great, and it's pretty snappy.

I've discovered that one of our long text fields is getting truncated to 100 characters. I can't figure out why, however IT has informed me that it's stored as a CLOB attribute.

I have searched through this forum and others to try and find a valid front-end solution, but it seems like most of it is related to failed loads, not truncated loads. Does anyone have any input or experience with this issue? If so, any help retrieving the full text from the field, or even a few thousand characters would be greatly appreciated.

Thanks!

Re: Qlik Sense CLOB 100 character load limit?

Gysbert_Wassenaar — Sat, 25 Mar 2017 17:42:35 GMT

It's not a limit of Qlik Sense. Probably a limit of the oledb driver. Perhaps the same as mentioned here: powershell - OLEDB truncating Oracle LONG datatype to 100 characters - Stack Overflow

Re: Qlik Sense CLOB 100 character load limit?

Mon, 27 Mar 2017 17:47:53 GMT

Thanks. It wasn't this issue, but it was indeed another cause not related to Qlik.