IPT _ JABOT - problems when consuming from a database

[ClaraBaringoFonseca]

Hi Mickhail, good morning,

The IPT (https://ipt.jbrj.gov.br/jabot/
) is connected to a database. Recently, we added a few new datasets and established the database connection successfully—everything appears to be working correctly.

However, when we try to publish, the records are not being consumed. Could you please take a look? Thanks

This is the message we are receiving:

Start writing data file for Darwin Core Occurrence
No lines were skipped due to errors for mapping Darwin Core Occurrence in source occurrence
No lines were skipped due to errors for mapping Darwin Core Occurrence in source occurrence
No lines with fewer columns than mapped for mapping Darwin Core Occurrence in source occurrence
All lines match the filter criteria for mapping Darwin Core Occurrence in source occurrence
Data file written for Darwin Core Occurrence with 494 records and 52 columns
Start writing data file for Darwin Core Identification History
No lines were skipped due to errors for mapping Darwin Core Identification History in source historic
No lines were skipped due to errors for mapping Darwin Core Identification History in source historic
No lines with fewer columns than mapped for mapping Darwin Core Identification History in source historic
All lines match the filter criteria for mapping Darwin Core Identification History in source historic
Data file written for Darwin Core Identification History with 0 records and 13 columns
Start writing data file for Simple Multimedia
No lines were skipped due to errors for mapping Simple Multimedia in source simple_images
No lines were skipped due to errors for mapping Simple Multimedia in source simple_images
No lines with fewer columns than mapped for mapping Simple Multimedia in source simple_images
All lines match the filter criteria for mapping Simple Multimedia in source simple_images
Data file written for Simple Multimedia with 0 records and 8 columns
All data files completed
? Validating EML file
✓ Validated EML file
EML file added
meta.xml archive descriptor written
Validating the core file: occurrence.txt. Depending on the number of records, this can take a while.
? Validating the core basisOfRecord is always present and its value matches the Darwin Core Type Vocabulary.
? Validating the core ID field occurrenceID is always present and unique. Note: the core ID field is required to link core records and extension records together.
No lines are missing occurrenceID
No lines have duplicate occurrenceID
✓ Validated each line has a occurrenceID, and each occurrenceID is unique
No lines are missing a basisOfRecord
All lines have basisOfRecord that matches the Darwin Core Type Vocabulary
No lines have ambiguous basisOfRecord 'occurrence'.
✓ Validated each line has a basisOfRecord, and each basisOfRecord matches the Darwin Core Type Vocabulary
Validating the extension file: multimedia.txt. Depending on the number of records, this can take a while.
? Validating the ID field occurrenceID is always present in extension data file.
✓ Validated each line in extension has an ID occurrenceID
No lines in extension are missing an ID occurrenceID
Validating the extension file: identification.txt. Depending on the number of records, this can take a while.
? Validating the ID field occurrenceID is always present in extension data file.
✓ Validated each line in extension has an ID occurrenceID
No lines in extension are missing an ID occurrenceID
✓ Archive validated
Archive has been compressed
Archive version #1.0 generated successfully!

[mike-podolskiy90]

Hi Clara!

I've checked this one https://ipt.jbrj.gov.br/jabot/manage/resource.do?r=jar
Source preview does not show any data, only column names.

[ClaraBaringoFonseca]

Hi Mike!
That's right. However it shows that is public (with the metadata) but I could not see in the Public datasets.

[mike-podolskiy90]

What I meant, if you go to any of the source pages and do Options -> Preview, IPT displays:

(0 rows, only columns, so the query apparently worked but returned 0 rows).

Please, make sure this query select * from publicacao.vm_dwci_rb returns data (table isn't empty).

[ClaraBaringoFonseca]

Hi Mike,
I got it. I believe it will be fulfilled next month in the next update (will check with them). However, even though it’s empty, it is marked as “published” and shows as public. Why doesn’t it appear on the public interface home page with 0 records?

[mike-podolskiy90]

All resources that have been published, regardless of record count, are displayed on the Home and Manage pages. Some resources have not yet been published (for example, https://ipt.jbrj.gov.br/jabot/manage/resource?r=hcdal
; refer to the “Last publication date” column in the table).

[ClaraBaringoFonseca]

Not all.
Look at this examples:
https://ipt.jbrj.gov.br/jabot/manage/resource?r=uesc
https://ipt.jbrj.gov.br/jabot/manage/resource?r=palm

They say archive generated but not published.

[mike-podolskiy90]

I see. Even after publishing, those resources do not appear as published.