CMS Snapshot Analysis - Run Data Flow Security Analysis - Save results to database

This page is a guide to troubleshoot any problems you may encounter during CMS Snapshot analysis - Run Dataflow Security Analysis, Save Results to database sub step.

During this step the BuildAgent.datatransfer file which is the output of a J2EE or .NET data flow has been created and process XMLTODB.exe which is found in CAIP installation folder is called in order to transfer the results to the local database

For more information, refer to:

• Official 8.3 Documentation - User Input Security and Application - Security Dataflow
  

1. Check in CMS/AIP console log if the XMLTODB process has been called or the issue occurs before. Check for information message like the following:
   INF: 2021-11-24 21:49:23: D:\CAST\8.3/XMLTODB.exe /f:E:\CAST\LSA\LISA\24c70a7923f241db942e6ae12868d9c7\Scrde08301bc69b444f80918a87f4807804\BuildAgent.datatransfer /c:D:\CAST\8.3\InstallScripts\Common\APPW\table_appw.xml 
   1. If the information message does not exist, then
      1. If you have error message like the following:
         User Input Data Flow Security analysis working file is missing for the application XXXX
         please follow CMS Snapshot analysis - Run Data Flow Security Analysis - Save Results to Database - Error - User Input Data Flow Security analysis working file is missing
      2. Else go to last step in this guide
   2. If the information message exists then it means that the process responsible for the transfer of the results to the local database has been launched. Check known issues CMS Snapshot analysis - Run Data Flow Security Analysis - Save Results to Database - Fatal Error - XMLtoDB Transfer failed with message - XML data or another error occurred while reading file BuildAgent datatransfer
2. If you do not find the information you are looking for or solution for your problem, on this page, contact CAST Technical Support  with the following Relevant input.

Relevant input

• CAST Support Tool (CST) - alias Sherlock Export with options Export Logs and Export Databases (Management Base and Knowledge Base only)
• LISA folder