Official Content
  • This documentation is valid for:

The GeneXus Access Manager (GAM) database structure has changed in GeneXus X Evolution 3, so that a reorganization is required for upgrading to the new version, 3.0.6.

The database reorganization is done automatically in the F5 of GeneXus, and it may also be executed using the GAM Deploy Tool, as explained below.

Opening the KB with GeneXus Evolution 3 

The following will occur when a Knowledge Base created with a previous version is opened with GeneXus Evolution 3:

1. When the F5 is executed, Genexus prompts the user to install the GAM - Examples, distributed with GeneXus X Evolution 3.

If the dialog is closed by the user, or if all options are unchecked, the GAM examples will not be installed. The GAM API is always installed because it is needed for upgrading to the new version of the GAM libraries.

GAM upgrade to 3.0.6 version

2. After importing the GAM external objects and the selected options, the following dialog is shown to the user:

GAM reorg to 3.0.6 version

This dialog warns the user that a database reorganization is needed to go on with the GAM update to version 3.0.6. If confirmed, the database will be reorganized.

Reorganization to 3.0.6 version

The reorg is basically the following (other new tables, not listed below, are also created):

Session Table:

  • New         SesExtToken2    Varchar (1024) NLS    Null
  • New         SesOauthTokenMaxRenew    Numeric (4)    Null
  • New         SesOauthTokenExpire    Numeric (6)    Null
  • New         SesOauthScope    Varchar (1024) NLS    Null

Application Table:

  • AppCliSecret    Character (120) NLS    
  • New         AppCliAllowRemoteAuth    Boolean    Null
  • New         AppCliAllowGetUserRoles    Boolean    Null
  • New         AppCliAllowGetUserAdditionalDa    Boolean    Null
  • New         AppCliLocalLoginURL    Varchar (1024) NLS    

The reorganization script is called ReorganizationScript305To306.txt and is located under "<GX>\Library\GAM\Platforms\Net<DBMS>"

About GAM deploy Tool and GAM database 3.0.6 

The GAM - Deploy Tool has the "Update GAM Schema" option, which enables the database update to its latest version.

When importing data into a 3.0.5 database that has been exported from a 3.0.6 database, the user will be warned regarding a reorganization of the database tables.

Data exported from a 3.0.6 database may not be imported into a 3.0.5 database.

Compatibility Note:

Applications generated with versions prior to GeneXus Evolution 3 may use the GAM Database 3.0.6 (only when GAMRemote Authentication Type is not used). See SAC 35625.

Last update: November 2023 | © GeneXus. All rights reserved. GeneXus Powered by Globant