1 Reply by reprice

  • reprice
  • Member
  • Offline
  • From: HBRC
  • Registered: 17-08-2007
  • Posts: 12

Re: Records Import

Has anyone come across this Import Reject message before when importing records? Is it something we need to deal with as the records seem to have imported fine or does it relate to restricting the surveys that data enterers can see and therefore is not relevant in the database the records are being imported to?

Items rejected by Recorder 6 in data imported at 12-22-45 on 15/03/2011:

Failed to insert SR000291000000AJ into User_Survey_Restriction
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_USER_SURVEY_RESTRICTION_USER". The conflict occurred in database "NBNData", table "dbo.USER", column 'NAME_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
--------------------

Failed to insert SR000291000000BE into User_Survey_Restriction
Database Error Message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_USER_SURVEY_RESTRICTION_USER". The conflict occurred in database "NBNData", table "dbo.USER", column 'NAME_KEY'.(-2147217873) The statement has been terminated.(-2147217873)
--------------------

Any comments welcome!

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Records Import

This sounds like another thing that is being included in exports in error. Survey tags are another when transferring custody – see http://forums.nbn.org.uk/viewtopic.php?pid=7651#p7651. Users are system specific and so shouldn’t be transferred from copy to copy, nor should User_Survey_Restriction. If these are the only rejects you are getting, I think all will be well, but I suggest doing some checks to ensure that everything else has gone in although it sounds as though you have done that.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687