Page 1 of 1
R&R ver 10+ Crashes On Grouping
Posted: Wed Oct 11, 2006 4:48 pm
by Steve_C._(Guest)
I create a very simple report. ____It includes an empty page header-Record-empty page footer.____I have some records (about 800 ) in a table within oracle that I am trying to access. I want info from two columns. Column 1 is a calculated field named CatExpr, based on the column ^Category^.____iif( isnull(Category), ^Category Not Specified^, Category )____The second column is named studynum and is a text field.____If I simply have both columns in the Record band, I can View Result Set without any problem. ____If I sort on studynum and then View Result Set, no problem.____If I sort on catexpr and then View Result Set, no problem.____If I sort on catexpr and then studynum, View Result Set, no problem.____If I group on catexpr (sort options set to catexpr and studynum), then View Result Set, report designer crashes.____Any thoughts on how to debug this one?
=> RE: R&R ver 10+ Crashes On Grouping
Posted: Wed Oct 11, 2006 5:06 pm
by Steve_C._(Guest)
If I truncate the string to 80 characters, the software no longer crashes. The field itself is defined as a varchar2(4000). We are not presently using it so no big deal.____However, the software should not be crashing.____Are there any logs that could be looked at when something like this happens?
==> RE: R&R ver 10+ Crashes On Grouping
Posted: Thu Oct 12, 2006 7:55 am
by kfleming
There are no logs that would help debug this kind of crash. If you preview rather than viewing result set does the same error occur?____A result set creates a Foxpro table where the max length of any field should be 254 characters. I am going to re-test how we handle long text fields from SQL when we go to result set to see if that is indeed the source of the problem.____Kathleen__R&R Support
===> RE: R&R ver 10+ Crashes On Grouping
Posted: Thu Oct 12, 2006 12:22 pm
by Steve_C._(Guest)
It also crashes with Preview.
====> RE: R&R ver 10+ Crashes On Grouping
Posted: Thu Oct 12, 2006 3:22 pm
by kfleming
Is it 10.1.003?____I just did a similar test (but using a SQLServer varchar2 field) and I am not crashing.______Kathleen__R&R Support
=====> RE: R&R ver 10+ Crashes On Grouping
Posted: Fri Oct 13, 2006 4:21 pm
by Steve_C._(Guest)
It is 10.1.002.
======> RE: R&R ver 10+ Crashes On Grouping
Posted: Fri Oct 13, 2006 5:08 pm
by Steve_C._(Guest)
I upgraded to 10.1.003 and the product still crashes if I don^t truncate the string.____I am also using the following:____Oracle 9i__DataDirect Oracle Driver__ lmOR819.dll version 4.20.0000____Please let me know if there are other components that I might look into.____Thanks,__Steve__
=======> RE: R&R ver 10+ Crashes On Grouping
Posted: Sun Oct 15, 2006 7:29 pm
by kfleming
Is there an alternate Oracle driver you can try to see if it makes a difference?____Kathleen__R&R Support
========> RE: R&R ver 10+ Crashes On Grouping
Posted: Mon Oct 16, 2006 10:13 am
by Steve_C._(Guest)
Co-worker is using "version 9.02.00.00 file is sqlora32.dll".____They do not see the crash but they get garbage on varchar2.________
=========> RE: R&R ver 10+ Crashes On Grouping
Posted: Tue Oct 17, 2006 5:54 am
by kfleming
Then you may be left with having to truncate the string to get around what seems to be a bug in our handling of the driver.____Kathleen__R&R Support