Taxon Explorer Check List report

[GoogleCodeExporter]

When I try to generat the Check List report I get the following error message:

An error occurred whilst running report 'Checklist report: Animalia '
Das Objekt des Typs "System.DBNull" kann nicht in Typ "System.String" 
umgewandelt werden. 
--------------------------------------------------------------------------------
bei BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) 
bei BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei 
BioLink.Data.TaxaService.<>c__DisplayClass34.b__31(SqlDataReader reader) bei 
BioLink.Data.BioLinkService.<>c__DisplayClass6.b__4(SqlConnection con, 
SqlCommand cmd) bei BioLink.Data.BioLinkService.Command(ServiceCommandAction 
action) bei BioLink.Data.BioLinkService.StoredProcReaderForEach(String proc, 
ServiceReaderAction action, SqlParameter[] params) bei 
BioLink.Data.TaxaService.GetChecklistData(Int32 taxonID, Int32 level, Boolean 
allChildren, Boolean userDefinedOrder, Boolean verifiedOnly, List`1 
selectedRanks) bei BioLink.Data.TaxaService.ChecklistReport(Int32 taxonID, 
String criteriaDisplayText, ChecklistReportExtent extent, Boolean 
availableNames, Boolean literatureNames, Nullable`1 depth, Boolean 
userDefinedOrder, Boolean verifiedOnly, List`1 selectedRanks) bei 
BioLink.Client.Taxa.ChecklistReport.ExtractReportData(IProgressObserver 
progress) bei BioLink.Client.Extensibility.ReportResults.b__0() 

Original issue reported on code.google.com by tzunu...@googlemail.com on 28 Jun 2011 at 3:58

[GoogleCodeExporter]

Original comment by david.ba...@gmail.com on 28 Jun 2011 at 11:18

• Changed state: Accepted

[GoogleCodeExporter]

This issue was closed by revision r611.

Original comment by david.ba...@synergi.com.au on 28 Jun 2011 at 11:19

• Changed state: Fixed

[GoogleCodeExporter]

Hi Thomas,

I was unable to reproduce your bug exactly (I believe it only happens for 
certain data), but based on the stack information that you provided I was able 
to make an educated guess as to where the problem lies. I believe I have fixed 
the issue, and it will available for retest in the next build.

Thanks again for your time, it is much appreciated.

Cheers, David.

Original comment by david.ba...@gmail.com on 28 Jun 2011 at 11:30

[GoogleCodeExporter]

Original comment by david.ba...@gmail.com on 28 Jun 2011 at 11:38

[GoogleCodeExporter]

David,

I have just played around and checked the Check List report. The error just 
appears in Taxa where I have placed an unranked valid taxon at species or 
subspecies level. 

Original comment by tzunu...@googlemail.com on 29 Jun 2011 at 7:41

[GoogleCodeExporter]

Original comment by david.ba...@gmail.com on 30 Jun 2011 at 1:03

• Changed state: Started

[GoogleCodeExporter]

Retested with unranked valid, incertae sedis and species inquirenda elements.

Original comment by david.ba...@gmail.com on 30 Jun 2011 at 1:23

• Changed state: Fixed