Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Error upgrading database from 2.2.1 to 3.0.4

web-app

Hi,
I hit error when upgrading my 2.2.1 database to 3.0.4 using the SQL Package application located under Gemini Database folder as below. Any ideas? Should I run the script manually? BTW, where could I get the upgrade instruction doc?

<SQLError Package="CounterSoftGeminiv301SampleDatabase"><Error>There is already an object named 'geminigetissuereportersforallprojects' in the database.</Error><Assembly>CounterSoftGeminiv301SampleDatabase</Assembly><Package>Package1.resx</Package><Batch>Batch642</Batch><SQL>
CREATE PROCEDURE gemini
getissuereportersforallprojects
as
begin

SELECT b.projectid,a.firstname+N' '+a.surname AS fullname
FROM geminiusers a join geminiissues b on a.userid=b.reportedby
GROUP BY b.projectid,a.firstname+N' '+a.surname
ORDER BY fullname

end
 
</SQL></SQLError>

Thank you

chanmy8
· 1
chanmy8
Replies (1)
helpful
0
not helpful

You need to run the upgrade scripts manually.

You can find all docs here: http://www.countersoft.com/Default.aspx?PageID=58


Mark Wing
· 9108
Mark Wing