SAP Knowledge Base Article - Public

3352703 - System Table: 'federationParams' Column: 'Value' produces the old redirect URL

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

Product

SAP CPQ 2020