Bug 208501 AdapterException occurs when preview a crosstab with a integer type static level[1102]
Description: AdapterException occurs when preview a crosstab with a integer type static level[1102] Build number: 2.3.0.v20071102-0630 Steps to reproduce: 1, New a cube from CUSTOMERS 2, New a static level has two Member 1 and 2. 1's expression is dataSetRow["CUSTOMERNUMBER"]>250. 2's expression is dataSetRow["CUSTOMERNUMBER"]<250 3, New a crosstab using the cube 4, Preview Expected result: If we can convert Memeber 1 and 2 to integer type, the preview should be ok. If we do not do this convert we should throws out a proper exception. Actual result: org.eclipse.birt.report.data.adapter.api.AdapterException: java.lang.String OCCURS Error log: java.lang.String ( 2 time(s) ) detail : org.eclipse.birt.report.data.adapter.api.AdapterException: java.lang.String at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:479) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doPrepareQuery(DteDataEngine.java:100) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:138) at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:94) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:51) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:138)
data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/impl/DataRequestSessionImpl.java
* To use the limit fetch size setting in appContext on all levels' member
	 * number. Construct top_N filter definition base on all levels along edge.
	 * 
	 * @param edge
	 * @param size
	 * @return
	 */
	private List fetchFilterList( IEdgeDefinition edge, int size )
	{
		List filterExpression = new ArrayList( );
		if ( edge != null )
		{
			Iterator dimensionIter = edge.getDimensions( ).iterator( );
			while ( dimensionIter.hasNext( ) )
			{
				IDimensionDefinition dim = (IDimensionDefinition) dimensionIter.next( );
				String dimensionName = dim.getName( );
				Iterator hierarchyIter = dim.getHierarchy( ).iterator( );
				while ( hierarchyIter.hasNext( ) )
				{
					IHierarchyDefinition hierarchy = (IHierarchyDefinition) hierarchyIter.next( );
					Iterator levelIter = hierarchy.getLevels( ).iterator( );
					while ( levelIter.hasNext( ) )
					{
						ILevelDefinition level = (ILevelDefinition) levelIter.next( );
						String levelName = level.getName( );
						filterExpression.add( new FilterDefinition( new ConditionalExpression( ExpressionUtil.createJSDimensionExpression( dimensionName,
								levelName ),
								IConditionalExpression.OP_TOP_N,
								String.valueOf( size ) ) ) );