Esri / geoportal-server

Geoportal Server is a standards-based, open source product that enables discovery and use of geospatial resources including data and services.
https://gptogc.esri.com/geoportal
Apache License 2.0
244 stars 149 forks source link

Unable to Approve CSW record without first restarting tomcat #246

Open slead opened 7 years ago

slead commented 7 years ago

At a client site, we are running:

We can successfully create a metadata record, and its Status is set by default as Posted. We can Set As Approved on this record, and it's successfully approved.

The problem occurs when we try to Add a CSW link (eg http://www.ga.gov.au/geonetwork/srv/en/csw?request=GetCapabilities&service=CSW - the type is GeoNetwork CSW 2.0.2 APISO)

This is correctly set as Posted, however when we try to Set As Approved (or any other action), the tomcat GPT logs show that the connection is opened:

28-Sep-2016 13:53:01 com.esri.gpt.framework.sql.DatabaseReference openConnection
FINE: Connection opened for gpt, jndiName: jdbc/gpt, productName: Oracle, driver: Oracle JDBC driver 11.1.0.7.0-Production

However, the application then freezes and the record is not set as Approved, and the GeoPortal Admin page is stuck in a loading state. The GPT logs now show:

28-Sep-2016 13:53:51 org.apache.catalina.session.ManagerBase processExpires
FINE: Start expire sessions StandardManager at 1475034831640 sessioncount 1

28-Sep-2016 13:53:51 org.apache.catalina.session.ManagerBase processExpires
FINE: End expire sessions StandardManager processingTime 0 expired sessions: 0

After restarting tomcat (without making any other changes), the status of the CSW record is correctly set as Approved. Further changes to the status of this record proceed without any errors.

If we create a new CSW connection, the problem recurs (ie, GeoPortal page freezes, the status is not changed, and we need to restart tomcat).

Can you please advise why this might be occurring, and any possible solutions? We can't see any other error messages in the tomcat logs (but perhaps we are missing something?)

Thanks, Steve