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