Back to list
Oct 19 2018

T79-2017: Isentris Authentication Databases from version 4.0 SP3 or earlier require an upgrade if they are used with Isentris 4.0 SP4 or higher versions.

Core Interface

The Isentris versions 4.0 SP3 HF1 and 4.0 SP3 HF2 introduced a new feature which allows the administrator to define an account lockout policy. As part of the Isentris 4.0 SP3 HF1/HF2 implementation of this feature the Isentris Authentication Database required an extension, and for the 4.0 SP3 HF1/HF2 versions this extension was provided in form of SQL scripts that needed to be excuted from the Isentris Authentication Database Oracle account.

As of Isentris version 4.0 SP4, new Authentication Databases are created with the required extension, and no SQL script needs to be executed for such new Authentication Databases. If you however are upgrading your environment from an Isentris 4.0 SP3 or earlier to an Isentris version 4.0 SP4 or higher, and you want to re-use the Isentris Authentication Database from an Isentris 4.0 SP3 or earlier version, you must upgrade the Authentication Database.

If you do not upgrade the authentication database you will not be able to use the account lockout feature introduced with Isentris 4.0 SP3 HF1/HF2. You actually can set and activate the lockout policy, however, if a user then tries to login with Isentris Client he will receive the error listed in the Error Message section. Likewise, you will not be able to delete users from the Isentris Authentication Database.
Resolution:
To update your authentication database follow these steps:

  1. Shutdown the Isentris Services
  2. Make sure you have a backup of the Oracle account of the Isentris Authentication Database.
  3. Login to the Oracle account of the Isentris Authentication database. If you are unsure about the Oracle account used for the Isentris Authentication Database please start the Isentris Configuration Tool and inspect the connection settings in the 'Services > Authentication' tree.
  4. Run the SQL script 'update_authentication_db.sql' attached to this Technote. This script is essentially the same as provided with Isentris 4.0 SP3 HF1.
  5. Start the Isentris Services.


Error Mesage:
The system could not log you on. Make sure your User name and domain are correct, then type your password again. Letters in passwords must be typed using the correct case.

Error message: User 'my.user' is not authorized to connect to Isentris '';

nested exception is:

com.mdli.isentris.authentication.AuthenticationException: ORA-00942: table or view does not exist