ERR-4109C ( 266396) Invalid session property.#
Overview#
This document describes the cause of the ERR-4109C ( 266396) Invalid session property error that occurs when an Altibase client connects to an Altibase server and explains how to resolve it.
Version#
Altibase 6.1.1 or earlier
Symptom#
An Altibase client fails to connect to the server with the following error:
[ERR-4109C : Invalid session property]
For example, the following error occurs when connecting to the server using iSQL:
$ is
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.1.1.1.10
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = TCP, SERVER = 127.0.0.1, PORT_NO = 26110
[ERR-4109C : Invalid session property]
Cause#
When connecting to the server, an Altibase client requests the session properties required for its configuration. The ERR-4109C error occurs if the server does not support a session property requested by the client.
This error can typically occur with the following server and client version combinations:
- The major version of the client is higher than that of the server.
- The server and client have the same major version, but the patch version of the client is higher than that of the server.
Even when the server and client have the same major version, this error can occur if a new session property was added in a specific patch version and the server does not support that property.
Resolution#
Use a client version that is compatible with the server. If possible, Altibase recommends using the same version for both the server and client.
If a later client version must be used, patch or upgrade the server to a version that is compatible with the client.
Reference#
How to Check the Altibase Server Version#
Using a Command#
Run the following command in a Unix/Linux shell or Windows Command Prompt:
$ altibase -v
Using SQL#
Connect to the Altibase server and execute the following query:
SELECT PRODUCT_VERSION
FROM V$VERSION;
How to Check the Altibase Client Version#
APRE#
Run the following command to check the APRE version:
$ apre -v
ODBC Driver#
In Windows File Explorer, open the properties of the altiodbc.dll file and check its version.
JDBC Driver#
Run the following command to check the JDBC driver version:
$ java -jar Altibase.jar