Error importing between Gemini Instances
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 |
|
Wednesday, September 1, 2010, 7:44:36 PM |