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.




Input String not in correct format .. do not know which field is causing the issue

migration

I am getting the following error with the attached file, I am not sure why I am getting this error and it does not say which field is causing the error.

00000041 7.78531790 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: fetching Issue(s) of Soucre Project HP - Purchasing Disbursements --> Destination project HP - Purchasing Disbursements
00000042 7.78536034 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: prepare Issue(s) 00000043 9.17630291 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Exception occurs on Issue creation. Input string was not in a correct format. :: mscorlib :: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
00000044 9.17630291 [5012] at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
00000045 9.17630291 [5012] at CounterSoft.Gemini.DataImport.BLL.Excel.ExcelIssueExporter_vFlat.Prepare(Object key)
00000046 9.17630291 [5012] at CounterSoft.Gemini.DataImport.Mapping.MergeExisting.ExistingIssuesImporter.ImportIssues(Hashtable& projectLUTs, Hashtable& versionLUT, Hashtable& componentLUT, Hashtable& customFieldLUT) 00000047 9.17633247 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Issues Rollbacked from HP - Purchasing Disbursements existing Project
00000048 9.17639542 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start update Sub Issues
00000049 9.17942905 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: End update Sub Issues
00000050 9.17944717 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start update Issues Links
00000051 9.18147659 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: End update Issues Links
00000052 9.18149567 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start update comments with IssueLink qualifier
00000053 9.18263531 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: End update comments with IssueLink qualifier 00000054 9.18265343 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start update Descriptions with IssueLink qualifier
00000055 9.18367481 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: End update Descriptions with IssueLink qualifier 00000056 9.18541813 [5012] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Transaction failed! Contact your Gemini Administrator.

dganeshm
· 1
dganeshm
Replies (1)
helpful
0
not helpful
ANSWER

Your estimated hours field contains decimals, which it can't do. Must be a whole number.


Saar Cohen
· 5000
Saar Cohen