Can anyone tell me whether or not Business Objects version 5.1.6 and IBM DB2 Connect version 5 are compatible ? We currently have an application running BOb version 5.0 with DB2 version 5 and have encountered some problems in testing the BOb upgrade, eg an error reported as “Error during SQL generation - Your database does not allow you to do aggregations with the Cover Name object” occurs for a report that runs OK under 5.0
We are using version 7 of DB2 Connect (os390) and I haven’t seen much difference in any of the versions in BO when you build a connection. I think most of my connections are using V6 still. Just never did seem to matter.
I am wondering tho if this column is a varchar maybe which needs to be a longtext in BO universe. Seems like I have had similiar errors with this.
In the db2*.prm file, there two parameters, GROUPBY_EXCLUDE_COMPLEX and GROUPBY_WITHOUT_CONSTANT. Try setting one or both of them to N and see if it helps.