CMS Snapshot Analysis - Run Analyzer - Warnings - PeopleSoft with extension - End of string not found file skipped

Purpose (problem description)

This page helps you to troubleshoot the problem where files are skipped from being analysed accompanied with the below warning -

end of String ’’’ not found
File skipped : <File_full_path>

Example -

Observed in CAST AIP

Observed on RDBMS

Step by Step scenario

1. Run Peoplesoft analysis
2. Open the analysis log file to find warnings. Refer to page CAST Management Studio - Information - How to find logs

Action Plan

Perform the below actions:

1. Check if the source code is an incomplete SQL statement . For any UA, if a string is started but we don’t find the end in the file, then the corresponding source code is ignored.
   1. Open one .src file which is skipped. For instance in our example it is EX_PE_PRED_DVW.src and check if the string is starting and ending correctly with ‘
   2. We can see below that the Select statement is not complete
      
   3. When a string pattern is not found inside an object’s source code, an error is raised as the analyzer can’t understand the syntax.For PeopleSoft - for SQL objects, they can contain a sub-part of an SQL statement that can be re-used in other objects. We don’t specify in the documentation that an SQL object can be defined with a partial statement. The SQL should not be analyzed individually but it should be analyzed in the context where it is included. It’s a limitation of the current package.
2. If the source code is something different then contact CAST Technical Support with Relevant input.
   For CAST Technical support only - Issue will be reproduced using the page - CMS Snapshot Analysis - Run Analyzer - Information - How to reproduce user issues for Extension

Relevant input

1. CAST Support Tool (CST) - alias Sherlock with options Export CAST Databases and Export logs checked
2. Source code of the file that is skipped , corresponding .uax file and .uaxdirectory file.

Notes/comments

Related Pages