PingFederate version Column Index

7.3

expires

EXPIRESIDX

7.1 R3

client_id

CLIENTIDIDX
Note:

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.

Although 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.