Duplicate Entry Not Allowed Error

Rhinoville,

Can you share a screenshot?

Where does it come from?

Thanks

This happens when I try to add a new firewall from the Discover Button on the top of the screen

Thanks.

So you are talking about sfm/scfm. What version are you using?

SFM Version

Thanks for your info.

I guess it is a bug. RaviPatel can help you on this.

Regards

Hi Rhinoville,

Can you email me (ravi.b.patel@sophos.com) error screenshot while you try to add the XG?

Is XG serial number in UPPER case or LOWER case?

Have you migrated SFM Beta version from which SFM version ?

Please email me SFM admin credential with GUI and SSH access, so i can look into issue and provide you resolution based on finding.

Ravi

i have the samen problem. it should be fixed in version 16.05 or something, but i am at version 17 it still happens.

exactly same problem as above. anyone solved this?

Hi RaviPatel

I have the same issue with SFM (ver 17.0.0GA) . How to fix it ?

Thank you

Hi Dylan,

Issue will be fixed in SFM v17.1 GA version. 

PM me the output of below  db queries from advanse shell of SFM.

1. Connect the DB using below command

psql -U nobody -d ccc -p 5433

2. Run the below command and provide output of below queries. 

select * from tblappliance;

select * from act1.tblcccuserappliancemapping ;

Please also provide the serial number for which you are getting  "Duplicate Entry Not Allowed Error" error.

Ravi

Hi Gecko,

Issue will be fixed in SFM v17.1 GA version. 

PM me the output of below  db queries from advanse shell of SFM.

1. Connect the DB using below command

psql -U nobody -d ccc -p 5433

2. Run the below command and provide output of below queries. 

select * from tblappliance;

select * from act1.tblcccuserappliancemapping ;

Please also provide the serial number for which you are getting  "Duplicate Entry Not Allowed Error" error.

Ravi

Hi RaviPatel

Pls view the attach file for output => just 1 device at this time stuck at duplicate status.

I have another issue with SFM when add device to SFM:

- The column Sync & Conn is grey and notice is "Incompatible" and have the log event like below:

=> the issue I can add device to SFM but cannot sync, I have try with 2 HA pair device and have the same error.

=> the version of SophosXG is SFOS 17.0.8-MR8

1234.SFM-output.txt

Hi Gecko,

Issue still there in SFM v17.0 GA release.

Issue will be fixed in SFM v17.1 GA version. 

PM (message) me the output of below  db queries from advanse shell of SFM.

1. Connect the DB using below command

psql -U nobody -d ccc -p 5433

2. Run the below command and provide output of below queries. 

select * from tblappliance;

select * from act1.tblcccuserappliancemapping ;

Please also provide the serial number for which you are getting  "Duplicate Entry Not Allowed Error" error.

Ravi

Hi Gecko,

Issue still there in SFM v17.0 GA release.

Issue will be fixed in SFM v17.1 GA version. 

PM (message) me the output of below  db queries from advanse shell of SFM.

1. Connect the DB using below command

psql -U nobody -d ccc -p 5433

2. Run the below command and provide output of below queries. 

select * from tblappliance;

select * from act1.tblcccuserappliancemapping ;

Please also provide the serial number for which you are getting  "Duplicate Entry Not Allowed Error" error.

Ravi

I'm having a similar problem, any idea on when SFM17.1 GA will be released?