In Spotfire server logs every time LDAP sync happens I see ERROR : [*LdapSynchronizer.SynchronizerCallback*] server.userdir.AbstractDatabaseProvider: Error cleaning up temporary tables com.spotfire.server.userdir.DirectoryException: Error dropping table

[Chunlai Tao]

In Spotfire server logs every time LDAP sync happens I see ERROR : [*LdapSynchronizer.SynchronizerCallback*] server.userdir.AbstractDatabaseProvider: Error cleaning up temporary tables com.spotfire.server.userdir.DirectoryException: Error dropping table #USERS_TEMP

Cannot drop the table '#USERS_TEMP', because it does not exist or you do not have permission

where is this USERS_TEMP table i have ask dba check he could not find it in repository db or temp db

does any one know

thanks

[Jens Borgland]

You should probably contact Support so that they can help you troubleshoot. It's not possible to determine the cause based on the information available here.

 

The table in question is a temporary table that is created during the LDAP synchronization and then removed. If the removal fails, and the DBA cannot find it then perhaps some previous error prevented it from ever being created