SQL lists are updated by the Enterprise PDM database server service - so if the periodic refresh is not working, then its likely the service that is not running as it should. I'd recommend going through the troubleshooting steps in KB solution S-08226. If it still is not working, contact your VAR for help.
-Tor, EPDM support
I went though the troubleshooting guided from S-08226, this is what I found
Note I am using EPDM 2011, The MDB file is on a domain server.
PDMWorks Enterpise Database Server is not installed but Solidworks Enterprise PDM Database Server is started. I suspect it is a replacement. It's Login is Local System; to get the linked server to work, I had to set SQL server to use a domain login.
I found 2 errors,
1st in the ConisioArchiveServerLog
Could not receive data from 10.1.1.150:51967. (Windows Sockets Error# 10054. Connection reset by peer.)
150 is the workstation I am using to test
2nd in Application under SQL logs
Faulting Application Conisiodbserver.exe Version 220.127.116.110, Time stamp 0x4d376267, Faulting module MSUCR80.DLL
USER is sa, should it be sa.DOMAIN?
I enable logging, this is what I got
**** Opened ****
Getting dbs from server
since the log is not returning any vaults to poll - something is not correctly set up. I suggest you open a support ticket with your VAR for further troubleshooting.
The problem was that SQL server was using a local account instead of a domain account. The MDB file was stored on a Domain server, so SQL could not see it.