Source Extractor - PeopleSoft - Extraction Step - Performance issue

This page covers performance issues you may face during PeopleSoft Extraction.

See the following page to locate the log files and to examine them for any error:  CAST Management Studio - Information - How to find logs

Documentation for the PeopleSoft extension can be found here:  PeopleSoft

Step by Step scenario

1. Run the PeopleSoft Extraction.
2. The Extraction is running without ending after ages.
   

1. Open the Extraction log file.
2. Identify the type of objects for which the extraction has performance issues :
   1. If the extraction has not ended, the type of object for which the performance issue occurs is the one appearing in the last line of the extraction log file, as below screenshot :
      
   2. If the extraction has ended, you must identify the type of object for which the gap between the start of the extraction object and the end is huge like below screenshot :
      
      
      
3. Once you have identified the type of object, edit with notepad++ the configuration file that is the PeopleSoft extension folder:
   
   
   
4. Search the query that is run to extract the object for which the performance issue occurs.
   
   In the above screenshot, the type of object is PeopleSoft Application Engine Action / SQL : default.
   In the Configuration file retrieve the query :
   
   
   
5. Copy the query and run it on the PeopleSoft schema being extracted :
   1. If the run is long, then the query must be improved by the product
   2. If the run is quick, then the performance issue may be due to network issues.
      
      
6. If the above steps do not solve your issue contact CAST Technical Support. with the following relevant input

Ticket # 10300