CMS Application - Execute - Performance issues - Review Dynamic Links

This page is about performance issues that may occur when reviewing dynamic links

1. The Review Dynamic links tool is running SQL queries. The performance issue may be due to bad database statistics. Run a CSSOptimize on the local database.
2. If optimizing the local schema does not resolve the issue, check if the issue is linked to one particular SQL query or is linked to DLM engine:
   1. Open the CAST-MS log file
   2. Search for the entry starting Task Launching Dynamic Link Manager.
   3. Retrieve the command line just below this entry as below screenshot shows it:
      
   4. Copy the command line.

   5. Add the option SHOW(SQL) and change the LOG file path. The command line, based on the above screenshot, will be like:

      "C:\SBO - CAST\Product\8.2.3 HF09/dlm.exe" -SHOW(SQL) -DATABASE(CASTStorageService) -CONNECT_STRING('LIBPQ:SBOW10LAP:2280,postgres','operator','CastAIP','cb823_sbonew_local') -LOG('C:\MyNewLogFileLocation\DLM4580455479125781438_CMS.castlog',USELOGFILE)

   6. This command will run the Review Dynamic Links and will generate the log file in the path you have defined. We will check if the issue is due to SQL query performance issue. Open the Log file:

      1. The log file will look like the below screenshot:
         
      2. The Dynamic Links Manager is supposed to open when the entry Procedure <YOUR_LOCAL_SCHEMA>.Keys_Unlock returns 0 appears in the log.
      3. Identify the longest query: there should be a gap between two lines, as below screenshot:
         
   7. If there is no longer query and if the entry Procedure <YOUR_LOCAL_SCHEMA>.Keys_Unlock returns 0 exists, the issue is linked to the DLM engine:
      1. Open the task manager
      2. Check for the process running the DLM as below screenshot:
         
      3. If there is no task, the DLM tool is may be corrupted. You need to reinstall CAST AIP
      4. If the memory is growing up, that means it is loading data
3. If the above points do not help you, contact CAST Technical Support with the relevant input

Ticket # 6847