x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 47 subscribers
  • Views 4932 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
Georgeoko

([Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The application cannot find the key value (Btrieve error 5))

SUGGESTED
Posted By

i have not closed Journal entries in G/L for 12months, so while posting it indicates that i cannot post for more than 12months without closing for the months. i decided to go back and close, then this error appeared.while closing G/L For month of June 2015 ([Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The application cannot find the key value (Btrieve error 5))"  Any ideas?

  • 0
    June 2015 is more than 12 months back (Your 19 closes from Feb 2017) 2015 = 7 / 2016 =12 / 2017 = 2

    1 Backup 2 times - a flash drive and the local hard drive are good choices
    2. Reboot the server
    3. attempt the close again

    if it fails call Sage Tech support
    they will walk you thru how to re-index or correct the problem or addition steps
  • 0
    SUGGESTED
    Btrieve status 5 error generally means you had a failed close. You need to restore a backup prior to performing that close and reprocess the close again. See Knowledge Base article #18639 Error "Record has a key field containing a duplicate value. Btrieve Status 5" when closing General Ledger.
    Thanks,
    Coleen

*Community Hub is the new name for Sage City