Authentication Manager Bulk Admin (AMBA) script fails to run with “Invalid header field name” error
Originally Published: 2023-10-04
Last Modified: 2023-10-05
Article Number
Applies To
RSA Product/Service Type: Authentication Manager, Authentication Manager Bulk Admin, AMBA
RSA Version/Condition: 8.x
Issue
rsaadmin@am87-1:/opt/rsa/am/amba> more logfile.log
BOJ : 2023-10-03 19:27:22 - 8.7.1.0.0 (1433590) - Input = input.csv
Error : 2023-10-03 19:27:22 : Line -Invalid header field name:
Info : -Exit code: 1
EOJ : 2023-10-03 19:27:22 - Terminating
Note that it does not call out the line number. The header row appears fine when viewed in Excel. Customers have reported that this error does not occur if the file is less than 4000 lines, but longer versions will generate this error.
Cause
Action,TokSerial,Operation,AttributeName,AttributeValue,,,,,,,,,,
CTA,123456789,Add,EITS Asset Tag Number,P123456,,,,,,,,,,
CTA,123456790,Add,EITS Asset Tag Number,P123457,,,,,,,,,,
CTA,123456791,Add,EITS Asset Tag Number,P123458,,,,,,,,,,
CTA,123456792,Add,EITS Asset Tag Number,P123459,,,,,,,,,,
Note there are ten commas at the end of every line. Excel is very bad about leaving remnants behind when you delete data from columns in CSV files. This is where these extra commas come from.
Resolution
- Open the CSV file in Notepad or Notepad++.
- Type Ctrl+H to bring up the Replace menu.
- In the Find field, put in the same number of commas as in the CSV file, and leave the Replace field blank:
- Click Replace All to delete all the trailing commas from your CSV file.
- Save the file and use it to replace the original file on the Primary.
- Open the CSV file on the Primary using vi or vim, and then run the following command:
%s/,,,,,,,,,,//g
- Save the file with [ESC]:wq! to keep the changes.
Workaround
Notes
Related Articles
Group owner approval is getting assigned to wrong owner in RSA Identity Governance & Lifecycle 42Number of Views "Unknown action field" failure while running AMBA Actions 27Number of Views RSA Identity Governance and Lifecycle error "The selected file does not match the required CSV format" when importing Loca… 81Number of Views "Permission denied" or "does not exist or is not a valid file" exporting/importing an RSA Identity Governance & Lifecycle … 94Number of Views Install SC and Grid Worker on a different drive (Not the C: drive) 40Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?