Kbase P107177: Error 354 when executing a 4GL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/30/2010 |
|
Status: Verified
SYMPTOM(s):
Error 354 when executing a 4GL query
Unable to open or create <filename>, error <number>. (354)
Unable to open or create /u5/tehlm/tcpta/tcptahlm/srta22644, error 2. (354)
FACT(s) (Environment):
The query is executing on the server, being resolved using multiple indexes, and for some reason fails with error 354.
This only happens for some queries, at certain customer sites and is very intermittent.
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
The -T temporary directory is set to a directory name that has the same name as the database. For example the database is called:
/u5/tehlm/tcpta/tcptahlm
and the -T directory is name is:
/u5/tehlm/tcpta/tcptahlm/
FIX:
Rename the -T directory to something other than the database name.