I have a BEx query that I am using as a data source for my Crystal Report. I am using Crystal Reports 4.0 SP02, BW 7.3 SP3, Query Designer 3.5. I have two structures that I am using, one key figure structure in the columns and a then a non-key figure structure in the rows. The query runs fine when I run it via the analyzer and via RSRT. However, after I attempt to build my Crystal report I receive the following error (see attached): Failed to execute query []<java.lang.ArrayIndexOutOfBoundsException:1>. Redesign your query or contact the data source maintainer to solve the problem. I receive this error right after I click "finish" when adding my key figures (measures) and characteristics to the report. In my key figure structure I am using several user exits for dates so that I can avoid using prompts (the report will be pushed out to users each day).
Has anyone else received this error before when using two structures in a BEx query as a data source for a Crystal Report?
Thank you.
Josh Dunlap