Issue 11483
Related dataset with uuid='null' created during processing of occurrence_datasets_usage
11483
Reporter: trobertson
Type: Bug
Summary: Related dataset with uuid='null' created during processing of occurrence_datasets_usage
Priority: Critical
Resolution: WontFix
Status: Closed
Created: 2012-06-25 15:25:17.147
Updated: 2013-12-17 15:23:05.898
Resolved: 2012-10-16 14:49:17.992
Description: The workflow to populate occurrence metrics was run, and it broke the web services:
http://jawa.gbif.org:8080/portal-web/species/1
http://jawa.gbif.org:8080/checklistbank-ws/name_usage/1/datasets
Both throw exceptions]]>
Author: mdoering@gbif.org
Comment: Firstly I will add catching of exceptions thrown by the client to the portal action. Not sure how to best surface this apart from the logs
Created: 2012-06-25 15:34:59.629
Updated: 2012-06-25 15:34:59.629
Author: mdoering@gbif.org
Created: 2012-06-25 15:41:20.444
Updated: 2012-06-25 15:41:20.444
The occurrence_datasets_usage table contains records with verbatim 'null' strings as gbif_registry_uuid.
Running the animal query shows this.
On jawa 308.602 records with 'null' have been removed from the table.
Making this a rollover processing issue now.
{noformat}
clb=# SELECT gbif_registry_uuid FROM occurrence_datasets_usage WHERE nub_usage_fk = 1 ORDER BY gbif_registry_uuid;
gbif_registry_uuid
--------------------------------------
09baff40-d4a3-11dc-8719-b8a03c50a862
0dd76500-c066-11dd-a311-b8a03c50a862
1084c169-c39a-4749-94aa-32159777d828
14208c55-2f2d-4195-8de5-1b6101964d6d
15b04450-0c60-11dd-84cd-b8a03c50a862
34e892b0-d9c7-11de-b793-b8a03c50a862
358fbd61-739f-4102-afc9-9d468f571e4d
4220d19f-f919-4f36-8251-41fe1a36b1da
427a6290-0c65-11dd-84d2-b8a03c50a862
44bcde48-ac71-46f2-bf73-24fc3c008b6c
4bfac3ea-8763-4f4b-a71a-76a6f5f243d3
50c9509d-22c7-4a22-a47d-8c48425ef4a7
56aa0680-0c60-11dd-84cd-b8a03c50a862
6197c830-d9c7-11de-b793-b8a03c50a862
64be02e0-0c64-11dd-84d1-b8a03c50a862
72d94851-55db-4604-ae8f-78ffc16ef4cf
75107f2a-8d3d-4d1b-b4c4-eb74b961de20
911d5a2c-7959-425d-a066-ff0816af4f58
92d4b180-a103-11de-88ae-b8a03c50a862
9f17221a-195b-4005-8773-683fcdf559e8
b24d3bd0-e6d9-11dc-8b77-b8a03c50a862
b70121ef-b7ea-4316-a05b-abdf30f5ca09
ce58b7bb-fed6-46b9-9424-135499c7afdf
db4fb290-0c60-11dd-84cd-b8a03c50a862
e6396a80-488e-11db-a1c2-b8a03c50a862
fbe1f070-b6e4-11dd-81f6-b8a03c50a862
null
(27 rows)
{noformat}