<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=SV link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Did you mean “show full processlist” on the MySql-server?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>I tried that and the only SQL statement I could catch was the query entered in the DataSource-settings in IPT:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>select * from dwctable<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>The query can be run manually.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>/Jens<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV'> ipt-bounces@lists.gbif.org [mailto:ipt-bounces@lists.gbif.org] <b>On Behalf Of </b>"Holetschek, Jörg"<br><b>Sent:</b> den 25 augusti 2010 15:50<br><b>To:</b> Jens Rathsman<br><b>Cc:</b> ipt@lists.gbif.org<br><b>Subject:</b> Re: [IPT] Mapping/publishing problem?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue;mso-fareast-language:SV'>Jens,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue;mso-fareast-language:SV'>have you tried to run the SQL statements issued by the IPT manually? Could could use "show full processlist" during the indexing process to catch one of them...</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue;mso-fareast-language:SV'>Jörg</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span lang=DE style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV'>Von:</span></b><span lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:SV'> ipt-bounces@lists.gbif.org [mailto:ipt-bounces@lists.gbif.org] <b>Im Auftrag von </b>Jens Rathsman<br><b>Gesendet:</b> Mittwoch, 25. August 2010 14:09<br><b>An:</b> ipt@lists.gbif.org<br><b>Betreff:</b> [IPT] Mapping/publishing problem?</span><span lang=DE style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:SV'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Dear GBIF helpdesk,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I am publishing some datasets on an IPT server (1.0-RC3-SNAPSHOT) for the Swedish GBIF node. There are some problems with the mapping or publishing the following fields:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>VerbatimCollectingDate --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>EarliestDateCollected --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>StartTimeOfDay --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>YearSampled --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>MonthOfYear --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>DayOfMonth --- <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Collector ---<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>For example catalogNumber 38922 ( puiblished at: <a href="http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417edf5&resourceId=79">http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417edf5&resourceId=79</a>) <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>has values for all of the above fields in the datasource (a MySql database) but none of them are presenteded by IPT. When I click “Annotations” for the <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>resource there are no problems shown, and I get no clues from the tomcat log file (catalina.out).<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>This is the data from the data source: <o:p></o:p></span></p><table class=MsoNormalTable border=0 cellpadding=0 style='margin-left:-2.25pt'><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>catalogNumber<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>collector<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>earliestDateCollected<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>verbatimCollectingDate<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>startDayOfYear<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>endDayOfYear<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>eventTime<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>yearSampled<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>monthOfYear<o:p></o:p></b></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><b>dayOfYear<o:p></o:p></b></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>38922<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>Åhlander, E et al.<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>1990-04-04<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>4 and 12 Apr 1990<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>94<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>102<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>10:00:00<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>1990<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>4<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal>4<o:p></o:p></p></td></tr></table><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>What could be causing this problem?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>---------------------------------<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Jens Rathsman, System developper<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>GBIF Sweden - </span><a href="http://www.gbif.se/"><span lang=EN-US>http://www.gbif.se</span></a><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><a href="mailto:jens.rathsman@nrm.se">mailto:jens.rathsman@nrm.se</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>tel: +46 8 5195 5116<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Swedish Museum of Natural History - </span><a href="http://www.nrm.se/"><span lang=EN-US>http://www.nrm.se</span></a><span lang=EN-US> Box 50007<o:p></o:p></span></p><p class=MsoNormal>SE-104 05 Stockholm<o:p></o:p></p><p class=MsoNormal>Sweden<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>