Invalid object name 'gemini_components'
Hi,
after upgrading from version 3.04 to 3.11 i got this error:
- Invalid object name 'gemini_components'
- .Net SqlClient Data Provider
when i try to open a project - Startpage, roadmap or protocol.
With the Query Analyser the Gemini SQLAccount is able to open this table.
Whats wrong? During the update all SQL Update scripts where successfull without errors.
Thanks,
Michael
MTCP
· 1 |
|
Tuesday, February 3, 2009, 6:05:36 AM |
0
|
It seems that we fixed this error. After the Update the Stored Procedure "gemini_getprojectsummarycomponents " was gone. (Don't ask me why!). We restored it from a test installation and now it works.
Best regards, Michael |
||||
|
0
|
I was getting the same error. the user I am running these scripts under was not the db owner. In the scripts, dbo is specified for a few of the stored procedures when being created |
||||
|
0
|
so geminigetprojectsummarycomponents was not actually gone in mine, it was just listed as |
||||
|
0
|
This depends on the sql user used to run the stored procedures. |
||||
|
0
|
That is what I said in my first post |
||||
|
0
|
In the setup script I have - there are several SP's that are created as DBO. |
||||
|
0
|
How did you remove [dbo]? |
||||
|
0
|
right click on the procedure, script it and change dbo to your new owner. |
||||
|