Release Automation

Expand all | Collapse all

RA 6.5 - Unable to login

Jump to Best Answer
  • 1.  RA 6.5 - Unable to login

    Posted 09-26-2017 03:54 AM

    Hi Experts,

     

    I have installed CA RA 6.5 using MYSQL database, installation was successful, but i am unable to login to ROC and automation studio.

    Getting error as below:

     

    The nolio_dm_all.log shows below error:

     

    Please advise.



  • 2.  Re: RA 6.5 - Unable to login
    Best Answer

    Broadcom Employee
    Posted 09-26-2017 04:36 AM

    Hi,

     

    Generally, HTTP 404 could be occurred when NAC cannot access database. Please check your database.properties and distributed.properties under <ReleaseAutomationServer>\webapps\datamanagement\WEB-INF. These files may have any conflict.

     

    For your reference:

    Install for a Distributed Environment - CA Release Automation - 6.5 - CA Technologies Documentation 

     

    On the other hand, flyway scripts problem was reported on previous releases. If you have no conflict properties file, I recommend to open new support case.

     

    HTTP 404 - /datamanagement/index.jsp error after upgrade to latest build 

    Upgrade systems based on MySQL running on LNX will fail to run flyway script,the RA UI will open with errors after the u… 

     

    Regards

    Yas



  • 3.  Re: RA 6.5 - Unable to login

    Posted 09-26-2017 05:20 AM

    Hi Yasuyuki,

     

    Thank you for the update.

    Have verified the properties files and there are no conflicts.

    The Flyway Migrate exception is everywhere in the nolio_dm_all.log. 

    Will raise a support case of the issue.

     

    Thanks

    Paneendra



  • 4.  Re: RA 6.5 - Unable to login

    Broadcom Employee
    Posted 09-26-2017 09:21 AM

    Hi,

     

       When you setup the MySQL Server did you make sure it was configured with the following requirements:

    • Uses the UTF8 character set
    • Has InnoDB storage enabled

    Regards

    Keith



  • 5.  Re: RA 6.5 - Unable to login

    Posted 09-26-2017 12:10 PM

    Hi Keith,

     

    Yes, the DB has InnoDB storage enabled and uses the UTF8 character set.

     

    Thanks

    Paneendra



  • 6.  Re: RA 6.5 - Unable to login

    Broadcom Employee
    Posted 10-04-2017 03:49 AM

    Hi

    Did the answers on this thread answered your question? If it did please mark it as the right answer.
    When your question is not answered or you still have additional questions please let us know.

    With Kind Regards
    Dirk



  • 7.  Re: RA 6.5 - Unable to login

    Posted 10-04-2017 05:17 AM

    Hi Dirk,

     

    We have raised a support case with CA support team and the issue is under investigation.

    We have not yet identified the root cause of the issue.

     

    Thanks & Regards

    Paneendra



  • 8.  Re: RA 6.5 - Unable to login

    Broadcom Employee
    Posted 10-04-2017 07:18 AM

    Hi 

     

    I looked at the support case , the root cause seems top be somthing in the access rights or setup of you rmysql database.

    On startup the flyway migration will create the database contents and this seems to fail. 

     

    Make sure you have prepared the mysql server correctly 

     

    Set Up the Database - CA Release Automation - 6.5 - CA Technologies Documentation 

     

    Regards Dirk 



  • 9.  Re: RA 6.5 - Unable to login

    Posted 10-05-2017 03:47 AM

    Hi Dirk,

     

    We have tried to recreated the scenario in a test instance and the issue has not been appearing again. 

    We will be liaising with DBA to sort out the issue.

     

    Thanks & Regards

    Paneendra



  • 10.  Re: RA 6.5 - Unable to login

    Broadcom Employee
    Posted 10-09-2017 04:17 AM

    Hi 
    I believe your questions has been answered, I will mark this as the correct answer.
    When your question is not answered or you still have additional questions please let us know.
    With Kind Regards

    Dirk