When importing application mappings from CSV I get "Object reference not set to an instance of an object."

Document ID : KB000100631
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
When importing Application Mappings into NFA from CSV using the "racmd -import" utility I get "Object reference not set to an instance of an object."
Environment:
NFA All Versions
Cause:
Using improper formatting of CSV templates.
Resolution:
You must format the csv file as documented in the link below:
https://docops.ca.com/ca-network-flow-analysis/9-3-8/en/managing/report-customizations/set-up-application-mapping/import-application-mapping-rules

There are five template files you can follow in the \CA\NFA\Reporter\racmd directory depening on the type of Application Mapping Rules you wish to import:
  • All (ToS) rule - tos.csv
  • Host rule with a specified protocol - server-protocol.csv
  • Host rule without a specified protocol - server.csv
  • Subnet rule - subnet.csv
  • NBAR2 rule - nbar2.csv
The NBAR2 file is prepoulated with a list of NBAR2 definitions which we provide for you, but you can add to that or edit them as needed.

Some things to watch for when getting this error:
  • Ensure your column names match up with the template files.
  • Ensure columns are in the same order order as template files.
  • When trying to select ALL protocols or ALL ToS values use "-1" instead of typing ALL.
  • When entering TCP or UDP, make sure they are capitalized. 
  • If using multiple ports in the beginPort column, separate them by commas,