Kbase P133186: Errors 2624 and 2913 trying to get the sequence value from Progress MS SQL DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Errors 2624 and 2913 when trying to get the sequence value from Progress MS SQL DataServer using OE10.1B or OE10.1C
<owner>._SEQP_<sequencename> in use by another user requesting a sequence value on tty?. Wait or choose CANCEL to stop. (2624)
Lock failure trying to obtain value for sequence owner>._SEQP_<sequencename>. Consider increasing PRGRS_NATIVE_LOCKWAIT to better service lock requests
Unknown expression <owner>._SEQP_<sequencename>. (2913)
Two out of thirty Windows XP client machines are getting the above errors
SQL Server driver is used on all thirty Windows XP machines
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge DataServer Category: SQL Server
MS SQL DataServer
CAUSE:
The ODBC system DSN is pointing to master database on the default database settings on those two Windows XP machines showing the above errors when sequence value are being created.
FIX:
Modify the ODBC system DSN to point to the correct database on the default database setting.