Jump to content

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


Recommended Posts

[*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]

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

Link to comment
Share on other sites

It looks like something happened on Oracle Database when working with the users_temp table. Are there any space issues

Is this error reproducible on demand

Run /tomcat/bin> config list-users --force-synchronization and involve your DBA to check status of DB and users_temp table.

https://docs.tibco.com/pub/spotfire_server/7.11.5/doc/html/TIB_sfire_ser...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...