Kbase P144615: Queries submitted through SQL92 are causing SQL trace files (.trc) to grow to large size on file sys
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/05/2009 |
|
Status: Unverified
SYMPTOM(s):
System running out of file space due to SQL .trc files filling up disks.
Queries submitted through SQL92 are causing SQL trace files (.trc) to grow to large size on file system.
Environment variable PROSQLTRC has been defined.
FACT(s) (Environment):
SQL92 is used to communicate with database.
No _sqlsrv2 processes are recorded in the database log as having died.
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
An environment variable, reserved for debugging purposes, was defined within the production environment.
The PROSQLTRC environment variable should only be used when directly advised by Technical Support.
The PROSQLTRC should not be left as an environment after the need to debug SQL has been addressed.
FIX:
Remove the PROSQLTRC environment variable.
On Windows:
If the variable has been set in the Windows System Environment Variables, delete the variable and restart the Progress / OpenEdge database(s).
On Windows or Unix:
If the variable has been set in a script, remove the entry which defines the variable PROSQLTRC then restart the Progress / OpenEdge database(s).