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.




Failed to import Mantis database to Gemini

migration

The following error ocurred when I tryed to import a Mantis MySQL database to Gemini:

00000075 518.59051514 [5736] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporter_v114.Prepare(Object key)
00000076 518.59051514 [5736] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT)

The portuguese exception message (Referência de objeto não definida para uma instância de um objeto.) comes from the localization of the .NET Framework and the meaning is the same as "null reference".

Could someone help me?
ricmmx
· 1 		ricmmx
Monday, July 20, 2009, 4:16:47 PM
Replies (6)
helpful
0
not helpful

Please send your sample source file to support at countersoft dot com.
Bikram
· 1 		Bikram
Tuesday, July 21, 2009, 10:17:35 AM
helpful
0
not helpful

Unfortunetely my database contains sensitive information, so I cannot send it to you.

But I could see that the import tool is trying to access MySQL database with a SQLServer connection object (some "Mantis114" object) causing a null reference exception.
ricmmx
· 1 		ricmmx
Friday, July 31, 2009, 2:21:23 PM
helpful
0
not helpful

Please provide us the DebugView output. http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx

Email the output file to support at countersoft dot com
Bikram
· 1 		Bikram
Monday, August 10, 2009, 10:35:18 AM
helpful
0
not helpful

LOG:

Gemini Data Import Log v1.1.0 Build 2374 10/08/2009 09:11:30

** Import Status **

Custom Field(s)

Source project: CMA Series 4 - v1.4 --> Destination project: CMA Series 4 - v1.4

Origem do Defeito: Success

Source project: CME Sinal Fix - 657 --> Destination project: CME Sinal Fix - 657

Source project: Contribuidor de Notícias - 775 --> Destination project: Contribuidor de Notícias - 775

Source project: AlgoServer --> Destination project: AlgoServer

Source project: Grafico Web --> Destination project: Grafico Web

Source project: Portfólio Serfiex --> Destination project: Portfólio Serfiex

Source project: CMA Algoritmos --> Destination project: CMA Algoritmos

Source project: Template --> Destination project: Template

Issue(s)

Source project: CMA Series 4 - v1.4 --> Destination project: CMA Series 4 - v1.4 : 0 Issues imported

Final Status

Success: 1 Project(s) mapped and 0 issue(s) imported successfully

Source project: CMA Series 4 - v1.4 --> Destination project: CMA Series 4 - v1.4

Failure: 7 Project(s) mapped and 7 issue(s) not imported

Source project: CME Sinal Fix - 657 --> Destination project: CME Sinal Fix - 657 Source project: Contribuidor de Notícias - 775 --> Destination project: Contribuidor de Notícias - 775 Source project: AlgoServer --> Destination project: AlgoServer Source project: Grafico Web --> Destination project: Grafico Web Source project: Portfólio Serfiex --> Destination project: Portfólio Serfiex Source project: CMA Algoritmos --> Destination project: CMA Algoritmos Source project: Template --> Destination project: Template

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.

DEBUG:

[2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Started [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start DoLogin [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Checking Model.Authenticated [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Starting logon process [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Calling ServiceHelper.AuthorisationServicesLogIn [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: DoLogin End [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start Page Loading [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End Page Loading [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start Main Tab Functionality [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End Main Tab Functionality [2724] In DLLCanUnloadNow [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start Connecting to server and fetch project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End fetching [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start Importing [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project CMA Series 4 - v1.4 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: get all Custom Field defs [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Check exist Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Cheking end [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Set number of rows [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Mapping with project of custom field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: mapping done [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Go to next custom fields [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project CME Sinal Fix - 657 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project Contribuidor de Notícias - 775 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project AlgoServer [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project Grafico Web [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project Portfólio Serfiex [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project CMA Algoritmos [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Custom Field(s) of Project Template [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Custom Field [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project CMA Series 4 - v1.4 --> Destination project CMA Series 4 - v1.4 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue from source [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project CME Sinal Fix - 657 --> Destination project CME Sinal Fix - 657 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from CME Sinal Fix - 657 existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project Contribuidor de Notícias - 775 --> Destination project Contribuidor de Notícias - 775 [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from Contribuidor de Notícias - 775 existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project AlgoServer --> Destination project AlgoServer [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from AlgoServer existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project Grafico Web --> Destination project Grafico Web [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from Grafico Web existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project Portfólio Serfiex --> Destination project Portfólio Serfiex [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from Portfólio Serfiex existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project CMA Algoritmos --> Destination project CMA Algoritmos [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporterv114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from CMA Algoritmos existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: fetching Issue(s) of Soucre Project Template --> Destination project Template [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: prepare Issue(s) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Exception occurs on Issue creation. Referência de objeto não definida para uma instância de um objeto. :: CounterSoft.Gemini.DataImport.BLL :: em CounterSoft.Gemini.DataImport.BLL.Mantis.MySQL.MNTIssuesExporter_v114.Prepare(Object key) [2264] em CounterSoft.Gemini.DataImport.Mapping.ExistingIssuesImporter.ImportIssues(Hashtable& ProjectLUT, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Issues Rollbacked from Template existing Project [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start update Sub Issues [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End update Sub Issues [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start update Issues Links [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End update Issues Links [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start update comments with IssueLink qualifier [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End update comments with IssueLink qualifier [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Start update Descriptions with IssueLink qualifier [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End update Descriptions with IssueLink qualifier [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: Transaction failed! Contact your Gemini Administrator. [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: 1 Project(s) mapped, 0 issue(s) imported successfully. [2264] 7 Project(s) mapped, 7 issue(s) not imported due to bad data [2264] CounterSoft.Gemini.DataImport 1.1.0 Build 2374: End Importing
ricmmx
· 1 		ricmmx
Monday, August 10, 2009, 2:12:43 PM
helpful
0
not helpful

Hello. Unfortunately we were unable to positively identify the issue thus far. We need some sample data to troubleshoot further. Is is possible for you to provide a sample data file with just a handful of issues?
Bikram
· 1 		Bikram
Monday, August 10, 2009, 4:17:17 PM
helpful
0
not helpful

We giving up to use Gemini for now. Thanks
ricmmx
· 1 		ricmmx
Friday, August 14, 2009, 7:41:49 PM