What happens when BC is processing a job and Database goes down?
Article ID: KB0088168
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | - |
| Not Applicable | - |
Description
Resolution:
Description
-------------
What happens when BC is processing a job and Database goes down?
Environment
-------------
All Platforms
Resolution
-------------
Here are the potential consequences when BC is processing a job and the database goes down:
1. If DB comes back online within the maxretry limit, pending jobs will be picked up and processed from where they were last checkpointed.
2. If DB comes back online after the maxretry limit is over, pending jobs will be terminated with an error.
There are two properties, bc.db.maxretry and bc.db.sleep.between.retry which controls BC behavior in reconnecting to a database. If the bc.db.maxretry and/or interval between the each try (bc.db.sleep.between.retry) is increased through the Admin GUI under BusinessConnect->System Settings->Installed Protocols , the DB will have more time to come back online without having pending jobs terminate with errors.
Description
-------------
What happens when BC is processing a job and Database goes down?
Environment
-------------
All Platforms
Resolution
-------------
Here are the potential consequences when BC is processing a job and the database goes down:
1. If DB comes back online within the maxretry limit, pending jobs will be picked up and processed from where they were last checkpointed.
2. If DB comes back online after the maxretry limit is over, pending jobs will be terminated with an error.
There are two properties, bc.db.maxretry and bc.db.sleep.between.retry which controls BC behavior in reconnecting to a database. If the bc.db.maxretry and/or interval between the each try (bc.db.sleep.between.retry) is increased through the Admin GUI under BusinessConnect->System Settings->Installed Protocols , the DB will have more time to come back online without having pending jobs terminate with errors.
Issue/Introduction
What happens when BC is processing a job and Database goes down?
Feedback
Yes
No
Powered by
