Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 40 subscribers
  • Views 4226 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SFM: Duplicate Entry Not Allowed error

Dylan Prins

Hi,

 

i had a problem with one of my firewall nog syncing with sfm. i tried delete the firewall and add it again in sfm.

now i get the error: Duplicate Entry Not Allowed.

 

sfm version: SFMV15 (SFMOS 17.0.0 GA) 

firewall version: XG85 (SFOS 17.0.8 MR-8)



This thread was automatically locked due to age.
Parents
  • 0

    Please open a support case for this issue. 

    Support can clean up your database to resolve this issue. 

    __________________________________________________________________________________________________________________

  • 0 in reply to LuCar Toni

    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 or ticket id if you have created with Sophos Support. 

    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

Reply
  • 0 in reply to LuCar Toni

    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 or ticket id if you have created with Sophos Support. 

    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

Children
Unfiltered HTML