Maximo

Hello,

I am having an issue trying to install Manage using a SQL database server.

I have MAS core up and running using these instructions. Version 8.10.2
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

I decided to use the GUI in MAS to install Manage. The SQL database is on AWS RDS right now though I have also tried using a dedicated instance with SQL installed. 

I went through configuring the database using this.
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/rds-sqlserver-create

And using different examples of the JDBC connection and options from these sites as well as others.
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

https://www.ibm.com/docs/en/maximo-manage/8.0.0?topic=suite-deploying-activating-manage

https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/install-manage

However even though I get green checkmarks for the database connections in Configurations, the Manage install stops progressing on database related errors.

TASK [debug] ********************************
ok: [localhost] => {
"status": {
"conditions": [
{
"message": "Server Bundles not deployed in workspace jfc ",
"reason": "Pending",
"status": "False",
"type": "Ready"
},
{
"message": "Build generated and tagged with 20230804T141411-8.6",
"reason": "Build completed",
"status": "True",
"type": "BuildReady"
},
{
"message": " Db Connection Failure updatedb-needed . Deployment all - not deployed",
"reason": "Pending",
"status": "False",
"type": "DeploymentReady"
},
{
"message": "status:dbconnex:failed: Db Connection Failure updatedb-needed ",
"reason": "Failed",
"status": "True",
"type": "DeploymentCR"

I can connect to the database from other locations so I know it is accessible and I've used a JDBC tester on the various connection strings I've tried with success. Could these errors be something other than Manage trying to connect to the SQL database?

These are the latest 2 versions of a JDBC connection I have tried.

No SSL
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false;trustServerCertificate=false;
SSL Enabled
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;

Though I have tried simpler ones like -  jdbc:sqlserver://SERVER:1433;databaseName=maxdb80;encrypt=true;

Thanks.

Not much help out here yet for MAS 8 Installs. Scares me to think how few people are actually doing it so far. I also have en environment that is running but Manage is telling me:

Hello,

I am having an issue trying to install Manage using a SQL database server.

I have MAS core up and running using these instructions. Version 8.10.2
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

I decided to use the GUI in MAS to install Manage. The SQL database is on AWS RDS right now though I have also tried using a dedicated instance with SQL installed. 

I went through configuring the database using this.
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/rds-sqlserver-create

And using different examples of the JDBC connection and options from these sites as well as others.
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

https://www.ibm.com/docs/en/maximo-manage/8.0.0?topic=suite-deploying-activating-manage

https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/install-manage

However even though I get green checkmarks for the database connections in Configurations, the Manage install stops progressing on database related errors.

TASK [debug] ********************************
ok: [localhost] => {
"status": {
"conditions": [
{
"message": "Server Bundles not deployed in workspace jfc ",
"reason": "Pending",
"status": "False",
"type": "Ready"
},
{
"message": "Build generated and tagged with 20230804T141411-8.6",
"reason": "Build completed",
"status": "True",
"type": "BuildReady"
},
{
"message": " Db Connection Failure updatedb-needed . Deployment all - not deployed",
"reason": "Pending",
"status": "False",
"type": "DeploymentReady"
},
{
"message": "status:dbconnex:failed: Db Connection Failure updatedb-needed ",
"reason": "Failed",
"status": "True",
"type": "DeploymentCR"

I can connect to the database from other locations so I know it is accessible and I've used a JDBC tester on the various connection strings I've tried with success. Could these errors be something other than Manage trying to connect to the SQL database?

These are the latest 2 versions of a JDBC connection I have tried.

No SSL
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false;trustServerCertificate=false;
SSL Enabled
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;

Though I have tried simpler ones like -  jdbc:sqlserver://SERVER:1433;databaseName=maxdb80;encrypt=true;

Thanks.

Hello,

I am having an issue trying to install Manage using a SQL database server.

I have MAS core up and running using these instructions. Version 8.10.2
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

I decided to use the GUI in MAS to install Manage. The SQL database is on AWS RDS right now though I have also tried using a dedicated instance with SQL installed. 

I went through configuring the database using this.
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/rds-sqlserver-create

And using different examples of the JDBC connection and options from these sites as well as others.
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

https://www.ibm.com/docs/en/maximo-manage/8.0.0?topic=suite-deploying-activating-manage

https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/install-manage

However even though I get green checkmarks for the database connections in Configurations, the Manage install stops progressing on database related errors.

TASK [debug] ********************************
ok: [localhost] => {
"status": {
"conditions": [
{
"message": "Server Bundles not deployed in workspace jfc ",
"reason": "Pending",
"status": "False",
"type": "Ready"
},
{
"message": "Build generated and tagged with 20230804T141411-8.6",
"reason": "Build completed",
"status": "True",
"type": "BuildReady"
},
{
"message": " Db Connection Failure updatedb-needed . Deployment all - not deployed",
"reason": "Pending",
"status": "False",
"type": "DeploymentReady"
},
{
"message": "status:dbconnex:failed: Db Connection Failure updatedb-needed ",
"reason": "Failed",
"status": "True",
"type": "DeploymentCR"

I can connect to the database from other locations so I know it is accessible and I've used a JDBC tester on the various connection strings I've tried with success. Could these errors be something other than Manage trying to connect to the SQL database?

These are the latest 2 versions of a JDBC connection I have tried.

No SSL
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false;trustServerCertificate=false;
SSL Enabled
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;

Though I have tried simpler ones like -  jdbc:sqlserver://SERVER:1433;databaseName=maxdb80;encrypt=true;

Thanks.

Andy, Did you ever get a resolution to your issue?

Hello,

I am having an issue trying to install Manage using a SQL database server.

I have MAS core up and running using these instructions. Version 8.10.2
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

I decided to use the GUI in MAS to install Manage. The SQL database is on AWS RDS right now though I have also tried using a dedicated instance with SQL installed. 

I went through configuring the database using this.
https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/rds-sqlserver-create

And using different examples of the JDBC connection and options from these sites as well as others.
https://ibm-mas-manage.github.io/sno/#mas-and-manage-installation

https://www.ibm.com/docs/en/maximo-manage/8.0.0?topic=suite-deploying-activating-manage

https://catalog.us-east-1.prod.workshops.aws/workshops/78554b88-0cd8-45a1-b9ee-2c1078aa6995/en-US/01-masinstallation/01-02-masinstall-private/install-manage

However even though I get green checkmarks for the database connections in Configurations, the Manage install stops progressing on database related errors.

TASK [debug] ********************************
ok: [localhost] => {
"status": {
"conditions": [
{
"message": "Server Bundles not deployed in workspace jfc ",
"reason": "Pending",
"status": "False",
"type": "Ready"
},
{
"message": "Build generated and tagged with 20230804T141411-8.6",
"reason": "Build completed",
"status": "True",
"type": "BuildReady"
},
{
"message": " Db Connection Failure updatedb-needed . Deployment all - not deployed",
"reason": "Pending",
"status": "False",
"type": "DeploymentReady"
},
{
"message": "status:dbconnex:failed: Db Connection Failure updatedb-needed ",
"reason": "Failed",
"status": "True",
"type": "DeploymentCR"

I can connect to the database from other locations so I know it is accessible and I've used a JDBC tester on the various connection strings I've tried with success. Could these errors be something other than Manage trying to connect to the SQL database?

These are the latest 2 versions of a JDBC connection I have tried.

No SSL
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false;trustServerCertificate=false;
SSL Enabled
jdbc:sqlserver://SERVER.amazonaws.com:1433;database=maxdb80;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;

Though I have tried simpler ones like -  jdbc:sqlserver://SERVER:1433;databaseName=maxdb80;encrypt=true;

Thanks.