TD-23777: [TD639/TD702/TD703] Oracle BLOB data is truncated at 64K boundary

Post found bugs and possible workarounds.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

TD-23777: [TD639/TD702/TD703] Oracle BLOB data is truncated at 64K boundary

Post by Dave Rabelink » 18 Oct 2017, 08:50

This issue is registered as:
Ticket # 3314096: Oracle BLOB data is truncated at 64K boundary.

Found on x86 versions of:
TD 6.3.9
TD 7.0.2
TD 7.0.3

When using Oracle BLOB datatype, the data is truncated at 64K boundary.
It does not matter using Long String or Binary TD datatypes, the result is that data larger than 64K is truncated.

See testcase.

Oracle_Long_Insert&Select.zip

Steps to reproduce using testcase:

1) Make sure to enter database/user/password variables in the Init() function of the main form.
The user should have CREATE TABLE/DROP TABLE privileges.
The testcase automatically creates the needed table/column and drops it.
2) Run application. See that the picture object contains a large image at the left upper side of the form.
3) Press the button "Insert DB" below the image. It inserts the picture data into Oracle database
4) Press the button "Select DB" at the right side of the form, below the empty picture object
5) See that the buffer size of the selected data is not coming above 64K. The picture object stays empty
6) Uncheck "Big data" checkbox to load a smaller image
7) Redo steps 3 and 4
8) See that a smaller image is working correctly.

The testcase is in TD63 (shows that it works there) and TD70 where it fails.
You do not have the required permissions to view the files attached to this post.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: Oracle BLOB data is truncated at 64K boundary

Post by Dave Rabelink » 18 Oct 2017, 09:18

I tested TD 6.3.9 and is also failing !!

When using sqlora32.dll from TD7.0.1, it works ok.
Using TD 7.0.2, it fails.

Strangely, reading the fix list for TD 7.0.2, it states this as a fix:
TD-23564 Failed to fetch long data greater than 64 KB from ORACLE
So 7.0.2 actually breaks it, there was no issue on TD 7.0.1.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: [TD639/TD702/TD703] Oracle BLOB data is truncated at 64K boundary

Post by Dave Rabelink » 18 Oct 2017, 09:27

A workaround is to copy sqlora32.dll from a working TD runtime (TD7.0.1) to the TD7.0.3 runtime folder.
But I'm not sure that will break something else.

Waiting for TD defect number and Gupta to hotfix this.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 275
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: TD-23777: [TD639/TD702/TD703] Oracle BLOB data is truncated at 64K boundary

Post by Dave Rabelink » 20 Oct 2017, 04:45

From Gupta:
We are able to reproduce your issue. A Jira ID has been created TD-23777 for your reference. Its currently slated to be fix on version 6.3.10 and 7.0.4
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Bug Reports”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests