Remedy Smart Reporting - Client Sources issue

Version 6
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    Remedy Smart Reporting all versions.



    QUESTION:

    Smart Reporting application is not accessible due to Client Sources duplication.


    ANSWER:

    The error "License is Breached'  is seen in the console due to Client Sources duplication. This can be generated most of the time by:

       
    1. Process to implement Audit Report failed.
    2.  
    3. Some user with admin rights added the extra connection or modified the "Smart Reporting Repository DB" source connection (which is used to open the "Admin Reports").
      
    Troubleshooting  
       
    1. Open browser and log in to the Smart Reporting Admin Console using direct URL:     
           
      • http(s)://<SmartReportingHost or LB>:<port>/
      •   
    2.  
    3. Log in using the administrator (siadmin) credentials to Default organization.
    4.  
    5. Once logged in to application, navigate to Administration > Admin Console > click on License Management.
    6.  
    7. Breached license message will appear.
      
    User-added image


    Solution  
      Remove the duplicated Data-sources from the Smart Reporting Database.   
     
      Note: Make sure to create a backup of Smart Reporting database repository prior to executing below steps. 
     
    1. Stop Smart Reporting service.  
     
    2. Identify the organisation ID under    IpOrg column for which the extra source connection was added: 
      
       
    select * from Organisation
      
      
      3. Identify the ID of the extra connection using the value of    IpOrg column from above step: 
      
       
    select * from ReportViewSource  where IpOrg = Organisation.IpOrgand AccessCode = 'UNSECURE'
      
      
      Note: replace    "Organisation.IpOrg" with the value of    IpOrg column from    Organisation table. 
      
     
    4. Update the corresponding row to mark the extra connection as deleted: 
      
       
    update ReportViewSource set  AccessCode = 'DELETED'  where SourceId = SourceId_value
      
      
      Note: replace    "SourceId_value" with the corresponding value detected on step 3. 
      
     
    5. Start Smart Reporting service.  
     
    6. Now it will be possible to log in to Smart Reporting. 
      
     
      
      
      

     


    Article Number:

    000152359


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles