# "api stats -calc\_avg\_duration" command fails with IndexError on Security Management Server

**Product**: Security Management  
**Version**: R81.20, R82, R82.10  
**OS**: Gaia  
**Last Modified**: 2026-07-23

## Symptoms

- Running the "`api stats`" command with the "`-calc_avg_duration`" flag on the Security Management server fails with error:

```
    IndexError: list index out of range
    ```

- The error occurs specifically when requesting statistics in text format, for example:

```
    api stats -from_date ... -to_date ... -calc_avg_duration -f text
    ```

- Other subcommands of the "`api stats`" command work as expected.
- Replacing script files or removing the _$FWDIR/log/api.csv_ file does not resolve the issue.

## Cause

An issue with the Security Management Server API statistics parser handling certain User-Agent strings (e.g., Apache-HttpClient/4.5.13 (Java/1.8.0\_372)).  
This results in malformed entries in the _$FWDIR/log/api.csv_ and its rotated files, where the expected number of columns is not met. When the "`-calc_avg_duration`" flag is used, the script attempts to access a non-existent list index, causing an `IndexError`.

## Solution

This problem was fixed. The fix is included in:

- [Jumbo Hotfix Accumulator for R82.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R82.10/Default.htm) starting from Take 36
- [Jumbo Hotfix Accumulator for R82](https://sc1.checkpoint.com/documents/Jumbo_HFA/R82/Default.htm) starting from Take 118
- [Jumbo Hotfix Accumulator for R81.20](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.20/Default.htm) starting from Take 158

If you choose not to upgrade, Check Point can supply a **Hotfix**. [Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue.

A Support Engineer will make sure the Hotfix is compatible with your environment before providing the Hotfix.

For faster resolution and verification, please collect [CPinfo files](http://supportcontent.checkpoint.com/solutions?id=sk92739) from the Security Management Server and Security Gateways involved in the case.

**Hotfix installation instructions:**

Refer to [sk168597 - How to install a Hotfix](https://support.checkpoint.com/results/sk/sk168597).

### Workaround

Remove Malformed Entries:

**Note**: Editing these files may impact system behavior. Always back up before making changes.

1. Edit the file: _$FWDIR/log/api.csv_.  
2. Remove all lines with malformed User-Agent strings (e.g., missing closing quotes or brackets).  
3. Repeat this step for all rotated files: _$FWDIR/log/api.csv.1_, _$FWDIR/log/api.csv.2_, etc.  
4. Restart the API service with the command "`api restart`" to apply the changes.

**Note:** Editing these files may impact system behavior. Back up before making changes.

**Verification**

1. After applying the workaround or hotfix, run this command to make sure that the error no longer occurs:

```
    api stats -from_date ... -to_date ... -calc_avg_duration -f text
    ```
2. Confirm that the command completes successfully and returns the expected statistics.

#### NOTE
This solution has been verified for the specific scenario, described by the combination of Product, Version and Symptoms. It may not work in other scenarios.