CxSAST Troubleshooting & FAQ

There is no per-user log file, but you can track any user's CxSAST activity by running a simple query on the database.

For example, using SQL Server Management Studio, login to the database and go to CxActivityDB > Tables > dbo.Audit_Logins. Run a query to find the relevant user.

To upgrade your SQL Server from the Express edition to the Standard/Enterprise edition, see SQL Server documentation.

Server log locations are listed here.

In order to check the configuration for the SQL Database, open the following file for editing: 

<Checkmarx Installation Folder>\Configuration\DBConnectionData.config

In this file, in <SystemConnectionStrings> you will find two connection strings for the two Checkmarx CxSAST Databases: CxDB & CxActivity

In each connection string, you will find the following information:

• Data Source: SQL Server named instance
• Initial Catalog: Name of the database
• Integrated Security: Authentication method to SQL Server (true = windows authentication; false = SQL authentication).

When using SQL Authentication, two parameters should be added:

• User ID
• Password

Source code languages and file extensions supported for CxSAST scans are listed here.

Using CxAudit, create a query override and change its Severity.

Check the last generated log at: <Checkmarx Installation Folder>\Logs\CxlXXXX.log to check your license validity.

• Check if service log-on user is an administrator on the server.
• Port 80 might be occupied by other program (E.G - Skype) - follow instructions in https://checkmarx.atlassian.net/wiki/display/KC/Configuring+CxSuite... 

Check if service 'log-on user' is an administrator on the server.

Check that the SQL server holding the Cx Databases is up and running and please check that the <Checkmarx Installation Folder>\Configuration\DBConnectionData.config file contains the correct configuration for DB connection. 

Restart Cx Services and Web Server (IIS or UltiDev).

Check that the IIS Application Pools and Default Web Site are up and running.

• Check that all Cx system prerequisites for IIS web server components are installed.
• In IIS, go to default web site and click Authentication, then check that "Anonymous Authentication" is enabled.
• Check if application pool named "CxPool" is up and running.
• Open <Checkmarx_installation_Folder>\CheckmarxWebPortal\Web\web.config and check that the URI which is configured for the "CxWSResolver.CxWSResolver" key is correct. To verify it is configured correctly, browse to the URI from a web browser. You should see a web-service screen.

The default port (80) is busy and configuration change is needed.

If CxManager server and the SQL server hosting Cx Databases are different servers, check the date and time configuration for both servers - the configuration should be identical.