000032724 - RSA ECAT 4.1.x scan4 files not processed into SQL Database

Document created by RSA Customer Support Employee on Sep 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000032724
Applies ToRSA Product Set: ECAT
RSA Product/Service Type: ECAT
RSA Version/Condition: 4.1.x
 
Issuescan4 files in QueuedData folder (default location C:\ECAT\Server\QueuedData) do not get processed into SQL Database due to the following error.
Error : Category(2), Merging Cannot insert the value NULL into column 'LocalIp', table 'ECAT$PRIMARY.dbo.Machines'; 
column does not allow nulls. UPDATE fails.


Run the following SQL query in SQL Server Management Studio, it returns the output with error as shown in the picture below.
 
***************
    SELECT TOP(50)  
        [as].[FileName]  
      , [ab].[PK_AgentBatches] -- A batch is a group of files for 1 scan  
      , [ab].[BatchTimeStamp]  
      , [ab].[MergeAttempt]  
      , [ab].[Processed]  
      , [ab].[ErrorMessage]  
    FROM [dbo].[AgentScans] AS [as] WITH(NOLOCK)  
    LEFT JOIN [dbo].[AgentBatches] AS [ab] WITH(NOLOCK)  
        ON [as].[BatchTimeStamp] = [ab].BatchTimeStamp  
    ORDER BY [ab].BatchTimeStamp DESC
***************


User-added image
 
CauseNetwork settings missing on ECAT agent machine.
# Example of Good scan4 file, it contains network settings :
1     0     9     1     Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz  9600  0     Microsoft Windows Server 2012 R2 Standard   
C:\Windows  12884430848 1     VMware, Inc.      VMware Virtual Platform  VMware-56 4d c4 b4 7b fc 28 7f-4d 53 cb 31 46 b5 22 9c   
Phoenix Technologies LTD - 6.00 - PhoenixBIOS 4.0 Release 6.0 00000000-0000-0000-0000-000000000000     
Administrator                       00000000-0000-0000-0000-000000000000      ECATTEST                  WORKGROUP   2     0    
00:0C:29:B5:22:9C    192.168.10.10     192.168.10.1    192.168.10.5     3081  AUS   AUS Eastern Standard Time     0     1      0  
   0     0     0     0     0     1     0     0     0     0     0     0     0     0      0     0     0     0     0     1

# Example of Bad scan4 file, network settings are missed :
1     0     9     1     Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz  9600  0     Microsoft Windows Server 2012 R2 Standard  
C:\Windows  12884430848 1     VMware, Inc.      VMware Virtual Platform  VMware-56 4d c4 b4 7b fc 28 7f-4d 53 cb 31 46 b5 22 9c   
Phoenix Technologies LTD - 6.00 - PhoenixBIOS 4.0 Release 6.0 00000000-0000-0000-0000-000000000000     
Administrator                       00000000-0000-0000-0000-000000000000      ECATTEST                  WORKGROUP   2     0    
                                                                           3081  AUS   AUS Eastern Standard Time     0     1   
   0     0     0     0     0     0     1     0     0     0     0     0     0     0     0      0     0     0     0     0     1
ResolutionFix : ECAT 4.2
Workaround: Use dummy network settings.
 

Attachments

    Outcomes