How to find RTC repository version by running SQL commands on Jazz or JTS schema.?
Hi All,
I am sure that we should be able to find out the version of RTC repository by running SQL against Jazz or JTS schema. & I have done this in the past. But I have missed that information or its not handy. Can someone share the SQL or any link to it.? Regards, Nagesh S |
2 answers
I've used the "application-about" to good effect in a curl or wget.
e.g. curl -k https://server.dom:nnnn/ctx/application-about substitute as follows: The fully-qualified host for server.dom The actual port for nnnn The application context for ctx You will get back something like: <?xml version="1.0" encoding="UTF-8"?> <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:jfs="http://jazz.net/xmlns/prod/jazz/jfs/1.0/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:oslc="http://open-services.net/ns/core#"> <oslc:Publisher rdf:about="https://server.com:9443/jazz/application-about"> <dcterms:title>Change and Configuration Management</dcterms:title> <dcterms:description>Provides capabilities for change management, planning, software configuration management, automation (build system), and extensions for IBM enterprise platforms development.</dcterms:description> <dcterms:identifier>http://jazz.net/application/ccm</dcterms:identifier> <jfs:version>5.0.2</jfs:version> <oslc:icon rdf:resource="https://server.com:9443/jazz/web/com.ibm.team.rtc.web/ui/graphics/UICustomizations/RTC_16.png"/> <jfs:instanceName>RTC</jfs:instanceName> </oslc:Publisher > </rdf:RDF> The best thing is that NO authentication is required all you need to know is the URI of the server. |
Hi Kevin,
Thanks for the answer but this method is useful only when application is up & running. I need to check the version of the repository incase the DB is corrupted or the server is not starting because of repository version mismatch. I could see something as below in the <JAZZ_SCHEMA>.JAZZ_PROPERTIES table after the application is upgraded to 5.0.2 Regards, Nagesh S Comments
Kevin Ramer
commented Dec 18 '15, 10:34 a.m.
I find a JAZZ.PROPERTIES table, but none of the rows contain what looks to be a version number. Yours seems to be an odd use-case and information about repositories and their versions ought to be determined and kept elsewhere. Some suggestions:
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.