Clarity

  • 1.  Installing the CA_Clarity_Universes_Oracle.BIAR

    Posted Oct 30, 2014 09:01 AM

    I am working in a completely Linux environment and I need to install the BIAR.  The installation guide points to using a windows import wizard but in my environment there are no windows systems and no network access to any.

     

    I have been successful in importing it via a Linux command (java –j biarengine.jar).  Once this done, I am able to see reports via the Clarity UI but in doing the import it changes the CMC administrator password and I am no longer able to gain access to CMC.

     

    I created an backup administrator account thinking that I would just login to it after the import and reset the administrator password but the import remove that account from the administrator group (guess here).

     

    So my questions?

     

    1. Does anyone know what the administrator account password is that comes in with  CA_Clarity_Universes_Oracle.BIAR?
    2. Does anyone know how to manually setup the BO without using the CA_Clarity_Universes_Oracle.BIAR? (only use Crystal Reports / shouldn’t be hard – guessing)?
    3. I have seen posting on how to reset the administrator password but in my environment, I am unable to find a command tool to run the suggested SQL statement (no GUI in this environment).  Will resetting administrator password via this type of method cause any downstream issues with Clarity?

     

    V/r,

    Gene



  • 2.  Re: Installing the CA_Clarity_Universes_Oracle.BIAR

    Broadcom Employee
    Posted Oct 30, 2014 09:12 AM

    Hi Gene,

     

    The problem you are losing your administrator right is due to  a known bug CLRT-74140 and the workaround is Don't click select all but only select all groups from left window.


    To overcome this problem


    . Take the back up of the CMS repository tables as a precaution.
    2. Open the Central Configuration Manager (CCM).
    3. Stop the Server Intelligence Agent (SIA).
    4. Login to Mysql:
    Run the following SQL statements on the CMS database:
    5. DELETE FROM cms_infoobjects6 WHERE (ObjectID=12);
    COMMIT;
    Note :
    DELETE FROM cms_infoobjects5 WHERE (ObjectID=13);
    COMMIT; can be used based on version.
    6. This will delete a record that belongs to the "Administrator" account.
    7. Restart #Server Intelligence Agent (SIA)# from the CCM. This will recreate
    the administrator account with a blank password.
    8. Now you can log on to the Central Management Console (CMC) using Administr
    ator as a user name and a blank password.


    1.png


    Once the password is reset you can reimport once again by un checking as shown in the picture. Hope this helps


    Regards

    Suman Pramanik

     



  • 3.  Re: Installing the CA_Clarity_Universes_Oracle.BIAR

    Broadcom Employee
    Posted Oct 30, 2014 09:14 AM

    Hi Gene,

     

    We also have a technical document

     

     

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec587921.aspx

     

    Regards

    Suman Pramanik



  • 4.  Re: Installing the CA_Clarity_Universes_Oracle.BIAR

    Posted Oct 30, 2014 12:54 PM

    Suman,

     

    Thanks for the response but I don't have the ability to run the (windows exe) import wizard as you showed in your reply.

     

    I am looking for a way to import the BIAR and work around the bug via a linux command (java –j biarengine.jar) import.

     

    V/r,

    Gene



  • 5.  Re: Installing the CA_Clarity_Universes_Oracle.BIAR

    Broadcom Employee
    Posted Oct 30, 2014 01:09 PM

    Gene,

     

    Let me figure out how it can be done. I will get back

     

    Regards

    Suman Pramanik

    Sent from my Sony Xperia™ Z

     

     

    -


    gcubed wrote -


     

    CA Communities <https://communities.ca.com/?et=watches.email.thread>

     

    Installing the CA_Clarity_Universes_Oracle.BIAR

     

    reply from gcubed<https://communities.ca.com/people/gcubed?et=watches.email.thread> in CA PPM - View the full discussion<https://communities.ca.com/message/241716709?et=watches.email.thread#241716709>



  • 6.  Re: Installing the CA_Clarity_Universes_Oracle.BIAR
    Best Answer

    Posted Nov 10, 2014 12:10 PM

    For anyone else that has this issue.

     

    Install a SQLA1201_Client found here on your linux BO Server: SAP SQL Anywhere Database Client Download | SCN

     

    You import the BIAR via the linux command (java -jar biarengine.jar).  This will reset the administrator password to something you don't know!

     

    Using the SQL Anywhere Database Client execute the sql statement that Suman provide above.  This reset the administrator password to blank.

     

    V/r,

    Gene

     

     

    http://scn.sap.com/docs/DOC-35857