Kbase P27678: 52 out of customer's 680 tables do not load completely via M
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/1/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL 2000
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
52 out of customer's 680 tables do not load completely
No errors generated
Load performed via MS SQL dataserver load utility
Sample stats:
table1
original 149497, loaded 148415, missing 1082, 2nd time l48600, missing 897
table2
original 166824, loaded 166612, missing 212, 2nd load 16675, missing 72
CAUSE:
Bug 20030519-031
CAUSE:
It is related to transaction processing.
Currently the code uses implicit transactions with a commit every 100
inserts. When an lock timeout error occurs any pending inserts are
rolledback (thus lost) and the current insert is retried.
FIX:
Add -Dsrv option AUTOCOMMIT,1 to the connection parameters This will
change the SQL commit mode to autocommit for the session and disables
transaction sets. The load may occur faster .
After loading the data the connection should be disconnected and
reconnected without the AUTOCOMMIT,1 parameter to ensure normal
functioning.