Page created: 25 Mar 2020
|
Page updated: 15 Jul 2020
Since PingFederate 7.1 R3, two indexes have been added to the pingfederate_access_grant table.
| PingFederate version | Column | Index |
|---|---|---|
| 7.3 |
expires
|
EXPIRESIDX
|
| 7.1 R3 |
client_id
|
CLIENTIDIDX
|
If you are upgrading from PingFederate 6.5 through 7.1.4, you must add both indexes to your existing pingfederate_access_grant table.
If you are upgrading from PingFederate 7.1 R3, 7.2.x, or 7.2 R2, you must add the
EXPIRESIDX index for the expires column.
While there is no alter-table script provided, you can derive the setup from the new table-setup scripts,<pf_install>/pingfederate/server/default/conf/access-grant/sql-scripts/access-grant-<databaseServer>.sql.