Kbase P134825: Data Administration tool GPFs when updating a schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/13/2009 |
|
Status: Unverified
SYMPTOM(s):
Data Administration tool GPFs when updating a achema holder
Stack trace from _progress reads:
pmGetDll
DllStartup
DllStartup
\PROGRESS\bin\prow32.dll
FACT(s) (Environment):
Windows
Progress 9.1D
MS SQL DataServer
Does not crash when a new schema holder is used which was created from scratch.
Original schema holder was created against an MS SQL Server 7 database.
MS SQL 2000
schema holder header looks as follows:
DRIVER-NAME "SQLSRV32.DLL"
DRIVER-VERS "03.81.9030"
ESCAPE-CHAR " "
DRIVER-CHARS "3,13,14,17,20,23,33,35,"
DBMS-VERSION "Microsoft SQL Server 07.00.0623"
DSRVR-VERSION "03.52.0000"
PROGRESS-VERSION "Dictionary Ver#: 1.000.000 Client Ver#: 9 Server Ver# 9"
DSRVR-MISC "Microsoft SQL Server"
CODEPAGE-NAME "ISO8859-1"
CAUSE:
While the exact cause could not be determined there is strong evidence that the cause of this crash is the fact that the schema holder was created for a MS SQL Server 7 database but then it was attempted to update it against a MS SQL 2000 database.
FIX:
Create a new schema holder from scratch for the MS SQL Server 2000 database or dump the .df for the old schema holder and change the header to:
DRIVER-NAME "SQLSRV32.DLL"
DRIVER-VERS "03.85.1117"
ESCAPE-CHAR " """
DRIVER-CHARS "3,13,14,20,23,33,35,"
DBMS-VERSION "Microsoft SQL Server 08.00.0760"
DSRVR-VERSION "03.52.0000"
PROGRESS-VERSION "Dictionary Ver#: 1.000.000 Client Ver#: 9 Server Ver# 9"
DSRVR-MISC "Microsoft SQL Server"
CODEPAGE-NAME "iso8859-1"