Existing Service Providers in WSO2 IS 5.0.0 are not displayed in WSO2 IS 5.2.0 after upgrade
<p>I recently updated my environment from WSO2 IS 5.0.0 to WSO2 IS 5.2.0. My environment consists of 2 machines that are creating a cluster (using the WKA membership scheme and Load Balancer(AWS ELB) with sticky session enabled). I am using MySQL(not the default H2 database). The machines on which the IS is deployed are Windows Server 2012 R2 (EC2 AWS machines). </p>

<p>When I logged in the system through the admin console I noticed the already existing service providers are not displayed. I double checked the roles of the admin user and it had all the roles associated with the existing service providers and still I was not able to see them. Then I opened the database and took a look in the IDN_OAUTH_CONSUMER_APPS and SP_APP and the service providers are there. I logged in the system again and tried to create service provider with name that already existed and receive correct error message.<br>
However If I try to perform for example password grant type using the ClientID and ClientSecret of some of the "hidden" (old) Service Providers I am able to receive valid access token.  </p>

<p>Is there a way to show these service providers? Is it related to some DB misconfiguration? I observed the behavior after the upgrade. This is causing me some troubles because in order to update the Claim configuration for some of these existing and "hidden" Service Providers I need to manually update the SP_CLAIM_MAPPING which is not a good practice at all, but this is my only workaround for now.  </p>

<p>Thanks in advance</p>