Troubleshooting
Problem
Users who export reference sets as CSV file, then attempt to open it in Microsoft Excel might see the error: 'Error 0x80070057: The parameter is incorrect' is displayed, which can be caused by a colon character (:) in the name of the reference set. Error 0x80070057 is not QRadar specific, but a Microsoft Excel error message due to how special characters are handled. Reopening the file after skipping the error message in Windows typically resolves this problem.
Cause
Excel has an issue opening a file when the file contains a colon (:) in the name.
Resolving The Problem
Administrators who experience this issue can Skip the error message generated by Microsoft Excel, then open their CSV file export. To recreate this error message or work around this Microsoft Excel error message, see the following procedure:
- Log in to the QRadar UI
- Click the Admin page.
- Click Reference Set Management.
- Highlight a Reference set with a colon (:) in its name.
- Click View Contents.
- Click Export.
- Navigate to where the zip file downloaded in Windows explorer
- Right-click the zip file.
- Click Extract All > Extract
- The error message Error 0x80070057: The parameter is incorrect is displayed.
- Select Skip to bypass the error message.
- Double-click on the CSV file to open the reference data export.
Results
After skipping the error message, the CSV file will open properly in Microsoft Excel.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"Component":"WinCollect","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All versions","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
14 August 2020
UID
ibm10885338