09-24-2014 01:24 AM - edited 09-24-2014 01:25 AM
in earlier versions it was possible to refresh the Sales Library
(e.g. when it was updated through explorer) with the following steps:
DELETE FROM LIBRARYDOCS
DELETE FROM LIBRARYDIRS
Refresh the Admin twice.
This no longer seems to work with Admin.exe 188.8.131.526.
Is there another way to do this?
Thanks and best regards,
09-24-2014 02:02 AM
thanks for testing. I tried it on the customer site and in my test session. It's not working in both.
The Library itself is working when adding files through Admin so it should not be a permission issue.
Process Monitor shows Admin.exe > QueryDirectory > \\Server\SyncLogs\SlxProd\Library >> No More Files.
If it's permission I would excpect an Access Denied.
Will do some more test and also check other systems.
10-16-2014 02:35 AM
Still fighting with this one. @Adam, which Admin.exe do you have?
I tried with 184.108.40.2066 and 220.127.116.114 on different systems.
When opening the Library in Admin it only populates the first LIBRARYDIRS record which is the base folder with PARENTID = 0.
SELECT * FROM LIBRARYDOCS (>>no result, makes sense)
SELECT DIRID, FOUND FROM LIBRARYDIRS WHERE (FULLPATH IS NULL) OR (FULLPATH = '') (>> finds the base folder)
SELECT DIRID, FOUND FROM LIBRARYDIRS WHERE (UPPER(FULLPATH) = ?) OR (FULLPATH = ?) (>> ?? no result)
then it gets interesting:
SELECT DIRID, FOUND FROM LIBRARYDIRS WHERE (UPPER(FULLPATH) = [DBTYPE_STR | DBTYPE_BYREF,"\01 GENERAL INTERNAL INFORMATION"]) OR (FULLPATH = [DBTYPE_WSTR | DBTYPE_BYREF,"\01 General Internal Information"])
(>> this is one of the folders which is in my physical library folder, but not in the db so no result).