Kbase P120557: Error 2024 when connecting to a database that is Two Phase Commit (2PC) enabled.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/20/2006 |
|
Status: Unverified
SYMPTOM(s):
Error 2024 when connecting to a database that is Two Phase Commit (2PC) enabled.
Cannot connect to <database>. Has the same nickname <nickname>, as <database>. (2024)
Error occurs during a client connection to any of the databases in the group that are 2PC enabled
CAUSE:
When enabling the two databases for Two Phase Commit, the same nickname was given for each database.
For example:
proutil custdb -C 2phase -tp my2pc -crd
proutil orderdb -C 2phase -tp my2pc
FIX:
Ensure that you use different nicknames for each database.
The nicknames are used internally as a short form of identifying each database. The names cannot be the same otherwise the 2PC will not be able to determine which database the transaction has or has not been committed to.
An example of correctly enabling two databases with different nicknames:
proutil custdb -C 2phase -tp cust -crd
proutil orderdb -C 2phase -tp order