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 truncating table

Venkatasiva Nagi Reddy Adapa · August 9, 2019

[*LdapSynchronizer.SynchronizerCallback*] server.userdir.AbstractDatabaseProvider: Error cleaning up temporary tables

com.spotfire.server.userdir.DirectoryException: Error truncating table USERS_TEMP

at com.spotfire.server.userdir.OracleDatabaseProvider.truncateTable(OracleDatabaseProvider.java:362) ~[server.jar:]

at com.spotfire.server.userdir.OracleDatabaseProvider.cleanUpTemporaryTables(OracleDatabaseProvider.java:351) ~[server.jar:]

at com.spotfire.server.userdir.AbstractDatabaseProvider.updateLdapDirectory(AbstractDatabaseProvider.java:2721) ~[server.jar:]

at com.spotfire.server.userdir.ldap.LdapSynchronizer.synchronize(LdapSynchronizer.java:227) ~[server.jar:]

at com.spotfire.server.userdir.ldap.LdapSynchronizer$SynchronizerCallback.run(LdapSynchronizer.java:260) ~[server.jar:]

at com.spotfire.server.util.SchedulerTask.run(SchedulerTask.java:70) ~[server.jar:]

at com.spotfire.server.util.Scheduler$SchedulerTimerTask.run(Scheduler.java:118) ~[server.jar:]

at java.util.TimerThread.mainLoop(Timer.java:555) ~[:1.8.0_212]

at java.util.TimerThread.run(Timer.java:505) ~[:1.8.0_212]

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) ~[ojdbc8.jar:12.2.0.1.0]

at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) ~[ojdbc8.jar:12.2.0.1.0]

at com.spotfire.server.util.sql.WrappedStatement.execute(WrappedStatement.java:70) ~[server.jar:]

at com.spotfire.server.userdir.OracleDatabaseProvider.truncateTable(OracleDatabaseProvider.java:360) ~[server.jar:]

... 8 more

Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0]