Troubleshoot Overview

16 Troubleshoot Overview

This topic provides information on Troubleshoot Overview.

This section describes how to troubleshoot OBDX setup.

Invalid database password

This topic contains troubleshooting information if you receive an error when attempting to connect to the database server.

If you get the following error:

Try one of the following:

Verify that the database is running.
Check Network connectivity between Weblogic Server and Database server.
Check the database configuration in installer.properties file
Verify that the entered password is correct.

cx_oracle module

This topic contains troubleshooting information about problems with cx_Oracle python module.

If you get the following error:

Execute the below command:

export LD_LIBRARY_PATH=/usr/lib/oracle/19.10/client64/lib:$LD_LIBRARY_PATH
python     
    import cx_Orace     
    cx_Oracle.__version__

Failed Database Scripts

This topic contains troubleshooting information in case of database script failures.

If you get the following error in DB_installation.log:

Entitlement.log :

Failure of Policy Seeding

This topic contains troubleshooting information if policy seeding fails during installation.

If you get the following error:

Try one of the following:

Check if Entitlement.log is created on following path 
<OBDX INSTALLER DIR>/ExecInstances/<DDMonthHHMM>/logs/db/ and contains any SEVERE errors for Entitlement policy seeding.

Check if Task.log is created on following path 
<OBDX INSTALLER DIR>/ExecInstances/<DDMonthHHMM>/logs/db/ and contains any SEVERE errors for Task policy seeding.

Check if Dashboard_seed.log is created on following path 
<OBDX INSTALLER DIR>/ExecInstances/<DDMonthHHMM>/logs/db/ and contains any SEVERE errors for Dashboard policy seeding.

Check the seedPolicies.log in <OBDX INSTALLER DIR>/ExecInstances/<DDMonthHHMM>/logs/db/ directory 
if it contains any runtime errors generated during execution of the policies Seeding in OBDX schema

Fix the problem by following below steps:

Login to OBDX installer server
Over-write the policies files (Day0Policy.csv; Entitlement.csv; Resources.csv and Task.csv) from OBDX Product zip into <OBDX INSTALLER DIR>/installables/policies directory
Browse to <OBDX INSTALLER DIR>\ installables\policies
Edit Entitlement_log4j.properties , Task_log4j.properties & Dashboard_seed_log4j.properties . Replace <logs_path> with directory where policy seeding logs will be generated
e.g.

Run below command manually if “SEVERE” error logs are found in Task.log

java -jar -Djava.util.logging.config.file='<logs.properties>’
com.ofss.digx.utils.feed.data.task.jar "Task.csv" "oracle.jdbc.OracleDriver,
<OBDX Schema name>,<OBDX Schema password>,jdbc:oracle:thin:@<OBDX DB hostname or 
IP>:<OBDX DB listener port>/<OBDX Service Name>"
KERNEL NO_FLUSH initialPoolSize=1 minPoolSize=1 maxPoolSize=20 maxIdleTime=600
      timeoutCheckInterval=5 inactiveConnectionTimeout=30

java -jar -Djava.util.logging.config.file='Task_log4j.properties’ 
com.ofss.digx.utils.feed.data.task.jar ‘Task.csv’ 
"oracle.jdbc.OracleDriver,OBDX_THP181,Welcome#1,
jdbc:oracle:thin:@xx.xx.xx.xx:1521/OBDX"
KERNEL NO_FLUSH initialPoolSize=1 minPoolSize=1 maxPoolSize=20 maxIdleTime=600
      timeoutCheckInterval=5 inactiveConnectionTimeout=30

Run below command manually if “SEVERE” error logs are found in Entitlement.log

java -jar -Djava.util.logging.config.file='<logs.properties>’
com.ofss.digx.utils.entitlement.feed.data.jar
‘Resources.csv,Entitlement.csv,Day0Policy.csv’ 
'KERNEL'  "oracle.jdbc.OracleDriver,<OBDX Schema name>,
<OBDX Schema password>,jdbc:oracle:thin:@<OBDX DB hostname 
or IP>:<OBDX DB listener port>/<OBDX Service Name>"
NO_FLUSH initialPoolSize=1 minPoolSize=1 maxPoolSize=20
        maxIdleTime=600 timeoutCheckInterval=5
    inactiveConnectionTimeout=30

e.g.

java -jar -Djava.util.logging.config.file='Entitlement_log4j.properties’  
com.ofss.digx.utils.entitlement.feed.data.jar  ’Resources.csv,Entitlement.csv,
Day0Policy.csv’  'KERNEL' "oracle.jdbc.OracleDriver,OBDX_THP201,Welcome#1,
jdbc:oracle:thin:@xx.xx.xx.xx:1521/OBDX"
NO_FLUSH initialPoolSize=1 minPoolSize=1 maxPoolSize=20
        maxIdleTime=600 timeoutCheckInterval=5
    inactiveConnectionTimeout=30

Note:

Please remove the space between multiple csv’s if there is any.

Run below command manually if “SEVERE” error logs are found in Dashboard_seed.log

java -jar -Djava.util.logging.config.file='<logs.properties>’
com.ofss.digx.utils.dashboard.jar  ‘<path>/
dashboard_json’  "oracle.jdbc.OracleDriver,<OBDX Schema name>,
<OBDX Schema password>,jdbc:oracle:thin:@<OBDX DB hostname or 
IP>:<OBDX DB listener port>/<OBDX Service Name>"
initialPoolSize=1 minPoolSize=1 maxPoolSize=20 maxIdleTime=600 timeoutCheckInterval=5
      inactiveConnectionTimeout=30

e.g.

java -jar -Djava.util.logging.config.file= Dashboard_seed_log4j.properties’
com.ofss.digx.utils.dashboard.jar 
‘/installables/policies/dashboard_json’ "oracle.jdbc.OracleDriver,OBDX_THP201,
Welcome#1,jdbc:oracle:thin:@xx.xx.xx.xx:1521/OBDX"
initialPoolSize=1 minPoolSize=1 maxPoolSize=20 maxIdleTime=600 timeoutCheckInterval=5
      inactiveConnectionTimeout=30

Post successfully execution, restart Managed server.