Enterprise database is not compatible

Reporting
1

(imported topic written by jawed91)

I am getting the Following Error with web Report "Enterprise database ‘’ is not compatible with this version of Web Reports. I have SQL 2005 Standard Edtion as a remote database. The Database connection is fine. I have tested and Validated the connection. All the BES components are on a single machine. Any Help would be appreciated.

2

(imported comment written by SystemAdmin)

Hi Jawed,

This error message means that the Web Reports program and the BESReporting or BFEnterprise database that are being queried are not at the same release. There are several possible ways this can happen.

  1. If you recently upgraded your BES Server it may not have correctly upgraded your remote database. You may need run the database upgrade portion by hand to fix the database. Please contact support for help with this.

  2. The DSNs on the BES Server may not be pointing to the correct BES databases. On the BES Server, the LocalBESReportingServer DSN needs to point to the BESReporting database on the correct database server. The bes_bfenterprise DSN need to point to the BFEnterprise database on the correct database server.

3

(imported comment written by jawed91)

Hi Tyler,

Thanks for replying.

I have confirmed my DSN Settings. I can connect to the SQL Databases. I haven’t done any upgarde lately nor there are any logs of automatic updates. I am running BES 6.0. I am still having the issues Infact after checking all the DSN setting from OBDC in Control Panel, I am unable to log on to the Web Reports. So I suppoose I messed up something else too.

Help is much appreciated. Thanks

4

(imported comment written by jawed91)

Hi Tyler:

I got it working this time. The Strange part is On the BES Server, I configured the LocalBESReportingServer DSN to point BFEnterprise database instead of BESReporting database. Once I changed that and refreshed it the database was cached and I got the web report working. Has anyone faced this or I am the only one with this?

thanks for all the help

5

(imported comment written by Doug_Coburn)

It sounds like on the Web Reports Database configuration page the database you set up there did not point to the BFEnterprise database. LocalBESReporting should be set to the BESReporting database in the DSNs. Then in the database configuration page you are specifying which BFEnterprise database you would like to aggregate information from. If this database is not the proper version or pointing to another database besides BFEnterprise you will get this error.

6

(imported comment written by jawed91)

Thanks Doug, That was it. It solved the issue. On the web report database page I specifed DSN as LocalBESReportingServer and thats why I kept getting that error. Now after you mentioned it I changed the DSN to point to BFEnterprise database and it did the trick.

thanks again.