Kbase P158949: _sqlsrv2 incorrectly writing SQL92 related information to wrong log file which has been named after
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2010 |
|
Status: Unverified
SYMPTOM(s):
_sqlsrv2 incorrectly writing SQL92 related information to wrong log file which has been named after the directory name not the database name.
Incorrect log file only created when the database is started by the AdminServer and a SQL92 connection is made.
Directory that database is stored in contains suffix of .db
FACT(s) (Environment):
Database started by the AdminServer.
SQL92 clients connecting to database.
Windows
OpenEdge 10.1x
OpenEdge 10.2x
CAUSE:
Bug# OE00194792
CAUSE:
If a database is stored in a directory which contains a suffix with a .db i.e. c:\mydir.db\sports2000 and the database has been served by the AdminServer, then any SQL92 connection to the database will cause the database to create a log file based on the directory name, i.e. c:\mydir.lg.
All SQL related activity will be incorrectly written to this log based on the directory name.
FIX:
Do not use a suffix of .db within the directory name housing a Progress / OpenEdge database.