Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Zetadocs - Archive Service not working after rebuilding server

Posted on by Microsoft Employee

We are using Zetadocs Express, with the Archive Service, not Sharepoint.

The server that was running the Zetadocs Archive Service was Windows 2008 R1, and so end of life.
After rebuilding the server, I used the below procedure to backup the database from old server and then restore to new server:

http://www.equisys.com/technotes/ZTN4289.htm

That went without issue, however when we run any page in NAV using Zetadocs we receive the error

"Failed to search for documents. The reason is undefined.".


I did some troubleshooting.  I have narrowed it down to be something to do with the database.  With a fresh version of the database from when Zetadocs had just installed, there is no problem.  But if I restore the used one, no go.  Checking the logs, the client side log also only shows the above error. But the server side log shows the below repeatedly when I try and access.

"26/03/16-10:51:40 AM-DEBUG-C9041210.GetPrimaryKeyFields() No primary key fields saved for table: 39 returning: Document Type,Document No.,Line No.
26/03/16-10:51:40 AM-DEBUG-C9041209.GetRecordLinksFromLiveMapping() Cannot apply record mapping, source field is empty"

 

Would anyone have come accross something like this?  I am guessing some value/s in the SQL database don't agree with the new server.   But the link for Equisys does not mention anything special to do when rebuilding a server and using same IP address and servername.  Only thing I can think of is to compare all values in all tables from old and new and see what might be awack.  But that is like finding a needle in a haystack.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Zetadocs - Archive Service not working after rebuilding server

    I have resolved the problem.  I do not know what the original issue was, but since it worked with a fresh database, I just used the SQL Management Studio data import/export function to import the old server Zetadocs DB (table "Files" and "Containers") into the new one.  I then had to delete one row in the Containers table as it was causing an issue to upload in the Zetadocs Addin.  So, all good now!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans