Clarity

  • Private Community

  • 1.  Clarity 12.1.3 BO reports output cleaning

    Posted Dec 11, 2014 10:47 AM

    Hi,

    We are using Clarity 12.1.3 with BO Report engine.

     

    I hope, every time after the reports got generated,  the output will be stored in the server.

     

    Could you please assist me how to clear or archive those files in BO Server?

     

    Any scripts are available so that, It can be automated.

     

    Thanks,

    Kannan



  • 2.  Re: Clarity 12.1.3 BO reports output cleaning
    Best Answer

    Broadcom Employee
    Posted Dec 11, 2014 12:44 PM

    Steps

     

    1. Login to CMC

    2. Go to instance manager

    3 Delete those instances

     

    For bulk deletion SAP has a solution inn vb script but you need to convert to perl for linux

     

    Cleaning up Large Numbers of Instances | SCN

     

     

    1)      Log into AdminTools

    http://<server>:<port>/AdminTools

     

    2)      Run query to get a list of all reports in BO server:

     

    Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID='CrystalEnterprise.Report' And SI_INSTANCE=0

     

    3)      Click on “Submit Query”. It will show the list of all reports in that BO server. Find the report name and its SI_ID

     

    4)      Create a jsp script using a text editor: (replace password, cmsname and parentReportID with right values, see values in red)

     

    <%@ page import = "com.crystaldecisions.sdk.exception.SDKException,

    com.crystaldecisions.sdk.framework.*,

    com.crystaldecisions.sdk.occa.infostore.*,

    java.util.*"

    %>

    <%

    // User Credentials

    String username = "Administrator";

    String password = "<Password>";

    String cmsname  = "<SystemVolume>";

    String authType = "secEnterprise";

    String parentReportID = "<SI_ID> ";

    int batchSize = 500;

     

    IEnterpriseSession enterpriseSession = null;

    IInfoStore infoStore;

    IInfoObjects boInfoObjects;

     

    // Log onto Enterprise

    enterpriseSession = CrystalEnterprise.getSessionMgr().logon(username, password, cmsname, authType);

    infoStore = (IInfoStore)enterpriseSession.getService("", "InfoStore");

     

    // The SI_ID to start at when searching

    int max_id = 0;

    for(;;) {

    // Loop through all objects - only retrieve the SI_ID in order to make the query run faster.

    boInfoObjects = (IInfoObjects)infoStore.query("Select TOP " + batchSize + " SI_ID FROM CI_INFOOBJECTS WHERE SI_INSTANCE=1 AND SI_SCHEDULE_STATUS=3  AND SI_PARENTID= " + parentReportID + " AND SI_ID > " + max_id + " ORDER BY SI_ID ASC");

     

     

    // If there are no more objects then we're done.

    if(boInfoObjects.size() == 0)

    break;

    for(Iterator boCount = boInfoObjects.iterator() ; boCount.hasNext() ; ) {

      IInfoObject boObject = (IInfoObject)boCount.next();

      max_id = boObject.getID();

      boObject.deleteNow();

      boInfoObjects.delete(boObject);

     

    }

    infoStore.commit(boInfoObjects);

    }

    • out.println("Completed</br>");

    %>

     

    5)      Save file as “Delete_failed_instances.jsp”

     

    6)      Copy the file in BO server under right location:

    If CABI 3.3:

    UNIX: Copy the script into the folder "<BO_INSTALL_DIR>\CA\SC\CommonReporting3\bobje\Tomcat6\webapps\InfoViewApp"

    Windows: Copy the script into the folder "<BO_INSTALL_DIR>\CA\SC\CommonReporting3\Tomcat6\webapps\InfoViewApp"

    If CABI 3.3 SP1:

    UNIX: Copy the script into the folder "<BO_INSTALL_DIR>\CA\SC\CommonReporting3\bobje\Tomcat7\webapps\InfoViewApp"

    Windows: Copy the script into the folder "<BO_INSTALL_DIR>\CA\SC\CommonReporting3\Tomcat7\webapps\InfoViewApp"

     

    7)      Make sure that Tomcat is running (If it is already running - there is no need to restart it)

     

    8)      Backup BO CMS Database

     

    9)      Run the script by opening a browser and going to http://<server>:<port>/InfoViewApp/Deleted_failed_instances.jsp

     

    Once it’s completed, it will display “Completed” on the screen

     

    Hope this helps you

     

    Regards

    Suman Pramanik



  • 3.  Re: Clarity 12.1.3 BO reports output cleaning

    Posted Dec 16, 2014 05:16 AM

    Hi Suman,

    Thanks for your reply.

    I haven't find any instances while navigating through the steps given

    1.Login to CMC

    2.Go to instance manager

    3 Delete those instances

     

    But when logon through  AdminTools and query the detail, I am able to find the results of around 100 entries.

    How is it possible?

     

    Moreover, where the report output gets stored physically in the server.

     

    Could you please assist me on this?

    Thanks,

    Kannan.



  • 4.  Re: Clarity 12.1.3 BO reports output cleaning

    Broadcom Employee
    Posted Dec 16, 2014 05:20 AM

    Hi kannan,

     

    If you go into instance manager and uncheck the status and then click on find to find out the instances, by default Pending is checked.

     

    Regards
    Suman Pramanik



  • 5.  Re: Clarity 12.1.3 BO reports output cleaning

    Posted Dec 16, 2014 05:26 AM

    Hi Suman,

    Thanks for your reply.

    I have got the results as mentioned.

     

    Thanks,

    Kannan



  • 6.  Re: Clarity 12.1.3 BO reports output cleaning

    Broadcom Employee
    Posted Dec 16, 2014 05:30 AM

    Thanks Kannan,

     

    Regards

    Suman Pramanik