Kbase P65286: SQL Exception 7587 with Concurrent users inserting records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/26/2005 |
|
Status: Unverified
FACT(s) (Environment):
AIX
Progress 9.1D07
SQL Explorer Tool
SYMPTOM(s):
SQL Exception 7587 with Concurrent users inserting records
SQL Exception 1
SQLState = 42000
ErrorCode = 20003
[JDBC Progress Driver]:Syntax Error (7587)
CAUSE:
Concurrent Sessions thru SQL Explorer connected to DB within AIX will give the error doing INSERT to a table.
This is reproducible with or without AUTO COMMIT TRANSACTIONS checked.
a .TRC file will be generated in the working directory of the client, containing:
[tid3900]:error in tcp bind 10061
Note the problem has nothing to do with the syntax of the statement.
FIX:
This issue has been fixed in: (PROGRESS: 9.1D09).