We are getting an error USR00065, that indicates an upgrade to the repository, but we didn’t do any upgrade??? How can we make sure which version we have?
Anne Furtado (BOB member since 2002-09-23)
which is the text which came with the error code. If I understand, you suspect your repository to have been updated ? In which BO release should you normaly be ? You will find a lot of post saying the repository structure change between 4 5 and 6 bo version
Then, depending which tables you will find in your repositor, you will determine your repository type (4,5 or 6)
bernard timbal 
(BOB member since 2003-05-26)
Run the following SQL in the repository schema:
For oracle:
SELECT Count(*) AS Count FROM tab.
If the result is “56”, then the repository is in BusinessObjects version 6.5;
If the result is “50”, then the repository is in BusinessObjects version 5.x, 6.1;
if the result is “44”, then the repository is in BusinessObjects version 4.x.
Alternatively:
The OBJ_M_GENPAR table allows an easy way to find this information.
If record # 121 in that table has a value of “0” in M_GENPAR_N_VALUE, then the repository is 5.x format.
If that value is “1” instead, then the repository is 6.x format.
Here is a sample of SQL you could use to query this information:
select m_genpar_n_value
from obj_m_genpar
where m_genpar_n_id = 121
Hope this helps
BO_Chief 
(BOB member since 2004-06-06)
Thanks Irfan,
just add "where tname like ‘OBJ%’ or tname like 'UNV% to above query
if you have auditor or any other repository installed in same schema.
BOBurao (BOB member since 2005-09-20)
I remember that BO 6.1 has also 50 tables…
Is it correct?
Srinath
srinath2003 (BOB member since 2005-01-06)