Service Pack 1 Document Table Error

[Grant 702]

Hi

I have loaded on SP1 to Project Server and the associated service packs for
WSS and SQL. The following error occurs now when I try to open a project or
global template from within project professional:

"An unexpected error occurred.
The document table could not be opened. Contact your system administrator
for the database."

There is also nothing posted to the app event log as a result of this error.
Any help would be greatly appreciated.

Cheers
Grant

 

[Gary L. Chefetz [MVP]]

Did you properly run and apply the SQL script for the Project Server
database as part of your upgrade. It sounds as though this step may have
been omitted or improperly applied.

 

[Grant 702]

Hi Gary

I believe these were applied properley. I copied osql.exe to the same
directory and ran Upgdb111.cmd from the command line. This resulted in the
normal display of numerals (matrix style) in the command window. Do you have
any other suggestions Gary?

Regards

 

[Grant 702]

Error corrected after I applied SP2a for Project Server (SQL + Proj Serv) and
SP2 to project professional.

Thanks