TD-15968: Data truncated(Oracle) in Long String TD6 Sp3

Post found bugs and possible workarounds.
Sunil

TD-15968: Data truncated(Oracle) in Long String TD6 Sp3

Post by Sunil » 07 Jul 2011, 10:42

Hello,

I am using Oracle 10g server and 10g on client. I am using two Pc , one for Deployment and another for Development.
I had download deploy60 and patch sp3 and run deploy60 on Deployment PC and patch sp3 on development PC.

I have seen that date of sqlora32.dll is still 01.04.2011 on Deployment PC , that mean sqlora32.dll has not been updated
after deployment using new deploy60.

I have seen that date of sqlora32.dll changed to 28.06.2011 on development PC where new patch applied.

//deployment PC
select long string data from oracle table into multiline text ( long ) is ok here.
//development PC
select long string data from oracle table into multiline text ( long) ,here text truncated.

to repro the case, I have copied sqlora32.dll from deployment PC to development PC and tried again , this time that was ok.

Please look this issue which is very serious issues.

Regards.
Sunil
Last edited by Sunil on 12 Jul 2011, 05:08, edited 1 time in total.

Jeff Luther

Data truncated(Oracle) in Long String TD6 Sp3

Post by Jeff Luther » 08 Jul 2011, 00:20

Yes, here's what I see when I click Deploy60 from this page: http://www.guptatechnologies.com/Servic ... loads.aspx
It prompts me to save TD-60SP2-DEPLOY.zip

which means that QA/internal people have not updated the deploy download yet. Sounds like that is why your sqlora32.dll files are not in sync; the dev. one is for SP3, while the deploy one is for SP2.

I'll remind the 'internal types' that deploy60 needs to be updated to SP3. Thanks for letting us know. And in the meantime copy the updated SP3 DLL to your deploy folder, as you've done.

Sunil

Data truncated(Oracle) in Long String TD6 Sp3

Post by Sunil » 08 Jul 2011, 02:38

No, Jeff.
I had download deploy60sp3.zip from this link earlier and applied the same on deployment PC. I agreed , this is showing now sp2 deployer. Please look this issue asap.

Regards.
Sunil

Ana Paula Bonani

Data truncated(Oracle) in Long String TD6 Sp3

Post by Ana Paula Bonani » 11 Jul 2011, 13:16

Fixed.

Please download the deployment package again.

Thanks,

Sunil

Data truncated(Oracle) in Long String TD6 Sp3

Post by Sunil » 11 Jul 2011, 15:49

Hello.
I have download and applied but problem is still there, I am sending two sqlora32_old.dll and sqlora32_new.dll . sqlora32_new.dll [ Problem DLL ] is new one which is download as ana said.

Regards.
Sunil
You do not have the required permissions to view the files attached to this post.

Jeff Luther

Data truncated(Oracle) in Long String TD6 Sp3

Post by Jeff Luther » 13 Jul 2011, 19:33

Sunil: If you are still having this "data truncated Oracle" issue after downloading/installing v6 SP3, then I will need a small reproducible test case from you (test app + SQL script to create/insert some data into Oracle) so I can test this data truncation issue myself.

Earlier, you had an inconsistency in sqlora32.dll between runtime and dev/IDE, but I believe you got the correct SP3 runtime available here:
http://www.guptatechnologies.com/Servic ... loads.aspx

I just installed the runtime and compare sqlora32.dll to my dev. folder and they are the same file now:
JL-v6SP3-DEV_sqlora32_DLL-OK.png
JL-v6SP3-RUNTIME_sqlora32_DLL-OK.png
** We need a test case to see what this "problem is still there" issue is.
You do not have the required permissions to view the files attached to this post.

Sunil

Data truncated(Oracle) in Long String TD6 Sp3

Post by Sunil » 14 Jul 2011, 11:49

Hello jeff.

find enclosed sqlora of Sp2 and Sp3 , sp2 is correctly working where as sp3 is truncating data when populate long string into multiline text(datatype long).

Regards.
sunil
You do not have the required permissions to view the files attached to this post.

giscon

Data truncated(Oracle) in Long String TD6 Sp3

Post by giscon » 14 Jul 2011, 15:18

Hello,
I can confirm this problem.
In my bug report
http://newforum.com/phpBB3/viewtopic.ph ... &sk=t&sd=a
I described a problem with TD6, SqlBase 11.6 and LongString (the two extra bytes at the end are missing when selecting into a variable).
Jeff told, that this defect has got the id TD-15761.

With the testcase I uploaded with my above mentioned bug report, the bug was only with SqlBase 11.6, with Oracle-DB's all ran fine.
That was the situation with SP2 EMP5347.

Now, reading this new bug report, I tried my testcase again with SP3 and an Oracle-DB.
And oops, now the LongString is truncated - instead of getting the 'Testvalue' ( string length 9, with the two null-bytes bufferlength 20), now you get only 'Testv' ( stringlength 5, bufferlength 12 ).

Maybe that testcase helps also a bit to reproduce this new bug
Guenter

Mike Vandine

Data truncated(Oracle) in Long String TD6 Sp3

Post by Mike Vandine » 21 Jul 2011, 23:55

Hi Guenter,

This should be fixed with EMP5361 as well.

Sunil

Data truncated(Oracle) in Long String TD6 Sp3

Post by Sunil » 22 Jul 2011, 15:21

This is fixed for SQLBase but not for Oracle. Data fetched from Oracle Long string to Multiline text is still truncating.

Regards.
Sunil

giscon

Data truncated(Oracle) in Long String TD6 Sp3

Post by giscon » 22 Jul 2011, 18:22

Indeed, the EMP5361 contains in fact a new sqlora32.dll (from 2011-07-21), but this bug is still there as Sunil wrote:
This is fixed for SQLBase but not for Oracle. Data fetched from Oracle Long string to Multiline text is still truncating.
Don't know if some other oracle-issues are fixed with this sqlora32.dll, because in the README-EMP5361.txt is nothing to find about Oracle.

As mentioned above in this topic, this bug with Oracle Long String truncation appeared new in SP3 with that sqlora32.dll.
With my uploaded testcase you should have got 'Testvalue" (stringlength 9, bufferlength 20) and of course it should work for a SELECT into a Long String Variable, a Data Field or a Multiline-Field as well.

But since SP3 the string is always truncated (in the example to string length 5, buffer size 12).
Now with the SP3 EMP5361 the string is still truncated, but when selecting into a long string variable, the buffer has even 2 more useless bytes (truncated string with length of only 5, but a buffer length of 14 ).

Regards
Guenter

Mike Vandine

Data truncated(Oracle) in Long String TD6 Sp3

Post by Mike Vandine » 25 Jul 2011, 10:58

Hi Sunil,

Looking at the thread and also at the defect, it looks like the comments from Guenter, "Jeff told, that this defect has got the id TD-15761", were seen by Ana (who escalated *that* defect), but unfortunately that defect did NOT have the Oracle issue reported with it so the Oracle bit was not fixed.

I have reported this urgently to Development as defect TD-15968, specifically for the Oracle problem.

So sorry for the delay in getting this resolved.

Best regards,

klaus@easypro

Data truncated(Oracle) in Long String TD6 Sp3

Post by klaus@easypro » 01 Aug 2011, 13:15

Hi all,

our application (at the moment on TD6.0SP3+EMP5361) connects to Oracle 11g R1 and I didn't get truncated data so far.
But I obviously ran into the defect regarding two trailing null-bytes. As in one of the two other topics (http://newforum.com/phpBB3/viewtopic.php?f=69&t=6879 and http://newforum.com/phpBB3/viewtopic.php?f=69&t=7076) described, any further string processing fails.

Resetting the bufferlength or just trim the string would be a workaround but unfortunately it is impossible to use that workaround because the statements with into variables are build dynamically at runtime.
As this is a really urgent issue, I hope that there will be an EMP asap.

kind regards
klaus

Jean-Marc Gemperle

Data truncated(Oracle) in Long String TD6 Sp3

Post by Jean-Marc Gemperle » 09 Aug 2011, 12:52

Hi

Will be fixed with EMP5363 see http://newforum.com/phpBB3/viewtopic.php?f=69&t=6879

Jean-Marc

giscon

Data truncated(Oracle) in Long String TD6 Sp3

Post by giscon » 09 Aug 2011, 13:40

Hi,
in the other topic your refer to
Will be fixed with EMP5363 see viewtopic.php?f=69&t=6879
you added two bitmaps.
The lower of them shows that the concatenation problem because of wrong buffer length (here 2 bytes too long) may be fixed, but the truncation problem with Oracle still exists ! Only 5 characters are selected, but with the testcase there should be 9 ("Testvalue") !!
Hope that this will be fixed, too.

Regards
Guenter

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests