Export "Active Transactions (All Nodes)" on v_cluster_transaction table fails with 0 rows - Known Error

Export "Active Transactions (All Nodes)" on v_cluster_transaction table fails with 0 rows Description Administrators are unable to export the results from "Active transactions (All nodes)" into a report using the List menu "Export" to XML, excel, csv, json, etc.

Steps to Reproduce

Go to active Transactions (all nodes) list. 2. Right click on node id 3. Choose export from list 4. Export to excel, CSV, or any other format available from the list menu 5. Download the export

You will see the report only contains the header.

Workaround Instead of using the list view to export the data, open the the v_cluster_transaction list directly (full frame/outside the nav_to.do frame) and export directly from the URL by adding the format at the end of the URL.

e.g /v_cluster_transaction_list.do?CSV

Alternatively, use the required format.

Alternatively, you can emulate the code from the loading_transactions.do UI page. For example:

var vct = new VClusterTransaction('v_cluster_transaction'); vct.deleteTransactions(); var id = vct.informOtherNodes(); vct.refreshTransactions(GlideSession.get().getSessionID()); gs.log("Querying v_cluster_transaction", "SOURCE"); var gr = new GlideRecord("v_cluster_transaction"); gr.addQuery("age", ">", gs.getDurationDate('0 0:1:0')); gr.query(); while ( gr.next() ) { // Now that the virtual table is populated, query the physical table and do something: gs.log("LONG RUNNING TRANSACTION OVER 1 MINUTE: SESSION=" + gr.session_id + " AGE=" + gr.age + " URL=" + gr.url, "SOURCE" ); } Related Problem: PRB1244714