R&R ver 10+ Crashes On Grouping

[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?

[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?

[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

[Steve_C._(Guest)]

It also crashes with Preview.

[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

[Steve_C._(Guest)]

It is 10.1.002.

[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__

[kfleming]

Is there an alternate Oracle driver you can try to see if it makes a difference?____Kathleen__R&R Support

[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.________

[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