GROUP BY clause (8118) error

I don’t know why, but suddenly I’m always getting the error

[Microsoft][ODBC SQL Server Driver][SQL Server]Column ‘FIELDNAME’ is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.8118

and BO never adds a GROUP BY at the end of the SQL sentence!!! :crazy_face: :crazy_face:

Any idea??


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

BusinessObjects add a GROUP BY clause at the end of a query when the query involves at least 1 dimension and 1 measure with aggregation function.

In example,

If you have DIM_OBJECT as dimension, and MEA_SURE as measure, defined as count(MEA_SURE), B.O. automatically will GROUP BY DIM_OBJECT because you wish to yield the list of the distinct DIM_OBJECTs with the number of occurrences for each DIM_OBJECT.


Donald Duck :mexico: (BOB member since 2004-07-29)

What release are you running ? This was a bug in one of the earlier releases>


Michele Pinti (BOB member since 2002-06-17)

I’m using 6.1b; all my reports were working ok… until now!!! :reallymad:


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

Please check if the MEASURES are defined as:

aggregation_function(MEASURE_OBJECT)

For example:

count(EVENT_TIME)

max(OMC_NAME)

avg(SQUARE_ROOTS)


Donald Duck :mexico: (BOB member since 2004-07-29)

I had one user that had this problem. We had to reinstall Business Objects to ‘fix’ the problem.


Michele Pinti (BOB member since 2002-06-17)

yes, all reports worked until now… I tried also with just a dimension an a count object and I get the same error

I already tried to reinstall and still happens…

I’m starting to get nervous … :reallymad: :reallymad:

I’m going to uninstall - reboot - install… or maybe uninstall – reboot - pray - install…


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

Why don’t you regenerate the repository?


Donald Duck :mexico: (BOB member since 2004-07-29)

… after BACKUP, of course!!


Donald Duck :mexico: (BOB member since 2004-07-29)

Have you tried the reports on a different PC to see if the problem is localized or not?


Michele Pinti (BOB member since 2002-06-17)

ok… this is happening from other machines… so it looks like it’s time to look for some backup… :reallymad: :reallymad:

or is there any other solution or something to check before??


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

Do any of your tablenames in the database use reserved SQL keywords such as “From” etc?


Andreas :de: (BOB member since 2002-06-20)

I’ve my repository alone in a db, and I’ve tried access to different productions db, getting always the same error…. These productions db are the same that yesterday, when all was working fine…


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

Did your database connection change? Any change in the *.prm or *.sbo files?


Andreas :de: (BOB member since 2002-06-20)

I’ve just tried another repository that I’ve and that’s working fine, I get my GROUP BY… so, the problem is in the repository, that’s for sure…

but my question is the only way to solve that is a backup? :confused: :reallymad:


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

I’ve changed one connection into this repository…so :confused:


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

Are all the problems related to universes based on MS SQL Server using ODBC connections?

Do you have universes based on other DBMS such as Oracle? Do you get a similar error with those?

What exactly did you change :?:


Andreas :de: (BOB member since 2002-06-20)

yes, all problems are related to MS SQL Server using ODBC connections; I’ve just changed the data source name used, but I promise I’ll never do it again :cry:


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

ok… time to look for a backup…

incredible… :reallymad:

thanks a lot…


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

ok; backup restored. All is working fine!


Schuster :united_arab_emirates: (BOB member since 2002-08-29)