Running "udatacnv.sqr" report

Each of the upgrade data conversion sections contains comments that describe the processing performed by the section. 

PeopleSoft has delivered an SQR to list all of these comments by the group and sequence numbers that determine how they run. The name of this report is UDATACNV.
To run UDATACNV:
1. Using SQRW, run SQR UDATACNV on your Copy of Production database.
2. When prompted for Upgrade Path, enter:
3. When prompted for Group Number, enter the two-digit group number to report on, or enter 0 to see the comments for all groups.


You can get the Upgrade Path and Group Number using the below sequel statements:

SELECT DISTINCT UPG_PATH  FROM PS_UPG_DATACONV ORDER BY 1

SELECT * FROM PS_UPG_DATACONV ORDER BY 1

Integration Gateway - External System Contact Error (158,10721)

Users were unable to access the "Find Learning" Page in ELM 9.2 application:

Integration Gateway - External System Contact Error (158,10721)

Integration Gateway was not able to contact the external system.  The network location specified may be incorrect, or the site is permanently or temporarily down

Integration Broker encountered an error (262,1020) PT_SEARCH.SESIMPL.MESSAGE.SESRequest.OnExecute  Name:Send  PCPC:688  Statement:16
Called from:PT_SEARCH.SESIMPL.QueryService.OnExecute  Name:startSession  Statement:411
Called from:PT_SEARCH.SESIMPL.QueryService.OnExecute  Name:doService  Statement:434
Called from:PT_SEARCH.SESIMPL.QueryService.OnExecute  Name:ExecuteQuery  Statement:47
Called from:PT_SEARCH.SESIMPL.Query.OnExecute  Name:Execute  Statement:39
Called from:LM_SEARCH.SESSearch.OnExecute  Name:GetResults  Statement:403
Called from:LM_SEAR

Integration Broker encountered an error

Solution:

 Very first thing is to validate the SES configuration under Main Menu> PeopleTools>Search Framework>Administration>Search Instance

Click on Search button and perform all the tests under "Search Instance Properties". All should give a status as SUCCESS.

In my case none of the tests related to SES are working. Bounced the SES services and then the  as bellow:

1. Login with admin user to the server were you configured SES.
2.cd /data/Oracle/product/11.1.2.2.0/ses/seshome/wlserver/seshome/bin
3../searchctl stopall
It will take sometime to stop the services of Database tier and Middle tier. Once it is done you start the services back using the below command.
4../searchctl startall
5. Validated and able to access the "Find Learning" page successfully.

Note: This has resolved my issue but we required to check the other areas related to Integration Broker setup because you may face this issue even if the Ping Gateway is not working.