Ah, right. Sorry, my fault. I mixed it up with the BioCASe provider Software, which constructs the statement. If something is misconfigured, you can tell from the SQL query...

No idea then :/ Jörg

________________________________ Von: Jens Rathsman [mailto:Jens.Rathsman@nrm.se] Gesendet: Donnerstag, 26. August 2010 10:48 An: Holetschek, Jörg Cc: ipt@lists.gbif.org Betreff: RE: Mapping/publishing problem?

Did you mean "show full processlist" on the MySql-server?

I tried that and the only SQL statement I could catch was the query entered in the DataSource-settings in IPT:

select * from dwctable

The query can be run manually.

/Jens

From: ipt-bounces@lists.gbif.org [mailto:ipt-bounces@lists.gbif.org] On Behalf Of "Holetschek, Jörg" Sent: den 25 augusti 2010 15:50 To: Jens Rathsman Cc: ipt@lists.gbif.org Subject: Re: [IPT] Mapping/publishing problem?

Jens,

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...

Jörg

________________________________ Von: ipt-bounces@lists.gbif.org [mailto:ipt-bounces@lists.gbif.org] Im Auftrag von Jens Rathsman Gesendet: Mittwoch, 25. August 2010 14:09 An: ipt@lists.gbif.org Betreff: [IPT] Mapping/publishing problem? Dear GBIF helpdesk,

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:

VerbatimCollectingDate --- EarliestDateCollected --- StartTimeOfDay --- YearSampled --- MonthOfYear --- DayOfMonth --- Collector ---

For example catalogNumber 38922 ( puiblished at: http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417...) 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 resource there are no problems shown, and I get no clues from the tomcat log file (catalina.out).

This is the data from the data source: catalogNumber

collector

earliestDateCollected

verbatimCollectingDate

startDayOfYear

endDayOfYear

eventTime

yearSampled

monthOfYear

dayOfYear

38922

Åhlander, E et al.

1990-04-04

4 and 12 Apr 1990

94

102

10:00:00

1990

4

4

What could be causing this problem?

Best regards,

--------------------------------- Jens Rathsman, System developper GBIF Sweden - http://www.gbif.sehttp://www.gbif.se/ mailto:jens.rathsman@nrm.se tel: +46 8 5195 5116 Swedish Museum of Natural History - http://www.nrm.sehttp://www.nrm.se/ Box 50007 SE-104 05 Stockholm Sweden

Dear Tim,

It would be interesting to be a tester of the new RC4 release. Where can it be found?

/Jens

From: Tim Robertson (GBIF) [mailto:trobertson@gbif.org] Sent: den 26 augusti 2010 11:25 To: Jens Rathsman Cc: ipt@lists.gbif.org Subject: Re: [IPT] Mapping/publishing problem?

Dear Jens,

I am sorry you are seeing these issues. Would you be willing to act as a tester for the RC4 release? My hunch is that you are observing a bug that has been fixed - there were some issues that arose with RC3 related to mapping of DwC fields.

If you are willing, it would require you to install a new IPT and attempt to map your data and determine if this solves your issues.

Thanks, Tim

On Aug 25, 2010, at 2:08 PM, Jens Rathsman wrote:

Dear GBIF helpdesk,

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:

VerbatimCollectingDate --- EarliestDateCollected --- StartTimeOfDay --- YearSampled --- MonthOfYear --- DayOfMonth --- Collector ---

For example catalogNumber 38922 ( puiblished at: http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417...) 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 resource there are no problems shown, and I get no clues from the tomcat log file (catalina.out).

This is the data from the data source: catalogNumber

collector

earliestDateCollected

verbatimCollectingDate

startDayOfYear

endDayOfYear

eventTime

yearSampled

monthOfYear

dayOfYear

38922

Åhlander, E et al.

1990-04-04

4 and 12 Apr 1990

94

102

10:00:00

1990

4

4

What could be causing this problem?

Best regards,

--------------------------------- Jens Rathsman, System developper GBIF Sweden - http://www.gbif.sehttp://www.gbif.se/ mailto:jens.rathsman@nrm.se tel: +46 8 5195 5116 Swedish Museum of Natural History - http://www.nrm.sehttp://www.nrm.se/ Box 50007 SE-104 05 Stockholm Sweden

_______________________________________________ IPT mailing list IPT@lists.gbif.orgmailto:IPT@lists.gbif.org http://lists.gbif.org/mailman/listinfo/ipt