Home Home
  login

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.




Script Error Upgrading from 3.6.5 to 3.7

migration

Hi, when i execute the last script from the DB upgrade (CreateProcsSQL2000.sql) i get the folowing error:

Server: Msg 107, Level 16, State 2, Procedure geminigetcreateissuelookups, Line 7 The column prefix 'a' does not match with a table name or alias name used in the query. Server: Msg 107, Level 16, State 2, Procedure geminigeteditissuelookups, Line 7 The column prefix 'a' does not match with a table name or alias name used in the query.

What can be done, to run it successfully?

Thanks in advance, Michael

PS. We use the MSSQL 2000 DB Server.

MTCP
· 1
MTCP
Replies (2)
helpful
0
not helpful

Yes, use the attached script.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

This script works! :-)

Thanks


MTCP
· 1
MTCP