Uploading Entitlements from CSV

[mirani]

Hello,

I am trying to create new entitlements by uploading csv using Upload Entitlement from CSV option in Entitlements tab.
But I am getting this error:
"Ambiguous method overloading for method [Ljava.lang.String;#getAt. Cannot resolve which method to invoke for [null] due to overlapping prototypes between: [interface groovy.lang.Range] [interface java.util.Collection]"
This is the first time I have got this error while uploading entitlements.

securitysystem

endpoint

entitlement type

entitlement value

entitlement owner

Owner Rank

status

This is the header of the file, which are followed by its respective value.
I have also attached the screenshot of the options selected while uploading the csv.
What may cause this error and how to resolve this?

[rushikeshvartak]

Share file 

[mirani]

The file contains client information and therefore I would share the file directly(direct message).

[rushikeshvartak]

try below format 

SECURITY SYSTEM	ENDPOINT	ENTITLEMENTTYPE	ENTITLEMENT_VALUE	ENTITLEMENT OWNER	OWNER RANK	customproperty4	customproperty5	description	sox critical
Digicert CertCentral Enterprise	Digicert CertCentral Enterprise	Groups	Limited User	72571	1	Non-Privileged	VL	Access to place and manage their own orders, with changes being approved by a manager or administrator.	High

[mirani]

I have shared you the file and it contains the same format!

[rushikeshvartak]

In your file last line is extra remove it (blank line)

[mirani]

I tried and even confirmed by checking for any blanks, there are no blanks, still got the same error.
I made the file again from scratch and manually entered only the top 4 rows (one header and other 3 as values), still got the same error.

[rushikeshvartak]

• Is it working for any other endpoint ?
• it was working before?

[mirani]

Yes, only this file is giving the error.
For rest other endpoints and other csv's (same format, values different) it's working.

[rushikeshvartak · Accepted solution]

Avoid special characters in Endpoint and security system name - Remove & from security system name

[Manu269 · Accepted solution]

@mirani try using attached file.

It should be working

[mirani]

Okay so it is working now, still don't know what the exact issue was but have created the file again from scratch. Maybe the issue was with the file, but the format was same as of the previous file. All the entitlements were uploaded and are mapped correctly.