1 Topic by gwilkinson15

  • gwilkinson15
  • Member
  • Offline
  • Registered: 14-02-2023
  • Posts: 12

Topic: Unable to delete a temporary survey using the Batch Updates (Del 5)

Unable to batch delete a temporary survey; an error message states: "There is an error in the SQL code. The DELETE statement conflicted with the REFERENCE constraint 'FK_TAXON_PRIVATE_DATA_OCCURRENCE'." The conflict occurred in database "NBNData", table "dbo.Taxon.Private_Data", column 'Taxon_Occurrence_Key"

Any suggestions to resolve this?

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,650

Re: Unable to delete a temporary survey using the Batch Updates (Del 5)

Hi

Attached is a revised Del5 Batch Update which should resolve this issue. See FAQ at  https://forums.nbn.org.uk/viewtopic.php?id=6266 for installing the revised file.

Post's attachments

JNCCDel5Records.xml 30.05 kb, 3 downloads since 2025-05-30 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

3 Reply by gwilkinson15

  • gwilkinson15
  • Member
  • Offline
  • Registered: 14-02-2023
  • Posts: 12

Re: Unable to delete a temporary survey using the Batch Updates (Del 5)

Thank you Mike, this has worked.

Regards