Content Comparison

In some occasions, the analytics team may need to take specific actions to check or update changes in the datamarts. Examples in which this may happen may include the following:

...

1. Rerun the PDO_STAR query above. This refresh is immediate, so you can run the query right away.
2. If it returns nothing, the DM is all set.
3. If it still returns records, ensure that that is unexpected behavior and try the refresh again. (occasionally, there are other samples that need to remain with the "old" IDs, as is usually the case in sample swaps)
   1. If it still returns unexpected records, talk with Nasko.

2.4. Refreshing the ReadgroupMetadata DM in SEQPROD Database

1. Log in to COGNOS@SEQPROD on SQL Navigator

2. Request a refresh for RunMercuryAgent by issuing the following query:
   

   Code Block
   language sql
   BEGIN cognos.data_warehouse_api.request_refresh(P_FLOWCELL_BARCODE=>'XYZ', P_REQUESTED_BY=>'JohnDoe', P_COMMENTS=>'Test', P_DEFERRAL_ANALYSIS_DATE=>null); END;

   Note: No COMMIT command needed after this particular call - it's implicitly done for you. Just replace the XYZ with a flowcell barcode. Leave all other parameters there and unchanged.

   If you have multiple flowcells, you may run the query as follows, adding additional lines after BEGIN:

   Code Block
   language sql
   BEGIN cognos.data_warehouse_api.request_refresh(P_FLOWCELL_BARCODE=>'XYZ1', P_REQUESTED_BY=>'JohnDoe', P_COMMENTS=>'Test', P_DEFERRAL_ANALYSIS_DATE=>null); cognos.data_warehouse_api.request_refresh(P_FLOWCELL_BARCODE=>'XYZ2', P_REQUESTED_BY=>'JohnDoe', P_COMMENTS=>'Test', P_DEFERRAL_ANALYSIS_DATE=>null); cognos.data_warehouse_api.request_refresh(P_FLOWCELL_BARCODE=>'XYZ3', P_REQUESTED_BY=>'JohnDoe', P_COMMENTS=>'Test', P_DEFERRAL_ANALYSIS_DATE=>null); ... cognos.data_warehouse_api.request_refresh(P_FLOWCELL_BARCODE=>'XYZX', P_REQUESTED_BY=>'JohnDoe', P_COMMENTS=>'Test', P_DEFERRAL_ANALYSIS_DATE=>null); END;

Note: No COMMIT command needed after this particular call - it's implicitly done for you. Just replace the XYZ with a flowcell barcode. Leave all other parameters there and unchanged.

...

...

2.5. Wait for RunMercury agent and recheck.

The RunMercury agent is run on a schedule. After the next run, rerun the SELECT SQL clause in step 1 to ensure that the records have been refreshed and are not returned with the old collab sample id.

http://analytics:8090/etl_runs?status=Succeeded&status=Failed&status=Running&status=Abandoned&status=Halted&agent=analytics.tiger.agents.RunMercury&action=Refresh

3. Related pages

Performing metadata changes

...