Business Objects 5.1.6 and IBM DB2 Connect version 5

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


Graham Hill :uk: (BOB member since 2002-12-18)

v5 is still on the dropdown list when you’re creating connections, so i’m assuming it’s still supported … the PAR would tell you fer sure


Chris Pohl :us: (BOB member since 2002-06-18)

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.


scott copeland (BOB member since 2002-08-15)

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.


ybiru (BOB member since 2002-06-11)