Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

SLX 8.1 Admin; How to refresh Library?

[ Edited ]

Hi,

 

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 8.1.0.1416.

Is there another way to do this?

 

Thanks and best regards,

Marco

---------------------------
Ambit AG, Switzerland
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: SLX 8.1 Admin; How to refresh Library?

Hi Marco,

 

I have just tested this on v8.1 SNC 03 and it works fine.

Regards, Adam Travers
empath-e Services Limited
Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

Re: SLX 8.1 Admin; How to refresh Library?

Hi Adam,

 

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.

 

Regards,

Marco

 

 

 

---------------------------
Ambit AG, Switzerland
Highlighted
Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

Re: SLX 8.1 Admin; How to refresh Library?

Still fighting with this one. @Adam, which Admin.exe do you have?

I tried with 8.1.0.1416 and 8.1.0.1434 on different systems.

 

When opening the Library in Admin it only populates the first LIBRARYDIRS record which is the base folder with PARENTID = 0.

 

Profiler shows:

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).

 

Really strange.

---------------------------
Ambit AG, Switzerland