Exception while importing Control Compliance Suite Vulnerability Manager (CCSVM) 10 assets in CCSVM 12

Products

• Control Compliance Suite Vulnerability Manager

Issue/Introduction

You have generated a report / export in CCSVM 10 (Nexpose) to be imported in the CCSVM 12.

An error has occurred in ImportCSV: Exception: An error has occurred in saveRecordsToDatabase.
 Exception: System.Exception: An error has occurred in runTPCImports.
 Exception: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

Cause

Timeout in SQL session

Resolution

To help with time out you need to change the SQL connect timeout settings:

Open the Symantec CCS-VM Configuration tool then go to the Dataase information section.

Change the following settings (default is 300)

Command Timeout -> 1500

Connection Timout -> 1500