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.




SQL Server 2000 support still there?

web-app

I am preparing to upgrade an old 2.x installation and unfortunately I am stuck on SQL Server 2000 for at least a couple of months more. Is the 2000 support still intact in Gemini?

In preparation and to test the new features I've made a fresh test installation using 3.7.2 but the database installation fails due to the usage of the max data types.
mindphaser
· 1 		mindphaser
Monday, August 23, 2010, 10:51:16 AM
Replies (4)
helpful
0
not helpful

Yes, it is still supported for upgrades. If you'd like a new installation use the attached script.
Mark Wing
· 9108 		Mark Wing
Monday, August 23, 2010, 11:10:15 AM
helpful
0
not helpful

We do now have a Gemini 3.7.2 installation with a SQL Server 2000 database with data upgraded from 2.0.6

I have checked the database tables, stored procedures and views and they are identical to the scripts for a clean install.

Thus I am checking the converted data but are a bit in the dark as to potential tables to check. Any pointers?

TIA
Joakim

---

Listing issues in a project

Cannot sort a row of size 11278, which is greater than the allowable maximum of 8094. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at NHibernate.Driver.NHybridDataReader.Read() at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

Uploading attachments to an issue

could not insert: [CounterSoft.Gemini.Commons.Entity.FileEN][SQL: INSERT INTO geminiissueattachments (issueid, projectid, commentid, contenttype, contentlength, thefilename, filecontent) VALUES (?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9, ISession x45b53be31e53d68b) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558) at CounterSoft.Gemini.DataProvider.xc0186e148e957052.xc554864bca640c48(FileEN x36f36c4ee8dd56a7) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x062830ee083f0f7e(Int32 x5575a8aa585d598f, FileEN xfd903d9a9c51751c) at CounterSoft.Gemini.Presenter.IssuePresenter.CreateIssueAttachment(IssueEN issue, FileEN atta
mindphaser
· 1 		mindphaser
Wednesday, August 25, 2010, 4:12:59 PM
helpful
0
not helpful

Sorry, the script was wrong with some column data types. Attached is the corrected one.
Mark Wing
· 9108 		Mark Wing
Wednesday, August 25, 2010, 6:03:39 PM
helpful
0
not helpful

Working like a charm with the supplied table design and after some tinkering with image data that got truncated during the rerouted upgrade process.

Thank you for the assistance Joakim
mindphaser
· 1 		mindphaser
Thursday, August 26, 2010, 1:47:36 PM