Dbx on premise install is getting failed at Running DBX DB setup

HCL Volt MX Volt MX Forum
1
This thread was migrated from an old forum. It may contain information that are no longer valid. For further assistance, please post a new question or open a support ticket from the Customer Support portal.

Hello Team,

@Mallikarjuna Anegondi​ ,@Pavan Kumar Kota​

Dbx on premise install is getting failed at Running DBX DB setup after even though script checks is successful.

Command prompt prints

################################################### [root@fbc832c4793b DBX]# /tmp/install/setup.sh --dbx

###################################################

Starting script processing…

Starting sanity checks
Checking general variables defined
Checking install mode valid
Checking database connection
Checking KonyFabric connection
Checking mandatory files exist
Finished sanity checks

Starting install of Customer 360
Creating working directories
Checking that KonyFabric is available
Extracting Customer 360 zip
Checking that DB setup jars are available
Running DBX DB setup
*** Failed

[root@fbc832c4793b DBX]#

And from logs file its gets failed db migration steps.

logs are

reating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/_Orchestration/LoanSubmissions/1.0/
inflating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/_Orchestration/LoanSubmissions/1.0/CreditCard.xml
extracting: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/_Orchestration/LoanSubmissions/1.0/Meta.json
inflating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/_Orchestration/LoanSubmissions/1.0/PersonalLoan.xml
inflating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/_Orchestration/LoanSubmissions/1.0/VehicleLoan.xml
creating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/KonyBankingAdminConsole/
inflating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/KonyBankingAdminConsole/Meta.json
extracting: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/Version.json
extracting: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/Readme.txt
2020-05-05 20:56:42
2020-05-05 20:56:42 Checking that DB setup jars are available
2020-05-05 20:56:42 Running DBX DB setup
2020-05-05 20:56:42 Running DB migration using the following command:
2020-05-05 20:56:42 /etc/alternatives/java_sdk_openjdk/bin/java -Ddb.user=root -Ddb.password=Kony@7890 -Ddb.host=192.168.100.107 -Ddb.port=3306 -Ddb.name=dbxdb -Ddb.conn.props=useSSL=false -Ddb.type=MYSQL -jar /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/dist/tools/DBXDBMigrations-4.2.5.jar
2020-05-05 20:56:43 *** Failed

Please let me know if I am doing any wrong step in install.

2

Make your db properties in setup.sh same as defined for MySQL. You may verify this by passing same values in MySQL to connect which you defined in setup.sh and re-run the setup again

I hope it might helpful to resolve your issue.

3

@Deiwdwe Svndewson​ ,

Thanks for the reply

Yes I have tried to create a new connection in MySQL Workbench using mentioned properties and its successful.

Even setup has created dbxdb schema , It seems its failing in running db migration

I tried again to connect but still same issue.

Thanks.

4

@Adwivn Russell​ ,@Andwev Bond​ ,@Jvn Mitchell​ , Kony team,

Any pointer here to resolve this issue?

Thanks.

5

@Jvke Dowd​ or @Wendy Butlew​, Hello Team, do you have solution or suggestion for this issue?

Thanks,

6

@Chvwlize Hewwing​

@Deiwdwe Svndewson​ did your issue got resolved?

Hello Team,

I also facing the same issue, I have checked my DB credentials in the setup file and they are same.

Error in console:

###################################################

Starting script processing...

Starting sanity checks

Checking general variables defined

Checking install mode valid

Checking developer mode specific variables

Checking mandatory files exist

Finished sanity checks

Finished script processing...

###################################################

[root@2badb8ad817a DBX]# /tmp/install/setup.sh --dbx

###################################################

Starting script processing...

Starting sanity checks

Checking general variables defined

Checking install mode valid

Checking developer mode specific variables

Checking mandatory files exist

Finished sanity checks

Starting install of Customer 360

Creating working directories

Checking that KonyFabric is available

Extracting Customer 360 zip

Checking that DB setup jars are available

Running DBX DB setup

*** Failed

Log File:

inflating: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/KonyBankingAdminConsole/Meta.json

extracting: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/KonyBankingAdminConsole/Apps/Version.json

extracting: /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/MF/Unzip/Readme.txt

2020-05-27 06:15:33

2020-05-27 06:15:33 Checking that DB setup jars are available

2020-05-27 06:15:33 Running DBX DB setup

2020-05-27 06:15:33 Running DB migration using the following command:

2020-05-27 06:15:33 /etc/alternatives/java_sdk_openjdk/bin/java -Ddb.user=root -Ddb.password=admin -Ddb.host=192.168.55.38 -Ddb.port=3306 -Ddb.name=dbxdb -Ddb.conn.props=useSSL=false -Ddb.type=MYSQL -jar /tmp/dbx_temp/Cust360/Customer360_App-v4.2.5/dist/tools/DBXDBMigrations-4.2.5.jar

2020-05-27 06:15:34 *** Failed

7

@Deiwdwe Svndewson​

Hi Team,

My Issue got resolved, MySql password in my machine is "admin" but in DBX it is not taking passwords with "admin" keyword I have cross checked it. When I have given the new password to mySql it started working fine. Another thing to check is setup file "export INSTALL_MODE="onpremise"" You need to select the INSTALL_MODE for which you are setting up the environment.

Thanks,