Kbase 21203: Eight (8) Character Nickname Causes SQL-89 Query Failure w/ 2phase
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2005 |
|
Status: Unverified
SYMPTOM(s):
SQL-89 and ESQL-89 queries fail with errors.
<program> --Could not find file <name> in database <db>. (1494)
** Table <name> does not exist or cannot be accessed. (962)
** Column <name> not found in table <name>. (965)
CAUSE:
SQL-89 queries will fail in this manner if all of the following are true:
1) Using Two-phase commit
2) Database has "nickname" of eight characters
3) User is connected client server (remote).
FIX:
To get around this, make sure you specify a nickname (-tp) of seven characters or less. Alternatively, users with an eight character nickname can connect via shared memory. Bug number 20010727-002 has been logged for this issue.