*Purpose

This page will help you solve problems related to the run reference pattern.


For more information, refer to:

*Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
*Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
Action Plan
  1. Run the Reference Finder by command line. This would help to solve the issue:

    1. Open the CAST-MS log file.

    2. Search for the last entry starting Task Run Reference Finder Analyzers.

      INF: 2018-03-09 18:25:38: starting Task Run Reference Finder Analyzers "RP_DATABASE_64978"
      INF: 2018-03-09 18:25:38: Q:\8.1.4_Build1506_flat_for_customer/anarun.exe -CONNECT_PROFILE('supcssux1:2280 on CastStorageService.l814_11050_mts_1') -RUN_RP(100155801,100306251,'C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\LISA\3cba398a440c414297c6affac3b40137\Scr64978\JobSettings.xml') -MANAGED(100155801) -SESSION_ID(100306251) -LOG('C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\3cba398a440c414297c6affac3b40137\RP_DATABASE_64978-20180309182533.castlog',TRUNCATE) -LARGESTORAGE('C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1','C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1','3cba398a440c414297c6affac3b40137/Scr64978') -LOGIN(,CASTCORP\MTS,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT
      INF: 2018-03-09 18:25:43: Loading ini file: C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\AMRunResult100306251.INI
      WRN: 2018-03-09 18:25:43: Ini file not found: C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\AMRunResult100306251.INI
      ERR: 2018-03-09 18:25:43: The analysis failed to connect to database (Error code 1).
       Please see the analysis log for further details
       Execution log C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\3cba398a440c414297c6affac3b40137\RP_DATABASE_64978-20180309182533.castlog
       com.castsoftware.java.ExternalException:The analysis failed to connect to database (Error code 1).

       In the above example, the Error message is: ERR: 2018-03-09 18:25:43: The analysis failed to connect to database (Error code 1).

    3. Copy the command line, that is just under starting Task Run Reference Finder Analyzers where anarun.exe is executed. In the above example this is:

      Q:\8.1.4_Build1506_flat_for_customer/anarun.exe -CONNECT_PROFILE('supcssux1:2280 on CastStorageService.l814_11050_mts_1') -RUN_RP(100155801,100306251,'C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\LISA\3cba398a440c414297c6affac3b40137\Scr64978\JobSettings.xml') -MANAGED(100155801) -SESSION_ID(100306251) -LOG('C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\3cba398a440c414297c6affac3b40137\RP_DATABASE_64978-20180309182533.castlog',TRUNCATE) -LARGESTORAGE('C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1','C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1','3cba398a440c414297c6affac3b40137/Scr64978') -LOGIN(,CASTCORP\MTS,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT
      Open a windows command line, paste the command and execute it:


       

    4. Open the log created by the above command line in:

      C:\Users\MTS\AppData\Local\Temp\CAST\CAST\8.1\3cba398a440c414297c6affac3b40137\RP_DATABASE_64978-20180309182533.castlog
    5. If you can see at the end of the reference pattern log, entries confirming that the execution has finished successfully as shown in the below example, the issue is resolved.

      2018-03-12 10:45:47.133670 Information; Job execution Execution result=success
      2018-03-12 10:45:47.133670 Information ; Job execution Analysis completed 
      2018-03-12 10:45:49.320937 Information ; Job execution 0 fatal error(s); 0 error(s); 0 warning(s); 41 information message(s).
    6. If other Reference Pattern dependencies still remain to be executed:
      1. In CAST MS, in the Dependencies tab select all the Reference Pattern dependencies that did not run yet and execute them:
        1. Check which are the Reference pattern dependencies that have run successfully:
          1. Open the CAST-MS log file
          2. Search for the lines ending Task Run Reference Finder Analyzers <Name of the Reference Pattern> not preceded by Error messages.
          3. The name of the Reference Pattern you have previously run by command line will not be executed again.
          4. Select all the other Reference Pattern dependencies except the one that has previously been executed by command line.
          5. Right click and select Run reference pattern on dependency.
  2. If the Run Reference Finder command line is failing with the same error:
    1. Run the check reference pattern dependency result by command line. It is the same command line for the run reference pattern but with 2 additional parameters. Copy the command line you have previously run, add the two following parameters : -NOKBSAVE -PROBE just before the last parameter -EXIT, as shown in the below screenshot. In the new command line, change the name of the log file:
  3. Retrieve the Reference pattern dependency log file that will contain additional traces (it is an improvement that exists since the CAST AIP 8.2.3) that could explain the reason why the issue is occurring.
  4. If the additional traces in the log do not help to solve the issue, the workaround is to use the Custom Reference Finder
  5. If the above points do not help you, contact CAST Technical Support and provide the Relevant Input for Cast Technical Support to reproduce the issue.

Relevant Input

  1. Sherlock (CAST Support Tool (CST) - alias Sherlock). The option to select are : Export source code, Export database dumps, Export log file, Export configuration file (The Web layer folder that are in the LISA are requested to reproduce the issue and to investigate)
  2. In case you cannot provide the source code of the whole application, provide one source code for Source set and one source code for Target.
  3. Screenshots of the issue.
Notes/comments


Related Pages