RB is looking for a database which was removed

Posted by HosnyA on 01-Jul-2015 06:36

We have removed an existing database from the databases.xml config file. However when the server is started the system generates the following error email to the emergency email address. Any ides where this could still be referenced?

Replace <DB name> with the Actual database name:

Database <DB name> not found
com.rb.util.db.a66: Database <DB Name> not found
at com.rb.util.db.a68.getPool(a68.java:70)
at com.rb.util.db.a68.getConnection(a68.java:37)
at com.rb.util.db.a68.getConnection(a68.java:29)
at p0.a414.countDeployedApplicationsFromDB(a414.java:282)
at p15.a556.getUsageData(a556.java:163)
at p24.a50.doJob(a50.java:36)
at com.rb.util.system.a148.run(a148.java:37)

Rollbase - Forum
Posted by Srinivas Panyala on 02-Jul-2015 08:24

I am able to reproduce this when I click customer record which is created with deleted DB. Please delete customer records which are pointing to deleted database.

Thanks

Srinivas

Posted by pvorobie on 01-Jul-2015 11:15

This function countDeployedApplicationsFromDB does not perform mission critical operation, so on my opinion it should simple return 0 in case of an error rather than throwing exception and causing customer’s disturbance.
 
Thanks,
pavel
 
[collapse]
From: Tom Kincaid [mailto:bounce-tkincaid@community.progress.com]
Sent: Wednesday, July 01, 2015 6:12 AM
To: TU.Rollbase@community.progress.com
Subject: RE: [Technical Users - Rollbase] RB looking for a database which was removed
 
Reply by Tom Kincaid
Did you restart all your Rollbase servers after updating database.xml?
 
 
Tom
 
 
[collapse]
From: HosnyA [mailto:bounce-HosnyA@community.progress.com]
Sent: Wednesday, July 01, 2015 7:37 AM
To: TU.Rollbase@community.progress.com
Subject: [Technical Users - Rollbase] RB looking for a database which was removed
 
Thread created by HosnyA

We have removed an existing database from the databases.xml config file. However when the server is started the system generates the following error email to the emergency email address. Any ides where this could still be referenced?

Replace <DB name> with the Actual database name:

[/collapse][/collapse]

All Replies

Posted by Anoop Premachandran on 01-Jul-2015 08:07

There are still some customer records which are pointing to the deleted Database

Posted by Tom Kincaid on 01-Jul-2015 08:11

Did you restart all your Rollbase servers after updating database.xml?
 
 
Tom
 
 
[collapse]
From: HosnyA [mailto:bounce-HosnyA@community.progress.com]
Sent: Wednesday, July 01, 2015 7:37 AM
To: TU.Rollbase@community.progress.com
Subject: [Technical Users - Rollbase] RB looking for a database which was removed
 
Thread created by HosnyA

We have removed an existing database from the databases.xml config file. However when the server is started the system generates the following error email to the emergency email address. Any ides where this could still be referenced?

Replace <DB name> with the Actual database name:

------------Start---------------

Database <DB name> not found
com.rb.util.db.a66: Database <Db Name> not found
at com.rb.util.db.a68.getPool(a68.java:70)
at com.rb.util.db.a68.getConnection(a68.java:37)
at com.rb.util.db.a68.getConnection(a68.java:29)
at p0.a414.countDeployedApplicationsFromDB(a414.java:282)
at p15.a556.getUsageData(a556.java:163)
at p24.a50.doJob(a50.java:36)
at com.rb.util.system.a148.run(a148.java:37)

[/collapse]

Posted by Yuriy Kupershmidt on 01-Jul-2015 08:36

Two thoughts:
1. If it is the main db its name must be RB:
Something like that:
<Database  name="RB" isDefault="true" isExternal="false" MinConnections="1" MaxConnections="100" MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="30" MaxConnLifetimeMins="60" >
<Driver>com.mysql.jdbc.Driver</Driver>
<Url>jdbc:mysql://localhost:3306/RB_DBO</Url>
<DbUser>root</DbUser>
<Password>rrr</Password>
</Database>
2. If you have more than one server databases.xml should be updated on all servers (and all should be restarted)
 
[collapse]
From: Tom Kincaid [mailto:bounce-tkincaid@community.progress.com]
Sent: Wednesday, July 01, 2015 9:12 AM
To: TU.Rollbase@community.progress.com
Subject: RE: [Technical Users - Rollbase] RB looking for a database which was removed
 
Reply by Tom Kincaid
Did you restart all your Rollbase servers after updating database.xml?
 
 
Tom
 
 
[collapse]
From: HosnyA [mailto:bounce-HosnyA@community.progress.com]
Sent: Wednesday, July 01, 2015 7:37 AM
To: TU.Rollbase@community.progress.com
Subject: [Technical Users - Rollbase] RB looking for a database which was removed
 
Thread created by HosnyA

We have removed an existing database from the databases.xml config file. However when the server is started the system generates the following error email to the emergency email address. Any ides where this could still be referenced?

Replace <DB name> with the Actual database name:

[/collapse][/collapse]

Posted by HosnyA on 01-Jul-2015 09:10

Hi, Yes. We did restart the server (we only have one RB server) after the change. And no it is not the default database, we haven't touched it. The system is working fine on the default database. We just receive this receive this email now and again.

Posted by pvorobie on 01-Jul-2015 11:15

This function countDeployedApplicationsFromDB does not perform mission critical operation, so on my opinion it should simple return 0 in case of an error rather than throwing exception and causing customer’s disturbance.
 
Thanks,
pavel
 
[collapse]
From: Tom Kincaid [mailto:bounce-tkincaid@community.progress.com]
Sent: Wednesday, July 01, 2015 6:12 AM
To: TU.Rollbase@community.progress.com
Subject: RE: [Technical Users - Rollbase] RB looking for a database which was removed
 
Reply by Tom Kincaid
Did you restart all your Rollbase servers after updating database.xml?
 
 
Tom
 
 
[collapse]
From: HosnyA [mailto:bounce-HosnyA@community.progress.com]
Sent: Wednesday, July 01, 2015 7:37 AM
To: TU.Rollbase@community.progress.com
Subject: [Technical Users - Rollbase] RB looking for a database which was removed
 
Thread created by HosnyA

We have removed an existing database from the databases.xml config file. However when the server is started the system generates the following error email to the emergency email address. Any ides where this could still be referenced?

Replace <DB name> with the Actual database name:

[/collapse][/collapse]

Posted by Srinivas Panyala on 02-Jul-2015 08:24

I am able to reproduce this when I click customer record which is created with deleted DB. Please delete customer records which are pointing to deleted database.

Thanks

Srinivas

Posted by HosnyA on 02-Jul-2015 08:47

ok, thanks. I have deleted the customer record now. I will wait and see if the email is generated again.

Thanks,

H

Posted by Gian Torralba on 06-Jul-2015 10:36

Hello,

How did it go? Is the error email message still being sent to you?

Regards,

Gian

Posted by HosnyA on 06-Jul-2015 11:30

Hi, We haven't received the error email so far, so I'm guessing that this should have fixed the issue.

Thanks.

This thread is closed