Curator-Tool. Bug in dataview Get Site
I can not open the Site dataview
, the Curator-Tool sends this error:
Here is the full text of the error.
here was an unexpected error retrieving data for get_site.\
\
Full error message:\
PreparedStatementCallback; bad SQL grammar [SELECT
s.site_id,
s.site_short_name,
s.site_long_name,
s.provider_identifier,
s.organization_abbrev,
s.is_internal,
s.is_distribution_site,
s.type_code,
s.fao_institute_number,
s.note,
s.created_date,
s.created_by,
s.modified_date,
s.modified_by,
s.owned_date,
s.owned_by
FROM
site AS s
INNER JOIN (
SELECT site_id FROM site
WHERE site_id IN (?)
OR ('' = '-1' AND '' = '-1' AND '' = '-1' AND '' = '-1')
UNION SELECT site_id FROM cooperator
WHERE cooperator_id IN (?)
UNION SELECT site_id FROM cooperator c
JOIN accession a ON a.owned_by = c.cooperator_id
WHERE a.accession_id IN (?)
UNION SELECT site_id FROM cooperator c
JOIN inventory i ON i.owned_by = c.cooperator_id
WHERE i.inventory_id IN (?)
) list ON list.site_id = s.site_id
]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Ambiguous column name 'site_id'.