Topcat browsing fails on ICAT 4.3.2

[milan.prica]

Hello,

We (Elettra) are experiencing problems while browsing the ICAT 4.3.2 with TopCAT-1.11.0.
The "Browse All Data" stops at the second level: Facility expands to Instrument(s) but
Instruments to don expand any further despite having content.

server.log reports no errors, while the output of the topcat.log is:

(select Browse all data tab)

2014-02-07 09:21:07,434 [http-thread-pool-8181(2)] INFO  UserManager - isSessionValid: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra)
2014-02-07 09:21:07,446 [http-thread-pool-8181(2)] INFO  ICATInterfacev43 - ICATInterfacev43: serverURL (https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl), serverName (elettra)
2014-02-07 09:21:07,446 [http-thread-pool-8181(2)] TRACE ICATInterfacev43 - ICATInterfacev43: Using URL:https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl
2014-02-07 09:21:07,864 [http-thread-pool-8181(2)] INFO  ICATInterfacev43 - isSessionValid: sessionId (8a62f040-d6a3-4f0b-abc5-31e45c5c36c4)
2014-02-07 09:21:07,882 [http-thread-pool-8181(2)] TRACE ICATInterfacev43 - isSessionValid: true

(expand Facility, Instrument)

2014-02-07 09:21:14,858 [http-thread-pool-8181(3)] INFO  UtilityManager - getFacilityCyclesWithInstrument: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra), instrument (Beamline 1)
2014-02-07 09:21:14,871 [http-thread-pool-8181(3)] INFO  ICATInterfacev43 - ICATInterfacev43: serverURL (https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl), serverName (elettra)
2014-02-07 09:21:14,872 [http-thread-pool-8181(3)] TRACE ICATInterfacev43 - ICATInterfacev43: Using URL:https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl
2014-02-07 09:21:15,392 [http-thread-pool-8181(3)] INFO  ICATInterfacev43 - listFacilityCyclesForInstrument: sessionId (8a62f040-d6a3-4f0b-abc5-31e45c5c36c4), instrument (Beamline 1)
2014-02-07 09:21:15,434 [http-thread-pool-8181(3)] INFO  UtilityManager - getAllInvestigationsInServerAndInstrument: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra), instrumentName (Beamline 1)
2014-02-07 09:21:15,435 [http-thread-pool-8181(3)] INFO  UserManager - getValidUserSessionByTopcatSessionAndServerName: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra)
2014-02-07 09:21:15,447 [http-thread-pool-8181(3)] INFO  ICATInterfacev43 - ICATInterfacev43: serverURL (https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl), serverName (elettra)
2014-02-07 09:21:15,447 [http-thread-pool-8181(3)] TRACE ICATInterfacev43 - ICATInterfacev43: Using URL:https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl
2014-02-07 09:21:15,853 [http-thread-pool-8181(3)] INFO  ICATInterfacev43 - searchByAdvancedPagination: sessionId (8a62f040-d6a3-4f0b-abc5-31e45c5c36c4, details, start (0, end (200)
2014-02-07 09:21:15,854 [http-thread-pool-8181(3)] INFO  ICATInterfacev43 - advanced query:  DISTINCT Investigation INCLUDE Facility <-> InvestigationInstrument <-> Instrument[(name IN ('Beamline 1')) OR (fullName IN ('Beamline 1'))]

Both ICAT and TopCAT are deployed in the same Glassfish3.1.2.
Any ideas? Thanks.

[Christophe CLEVA]

Hello,

During our tests with ICAT 4.3.1 and Topcat 1.11 at ESRF, we noticed
that Investigations appear only in the 'Browse All Data' tab in Topcat
if there is a related FacilityCycle, as shown in the screenshot.
Investigations that are not somehow related to a FacilityCycle do not
appear.

I guess the matching is done by date as the relationship between
Investigations and FacilityCycles was removed from the database by ICAT
4.3.0.

The smoking gun is this line in the log:

2014-02-07 09:21:15,392 [http-thread-pool-8181(3)] INFO ICATInterfacev43
- listFacilityCyclesForInstrument: sessionId
(8a62f040-d6a3-4f0b-abc5-31e45c5c36c4), instrument (Beamline 1)

Hope this helps.
Regards,
Christophe

> --
> You received this message because you are subscribed to the Google
> Groups "icatproject-support" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to icatproject-sup...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

[Steve Fisher]

Wayne, who looks after TopCAT, is on leave at the moment. There should be no requirement to use facility cycles. I will ask him to look into this when he is back on the 18th.

Steve

--

[wayne...@stfc.ac.uk]

Hi Milan,

Topcat expects a relationship between an instrument and the investigation. Was one defined?

Also, can you check if the user has the proper permission to see the investigations in ICAT.


Christophe,

Investigations should not require a facility cycle to be visible in browse all.

TopCat does first look for FacilityCycles in order to build the tree structure as per the log:

2014-02-07 09:21:14,858 [http-thread-pool-8181(3)] INFO UtilityManager - getFacilityCyclesWithInstrument: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra), instrument (Beamline 1)

However, if no facility cycle is found, it then looks for investigations for the instrument as per the log:

2014-02-07 09:21:15,434 [http-thread-pool-8181(3)] INFO UtilityManager - getAllInvestigationsInServerAndInstrument: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra), instrumentName (Beamline 1)
2014-02-07 09:21:15,435 [http-thread-pool-8181(3)] INFO UserManager - getValidUserSessionByTopcatSessionAndServerName: topcatSessionId (69f19bed-76b0-46a5-a79d-6d8709e02195), facilityName (elettra)
2014-02-07 09:21:15,447 [http-thread-pool-8181(3)] INFO ICATInterfacev43 - ICATInterfacev43: serverURL (https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl), serverName (elettra)
2014-02-07 09:21:15,447 [http-thread-pool-8181(3)] TRACE ICATInterfacev43 - ICATInterfacev43: Using URL:https://icat-elettra.grid.elettra.trieste.it:8181/ICATService/ICAT?wsdl
2014-02-07 09:21:15,853 [http-thread-pool-8181(3)] INFO ICATInterfacev43 - searchByAdvancedPagination: sessionId (8a62f040-d6a3-4f0b-abc5-31e45c5c36c4, details, start (0, end (200)
2014-02-07 09:21:15,854 [http-thread-pool-8181(3)] INFO ICATInterfacev43 - advanced query: DISTINCT Investigation INCLUDE Facility <-> InvestigationInstrument <-> Instrument[(name IN ('Beamline 1')) OR (fullName IN ('Beamline 1'))]

In Milan's case it's not returning any results.

Wayne

[Christophe CLEVA]

Hello Wayne,

Thanks a lot for the detailed explanation. One of the first
Investigation we registered was associated with a FacilityCycle so we
only noticed that the subsequent investigations needed the association
too. Nice to know we could remove them all.

Thanks again.
Regards,
Christophe