Kernel Troubleshooting

Symptom	Possible Cause	Suggested Solution
SQL error occurs when database connection is attempted.	DBMS server process not started.	Start DBMS server. See relevant DBMS documentation for specific instructions.
	Datasource incorrectly defined.	Ensure that the datasource is correctly set up and that SQL_DBNAME is set to the preferred datasource.
	User name or password incorrectly defined.	Ensure that the user name and password are valid for the chosen database and that CONNECTION = username/password are correct.
	External file type incorrectly defined.	Ensure that FILETYPE is set to the appropriate value.
SQL error occurs when database update is attempted.	Target table is not indexed. Many ODBC drivers are unable to lock or update HEAP tables.	Create a unique index on the table, or change the table storage structure to BTREE, ISAM etc.
	Record is already locked by another user.	Retry update later.
	An unsupported record locking mechanism has been selected.	Check value of <RDBMStype>_SELECT_FOR_UPDATE variable. If not set, set to TRUE. If set to TRUE, set to FALSE.

Topic ID: 720127