AnsweredAssumed Answered

RSA AAoP 7.3.0.0 database setup sql scripts won't run successfully

Question asked by Prabhjyot Kaur on Oct 30, 2019
Latest reply on Nov 14, 2019 by Prabhjyot Kaur

Like • Show 0 Likes0
Comment • 13

Hi, I have set up using the following components:

AAoP v 7.3.0.0

Rhel 7

Tomcat version 7

JRE version 1.7

oracle 12c

ojdbc7.jar thin driver for oracle 12c

When I try to set up the databases while installation, namely the core, bo, case management and rdp trojan, I receive errors saying that the database scripts could not be run successfully. Kindly let me know of the possible reasons behind this. Though I am able to obtain the login page of backoffice application (that is the only war file i have tried deploying till now), it doesn't let me go through with the default credentials: admin/admin.

Thanks.

No one else has this question

Outcomes

13 Replies

Jasmine Zakir Hussain Oct 31, 2019 2:16 PM
Mark Correct
Correct Answer
Please attach the logs showing the error stack.

Thanks,

Jasmine
Like • Show 0 Likes0
Actions
Prabhjyot Kaur Nov 4, 2019 6:42 AM
Mark Correct
Correct Answer
Hi Jasmine, I was successfully able to run the scripts. However, here is one concern. While specifying creation parameters for the Core Database on Oracle, I had given /home/oracle/AAOP7300/3 as the BLOB Tablespace Path. However no such file is to be seen at this path even after execution of all the sql scripts for core db, bo and case management. All the rest files get created with no problems. Is this a normal behavior or am I going wrong somewhere? Thanks.
Like • Show 0 Likes0
Actions
- Jasmine Zakir Hussain @ Prabhjyot Kaur on Nov 4, 2019 4:12 PM
  Mark Correct
  Correct Answer
  Did the script 15_DBA_CreateBLOBTablespace.sql execute successfully?
  
  Thanks,
  Jasmine
  Like • Show 0 Likes0
  Actions
  - Prabhjyot Kaur @ Jasmine Zakir Hussain on Nov 4, 2019 11:50 PM
    Mark Correct
    Correct Answer
    Hi Jasmine, the following could be seen in the logs for this particular script:
    
    Thanks.
    Like • Show 0 Likes0
    Actions
Prabhjyot Kaur Nov 11, 2019 6:26 AM
Mark Correct
Correct Answer
Hi, as already told earlier, I have set up using the following components:

AAoP v 7.3.0.0 (on premise)
Rhel 7
Tomcat version 7
JDK version 1.7
oracle 12c
ojdbc7.jar thin driver for oracle 12c

Though I am able to run all the sql scripts successfully, I am not able to log in to the back office application. That is the first application I try to log into. I am using the default credentials admin/admin and see the following in bo_logs:

I have also followed the instructions given on the link 000011858 - BackOffice Tools 'admin' user password reset in RSA Adaptive Authentication (OnPrem) but to no help. No errors are seen in catalina.out of Tomcat. Kindly help. Let me know of anything required from my side.
Thanks.
Like • Show 0 Likes0
Actions
- Jasmine Zakir Hussain @ Prabhjyot Kaur on Nov 11, 2019 8:37 AM
  Mark Correct
  Correct Answer
  Looking at the error stack the database scripts did not execute successfully. Are you doing a fresh install or an upgrade?
  I would suggest you open a case with us by following the article below so that someone from the support team can have a live session and troubleshoot further.
  
  000036161 - How to open a technical support case via the Case Management portal on RSA Link
  
  Thanks,
  Jasmine
  Like • Show 0 Likes0
  Actions
  - Prabhjyot Kaur @ Jasmine Zakir Hussain on Nov 11, 2019 11:25 AM
    Mark Correct
    Correct Answer
    Hi Jasmine, I am doing a fresh installation of the product. For your information, I have used oracle user (namely, oracle) to carry out the installation. Tomcat and JRE also have been configured in the user oracle's environment. Though I would open a case for this, but could you let me know which script(s) could have caused trouble?
    Thanks.
    Like • Show 0 Likes0
    Actions
    - Jasmine Zakir Hussain @ Prabhjyot Kaur on Nov 12, 2019 9:37 AM
      Mark Correct
      Correct Answer
      All scripts cannot be executed with Oracle User each scripts has to be run with RSA schema and application user as described in the installation and upgrade guide.
      
      Thanks,
      Jasmine
      Like • Show 0 Likes0
      Actions
      - Prabhjyot Kaur @ Jasmine Zakir Hussain on Nov 13, 2019 3:34 AM
        Mark Correct
        Correct Answer
        Hi Jasmine, I have run the scripts using their corresponding users only, like RSA_CORE for the schema owner of core db, RSA_CORE_USER as the core application user etc.
        
        While creating the databases for installation, I used the SID of the oracle database (namely, orcl) as the SID for the core, cm and bo databases. I hope I can go by the default terminology for the names of the users like RSA_CORE (schema owner of core db), RSA_CM, RSA_BO, RSA_CORE_USER, RSA_CM_USER and RSA_BO_USER and this has nothing to do with the oracle user (namely, oracle).
        
        Also, can you tell me if I go by the default terminology used in the installation, is the schema owner and the schema name the same? For example the schema and schema name of case management db use the same name RSA_CM. Is that the case?
        
        Thanks
        Like • Show 0 Likes0
        Actions
        Prabhjyot Kaur @ Prabhjyot Kaur on Nov 13, 2019 4:01 AM
        Mark Correct
        Correct Answer
        As you had said to open a case, I tried doing that also, but when I click on My cases, I receive a login error. Can you please help with that?
        Like • Show 0 Likes0
        Actions
        Jasmine Zakir Hussain @ Prabhjyot Kaur on Nov 14, 2019 9:44 AM
        Mark Correct
        Correct Answer
        Please send an email to support@rsa.com, and RSA Link team will be able to fix your access issues.
        Thanks,
        Jasmine
        Like • Show 0 Likes0
        Actions
        Jasmine Zakir Hussain @ Prabhjyot Kaur on Nov 14, 2019 9:45 AM
        Mark Correct
        Correct Answer
        Could you please attach the complete install.log, and logs of the DB script run.
        Thanks,
        Jasmine
        Like • Show 0 Likes0
        Actions
        Prabhjyot Kaur @ Jasmine Zakir Hussain on Nov 14, 2019 10:29 AM
        Mark Correct
        Correct Answer
        Hi Jasmine, please find the logs here. As I carried out the installation in three steps (first for just the databases, second for core apps and third for the bo apps), I am attaching the three corresponding files.
        
        Thanks.
        Attachments
        install3.log.zip58.4 KB
        install2.log.zip52.4 KB
        install1.log.zip15.5 KB
        Like • Show 0 Likes0
        Actions

RSA AAoP 7.3.0.0 database setup sql scripts won't run successfully

Outcomes

Attachments

Related Content

Recommended Content