Duplicate records being displayed while running the table in NAV 2015

Answers

• Options

  kine Member Posts: 12,562

  2015-10-21

  Check if the primary key is correctly defined. I expect that you see more in the NAV than in the SQL. Do not forget that NAV Service tier is heavily caching and the SQL could see the changes with delay.

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  1
• Options

  prem_kumaran Member Posts: 10

  2015-10-21

  Hello Kine,
  
  Yes, I am seeing more in NAV than SQL.

  Thanks,
  Prem

  0
• Options

  prem_kumaran Member Posts: 10

  2015-10-22

  Hello Kine,
  
  I tried changing the Primary Key and the issue remains the same. I am really going crazy because of this issue.

  Thanks,
  Prem

  0
• Options

  Purvesh_Maisuria Member Posts: 71

  2015-10-22

  Hi Prem,
  
  This issue may happened because of white spaces before or after primarykey's value. This may occurred when you copy & paste value of field from the XLS. This white space may not shown in NAV, but it is exist at SQL side.
  
  You also not get record if you write SQL select query like below because of white spaces.
  
  Select * from Item Where [No.] = 'A0001';
  
  You get record via below query.
  
  Select * from Item Where [No.] like '%A0001%';
  
  If is it so, you need to update your primarykey's value via SQL update query.
  
  Note : In the case of record whose transaction entries are already posted. It is strictly not advisable to update it via SQL. If no transactions are done, you can do that.
  
  Thanks,
  Purvesh Maisuria.

  0