Notifications

859 views

Description

After upgrade to Jakarta, creators of reports are unable to see any reports under My Reports because of domain separation.

Steps to Reproduce

 

  1. Create report and set the report to Visible to me.

    For more information, see the product documentation topic Administering reports.

  2. Upgrade from Istanbul to Jakarta.

  3. Try to view the report.

    The reports are not visible under My Reports.

Workaround

  1. Navigate to System Definition > Fix Scripts.

  2. Click New to create a new fix script.

  3. Paste the following script and click Save.

    gs.print('Scheduled job started: Update created_by_user on sys_report ','scheduled item 8e8272f1d7312200bd4a4ebfae610332');  
    var rowsUpdated = 0;  
    var gr = new GlideRecord('sys_report'); 
    gr.addNullQuery('created_by_user'); 
    gr.queryNoDomain(); 
    
    var grUser = new GlideRecord('sys_user'); 
    while (gr.next()) { 
    var createdBy = gr.sys_created_by; 
    grUser.get('user_name',gr.sys_created_by.toString()); 
    gr.setValue('created_by_user',grUser.sys_id.toString()); 
    gr.setWorkflow(false); 
    
    if(gr.update()) { 
    rowsUpdated++; 
    
    } 
    
    }
    
    gs.print(rowsUpdated + ' rows was updated');
  4. Click Run Fix Script.

    Note that reports under My Reports are available.


Related Problem: PRB1081334

Seen In

Jakarta Patch 3

Fixed In

Jakarta Patch 5
Kingston

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-11-15 11:45:02
Published:2017-11-07