Symptom
System table doesn’t seem to update in new URL
System table: ‘federationparams’ column: ‘value’ produces the old redirect URL.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
This can be reproduced by running
list =SqlHelper.GetList("SELECT * FROM FederationParams
") in the script work bench.
Cause
FederationParams is obsolete federation table and not used by federation anymore.
Resolution
FederationParams is obsolete federation table and not used by federation anymore.
The new table is sys_federationsettings.
However, it is not recommended to use system tables because they can change.
If the client needs service provider route in scripting they can use: FederationUtility.GetFederationUrlSegment(identityProviderName )
to recreate the route.
This is example how to recreate Service Provider Route in scripting:
url = 'https://' + RequestContext.Url.Host + '/fed/' + FederationUtility.GetFederationUrlSegment('identityProviderName')
Keywords
FederationParams, sys_federationsettings, Redirecting to old URL, system table, federation table , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem