Namespaces missing for recently created resources

[GoogleCodeExporter]

What steps will reproduce the problem?
In the GBIF Index, table resource access points (= service in the new GBRDS), 
it looks if the information on which schema is used by this service is missing 
for all services added lately. If, for example, you look at the services for 
the Botanische Staatssammlung, you'll see the "namespace" column is filled for 
all entries created in 2007, but empty for the entries created in 2010 - see 
attachements.

What is the expected output? What do you see instead?
Schema and protocol should be listed (ABCD & BioCASe)

What version of the product are you using? On what operating system?
GBIF Index December 2010

Query for producing the attached list:
select uuid, ap.data_provider_id, url, ap.created, namespace
from resource_access_point ap
LEFT JOIN GBIF.namespace_mapping schema_ns_id on (ap.id = 
schema_ns_id.resource_access_point_id and schema_ns_id.priority = 1)
LEFT JOIN GBIF.property_store_namespace schema_ns on 
(schema_ns_id.property_store_namespace_id = schema_ns.id)
left join data_resource r on data_resource_id = r.id
where ap.deleted is null and r.data_provider_id = 158 and data_resource_id <> 0
order by ap.created

Original issue reported on code.google.com by joerg.ho...@gmail.com on 13 Dec 2010 at 11:10

Attachments:

• namespaces.html

[GoogleCodeExporter]

The root of this problem is the HIT, which is responsible for populating the 
namespace_mapping table. 

A fix has been applied to the HIT, and following this fix that will be included 
in Version 1.15-RC1, the schema and protocol information will now be updated. 
This information should appear in the next version of the GBIF Index come the 
next rollover. 

Original comment by kyle.br...@gmail.com on 14 Dec 2010 at 3:51

• Changed state: Started