Data Loader Error Messages and Troubleshooting

This section provides solutions to common errors and issues that you may encounter.

Error Messages

  • 111: Your IP address does not have access for token
    • Reason:

      The error is due to security settings in your Bronto account regarding API access from an unknown IP.

    • Action:

      Go to Settings > Platform Settings > Security Settings, check the box Allow API access from unknown IPs not defined in Network Access, and save the changes.

  • Parser halted on file.csv: line (xxx) invalid char between encapsulated token and delimiter
    • Reason:

      This means the CSV parser encountered an invalid format on the specific line number in the file, and stopped parsing the file for safety reasons. For comma delimiters, this most likely means that an embedded " character is within quoted columns.

    • Action:

      There are three possible fixes for this:

      • Change the file format to tab delimiters, and drop the surrounding quotes around the columns.
      • Escape the embedded quote by adding a " next to the embedded quote.
      • Escape the embedded quote by prepending a \ before the embedded quote.

Troubleshooting

  • Cannot Connect To Data Loader IP Address
    • Action:

      Ensure that you allowlist IP addresses in the range 216.27.63.0-24.