Error while Logging in using certificate in USS while attempting login USS GUI

Document ID : KB000098379
Last Modified Date : 29/05/2018
Show Technical Document Details
Issue:
We  installed USS 17.1 on a clean box against  14.1 USS and MDB , but after upgrading to 17.1 , we cannot login USS GUI anymore and in liferay log , we saw the following error messages :
liferay.log : 
---------------- 
... 
14:22:50,944 ERROR [ServiceMgmtClientServiceDeskImpl:82] Error while Logging in using certificate: F:\CA\Self Service\OSOP\shared\sdmcert\10154\DEFAULT.p12 (The system cannot find the path specified) 
14:22:50,944 ERROR [ServiceDeskUtil:82] Failed to login removing instance from Stack: null 
------------------
Environment:
Service Catalog 17.1 
Cause:
in USS_MDB ,  os_ExternalSource   and os_ExternalSourceProperties tables contains  USS and Service Desk integration  information ,  also USS and Service Catalog integration information .  In this kind of scenario ,   It can  manually clean up those information in existing os_ExternalSource   and os_ExternalSourceProperties tables  so that you can login USS GUI first .  and then after that ,  you can do actually USS and Service Desk or USS and Service Catalog manually and correctly  via USS GUI  based on your env .  
Resolution:
 
1. make a backup copy of  os_ExternalSource  and os_ExternalSourceProperties tables first 
2.  do the query :
      select * from os_ExternalSource sourceName='SDM' or sourceName='CATALOG' 

     get the sourceId  for SDM and Catalog from the query above 

3.  then do the following query :
       select * from os_ExternalSourceProperties sourceId=<sourceId of SDM> or sourceId=<sourceId of catalog> 

4.  then go ahead to delete those related entries in both tables :
         delete from from os_ExternalSourceProperties sourceId=<sourceId of SDM> or sourceId=<sourceId of catalog> 
         delete from from os_ExternalSource sourceName='SDM' or sourceName='CATALOG' 


5.  recycle USS service 

6.  attempt to login USS GUI ,  the error messages you saw previously liferay.log should be gone : 
---------------- 
... 
14:22:50,944 ERROR [ServiceMgmtClientServiceDeskImpl:82] Error while Logging in using certificate: F:\CA\Self Service\OSOP\shared\sdmcert\10154\DEFAULT.p12 (The system cannot find the path specified) 
14:22:50,944 ERROR [ServiceDeskUtil:82] Failed to login removing instance from Stack: null 
------------------