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 importing between Gemini Instances

migration

Greetings,

Presently, our organization has two separate instances of Gemini, both running the same version (v3.6.5 BUILD 2638). We are attempting to consolidate all Projects into a single instance. Per the documentation, I have downloaded the 'Gemini Data Import' utility, and can successfully connect to the Target and Source instances.

However, when I select a Project to import, and click the 'Import' button, an error message is thrown: "Transaction failed! Contact your Gemini Administrator." (Being the administrator, I contacted myself, but was unable to offer any insight.)

Within the 'Gemini Data Import' log file, I found the following information:


Gemini Issue Tracker Log v3.7.2 Build 2784 9/1/2010 1:35:14 PM

** Import Status ** Application Scanning Bridge Project not imported due to bad data

Final Status

Failure: 1 Project(s) not imported

Application Scanning Bridge

Note: All Components, Versions, Issues for failed projects are rolled back

Troubleshooting:'Transaction Failed'

1) Ensure your source data conforms to the guidelines specified in the Gemini Data Import User Guide (All Programs > Countersoft > Gemini Data Import > Gemini User Guide)

2) While importing from CSV and Excel, ensure source date format is set as per format specified in Sample CSV and Excel files.

3) To trace failure reason, run DebugView from All Programs > Countersoft > Gemini Data Import > DebugView or http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx and retry to import the failed project. DebugView will most likely trap the fail error(s). Send DebugView output to support@countersoft.com.

4) If you are importing from CSV, Excel Fixed Format or Excel Flat Format, you can email your sample source data to us at support@countersoft.com. We will review and provide feedback.

Troubleshooting:'Project already exists'

1) In case the exact Project Code exists in the destination Gemini instance, either the source or destination Project Code will have to be re-named.

2) Projects once imported cannot be re-imported without deleting in Gemini


Since I have triple-checked that the Project ID's are unique between the two instances, and the error message I received stated 'Transaction Failed', I checked the Troubleshooting steps listed in that section of the log. Per those instructions, I downloaded the 'DebugView' application, and attempted the import again. The contents of the 'DebugView' log did not assist me in moving further:


[1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start Importing [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Project Prepare to Import [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Load Project data [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Checking existance of project code APP [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start Project Creation [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Exception occurs on Project creation. Exception has been thrown by the target of an invocation. [1992] could not insert: [CounterSoft.Gemini.Commons.Entity.ProjectEN][SQL: INSERT INTO geminiprojects (projectcode, projectname, projectdesc, projectreadonly, projectarchived, globalschemeid, issuetypeschemeid, issuepriorityschemeid, issueseverityschemeid, issueworkflowid, fieldvisibilityschemeid, resourcemode, componentmode, userid, projectlabelid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] [1992] could not insert: [CounterSoft.Gemini.Commons.Entity.ProjectEN][SQL: INSERT INTO geminiprojects (projectcode, projectname, projectdesc, projectreadonly, projectarchived, globalschemeid, issuetypeschemeid, issuepriorityschemeid, issueseverityschemeid, issueworkflowid, fieldvisibilityschemeid, resourcemode, componentmode, userid, projectlabelid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] :: CounterSoft.Gemini.WebServices :: at CounterSoft.Gemini.WebServices.BaseService.ThrowResponseException(WebResponse response) [1992] at CounterSoft.Gemini.WebServices.BaseService.ProcessResponse[T](String url, Object obj, RequestType requestType) [1992] at CounterSoft.Gemini.WebServices.BaseService.GetResponse[T](String url, Object o, RequestType r) [1992] at CounterSoft.Gemini.WebServices.ProjectsService.CreateProject(ProjectEN project) [1992] at CounterSoft.Gemini.DataImport.Mapping.ProjectImporter.ImportProjects(String& selectedProjectsIDSeperatedByComma) [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Transaction failed! Contact your Gemini Administrator. [1992] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: End Importing


Within the 'DebugView' log, I noticed that the lines starting with 'could not insert:' list the SQL query being executed. I noticed that the 'VALUES' clause contains nothing but question marks, but I can't tell if that means the import utility cannot access the data correctly, or if the values are simply obfuscated when displayed in the debugger.

I've been unable to identify any other posts in the forum(s) which relate to this issue. I'm not really sure where to continue/start troubleshooting this on our end. Could the '?'s displayed in the VALUES clause indicate an issue with permissions/network access? Are there additional preparatory steps which must be completed prior to merging two Gemini instances?

Any assistance (particularly a magic-pill answer) will be greatly appreciated.

Thank you.

LBS_gemini-admin
· 1
LBS_gemini-admin
Replies (7)
helpful
0
not helpful

Which version of the import app are you running? Seem like 3.7, which will not work with 3.6.x.
Also, check the target Gemini's system log.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

The import app was downloaded today, as version 3.7.2 BUILD 2784. How would I go about obtaining a previous version of this utility?

Regarding the target Gemini's system log, I found the following records were written upon a failed import:


119 9/1/2010 2:19:37 PM Error Gemini could not insert: [CounterSoft.Gemini.Commons.Entity.ProjectEN][SQL: INSERT INTO geminiprojects (projectcode, projectname, projectdesc, projectreadonly, projectarchived, globalschemeid, issuetypeschemeid, issuepriorityschemeid, issueseverityschemeid, issueworkflowid, fieldvisibilityschemeid, resourcemode, componentmode, userid, projectlabelid) 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.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(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.Business.xa37334733da24461.x11613c10bb40435f(ProjectEN x4982e05b3cc913d8) at CounterSoft.Gemini.Presenter.ProjectPresenter.CreateProject(ProjectEN project) at CounterSoft.Gemini.Web.Api.ProjectsRestHandler.ProjectCreate(RequestDetails rd)

120 9/1/2010 2:19:37 PM Error Gemini could not insert: [CounterSoft.Gemini.Commons.Entity.ProjectEN][SQL: INSERT INTO geminiprojects (projectcode, projectname, projectdesc, projectreadonly, projectarchived, globalschemeid, issuetypeschemeid, issuepriorityschemeid, issueseverityschemeid, issueworkflowid, fieldvisibilityschemeid, resourcemode, componentmode, userid, projectlabelid) 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.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(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.Business.xa37334733da24461.x11613c10bb40435f(ProjectEN x4982e05b3cc913d8) at CounterSoft.Gemini.Presenter.ProjectPresenter.CreateProject(ProjectEN project) at CounterSoft.Gemini.Web.Api.ProjectsRestHandler.ProjectCreate(RequestDetails rd)

117 9/1/2010 2:19:37 PM Error Gemini Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at CounterSoft.Gemini.Web.Api.RestHandler.GetResponse(RequestDetails rd, MethodInfo method)

118 9/1/2010 2:19:37 PM Error Gemini could not insert: [CounterSoft.Gemini.Commons.Entity.ProjectEN][SQL: INSERT INTO geminiprojects (projectcode, projectname, projectdesc, projectreadonly, projectarchived, globalschemeid, issuetypeschemeid, issuepriorityschemeid, issueseverityschemeid, issueworkflowid, fieldvisibilityschemeid, resourcemode, componentmode, userid, projectlabelid) 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.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(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.Business.xa37334733da24461.x11613c10bb40435f(ProjectEN x4982e05b3cc913d8) at CounterSoft.Gemini.Presenter.ProjectPresenter.CreateProject(ProjectEN project) at CounterSoft.Gemini.Web.Api.ProjectsRestHandler.ProjectCreate(RequestDetails rd)


Could this all just be a result of the incompatible versions?


LBS_gemini-admin
· 1
LBS_gemini-admin
helpful
0
not helpful

Actually, it might be a problem with the import app and schemes (security, workflow etc...). At the moment it assumes you have the same scheme id's between the 2 instances.

Can you check that?

http://www.countersoft.com/downloads/v36/CounterSoftGeminiDataImportv36_4.exe


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I downloaded the v3.6.4 of the import utility (thank you for the link), and found the behavior and error messages to be identical to what I experienced with v3.7.2.

I then went through both instances of Gemini, and checked all of the 'schemes' which exist in the administration portion. I did find that some schemes between the instances utilized the same name, but had different sets of 'Issue Types/Priorities' etc. I renamed the schemes in the 'Source' instance, and then recreated them, identically, within the 'Target' instance.

Looking at the 'Gemini Administration' web interface, I went through every link under the 'Issue Settings' section, and verified that everything was identical, excluding the 'Schemes' which exist in the 'Target' instance, but not the 'Source' instance.

After going through all of the setup options, I attempted the import again, and I received nearly identical behavior. The 'Import Utility' still reports 'Transaction Failed'. Viewing the log from the 'Import Utility' shows that it is identical to that which was listed above (except for the program version, which now reflects the 3.6.4 version).

Viewing the log on the 'Target' gemini instance, it appears to be identical to what I have listed above as well (very long error messages which I did not check in their entirety, but the beginning and ending portions are identical).

The only difference I saw was in the output of the 'Debug Viewer'. It no longer contains references to the 'could not insert:' statements, but still logs the exception:


[2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Start Importing [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Project Prepare to Import [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Load Project data [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Checking existance of project code APP [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Start Project Creation [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Exception occurs on Project creation. Exception has been thrown by the target of an invocation. :: CounterSoft.Gemini.WebServices :: at CounterSoft.Gemini.WebServices.BaseService.ThrowResponseException(WebResponse response) [2340] at CounterSoft.Gemini.WebServices.BaseService.ProcessResponse[T](String url, Object obj, RequestType requestType) [2340] at CounterSoft.Gemini.WebServices.BaseService.GetResponse[T](String url, Object o, RequestType r) [2340] at CounterSoft.Gemini.WebServices.ProjectsService.CreateProject(ProjectEN project) [2340] at CounterSoft.Gemini.DataImport.Mapping.ProjectImporter.ImportProjects(String& selectedProjectsIDSeperatedByComma) [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: Transaction failed! Contact your Gemini Administrator. [2340] CounterSoft.Gemini.DataImport 3.6.4 Build 2630: End Importing


Question: You indicate "it assumes you have the same scheme ID's between the 2 instances." Are you talking about an internal ID # for the scheme(s), or the 'Scheme Name' which is entered through the web interface? I'm not sure how I would modify an ID #, seeing as they are not displayed anywhere within the web instance (short of running direct queries against the database, which I am hoping I won't have to do). I have, at this point, ensured the 'Scheme Names' are identical between the instances.

If I can provide you with any screenshots, or additional info which could assist you, please let me know.

Thank you.


LBS_gemini-admin
· 1
LBS_gemini-admin
helpful
0
not helpful

Unfortunately, it is the id that needs to match. You can see the ids in the browser's address bar when editing a scheme (eg. http://gemini/admin/IssueTypeScheme.aspx?SchemeID=4)


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Ok, so just to be clear.

In my Source instance, if I have a project assigned to 'Issue Type Scheme ID #2', in order to import it into my Target instance, the Target must contain an 'Issue Type Scheme' with ID# = 2, and the schemes between both instances must be identical, regarding which 'Issue Types' exist?

Is there a need to ensure that the 'Issue Types' associated with a scheme appear in the same order, or anything like that? This sounds like it will be a lot of work to make the changes and ensure everything matches between both systems, so I'd rather make sure I'm taking the appropriate actions before investing a significant amount of time into this.

As an aside, let's assume I find that I need to move a project to an entirely different Scheme (in order to get the Scheme ID#'s to match up), are there any implications or potential pitfalls of re-assigning a project to a different scheme that I should be aware of? Each of the projects I'm attempting to migrate currently contain a large quantity issues.

Thank you for the feedback.


LBS_gemini-admin
· 1
LBS_gemini-admin
helpful
0
not helpful

The types will need to exist but the order is not taken into account. Actually the types do not even need to be included in the scheme....

No pitfall if the scheme has the same types.



Saar Cohen
· 5000
Saar Cohen