Kbase P140240: Sql server gets error (43) at startup, can not find or open the ai file. Errno = 13, and then dies
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/01/2009 |
|
Status: Unverified
SYMPTOM(s):
Sql server gets error (43) at startup, can not find or open the ai file. Errno = 13, and then dies with error (49).
SQLSERV 1: (43) ** Cannot find or open file <path>/db-name.a1, errno = 13.
SQLSERV : (49) SYSTEM ERROR: Memory violation.
ODBC clients getting error [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach when attempting to connect.
ai files have different ownership and permissions than database files.
FACT(s) (Environment):
UNIX
OpenEdge 10.x
CAUSE:
ai files should have the same ownership and permissions as the database files, so all database processes will have access to them.
FIX:
Set ownership and permissions of the ai files to match those of the database and then restart the database.