SP11 The index 1 is out of range.

SpagoBI error
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:700)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:709)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setString(SQLServerPreparedStatement.java:1034)
        at org.eclipse.birt.report.data.oda.jdbc.Statement.setString(Statement.java:649)
        ... 78 more


Problem :
i was using count(*)  in selection of query in dataset.

Solution:
Use count(field_name) in query , instead of *

This error generally came because of use of * in database query.