search

foxysoft / idm-connector-bobj

SAP Identity Management connector for SAP BusinessObjects BI Platform
Apache License 2.0
5 stars 2 forks source link

SQL update failed in pass "Drop temporary tables" on Sybase ASE #14

Closed boskamp closed 5 years ago

boskamp commented 5 years ago

On first execution of this pass on Sybase ASE, the following error message will occur:

SQL Update failed. SQL:DROP TABLE FX_BOE_USER
java.lang.Throwable: Cannot drop the table 'FX_BOE_USER', because it doesn't exist in the system catalogs.

In the job log file, the following exception occurs:

Error code 3701 SQL state:ZZZZZ(!) - com.sybase.jdbc4.jdbc.SybSQLException: Cannot drop the table 'FX_BOE_USER', because it doesn't exist in the system catalogs.

Cannot drop the table 'FX_BOE_USER', because it doesn't exist in the system catalogs.

        com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4084)
        com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3174)
        com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
        com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
        com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
        com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2514)
        com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2498)
        com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:576)
        com.sap.idm.ic.DBStatement.executeUpdateInternal(DBStatement.java:1021)
        com.sap.idm.ic.DBStatement.executeUpdate(DBStatement.java:1052)
        com.sap.idm.ic.JDBCHandler.executeUpdate(JDBCHandler.java:1514)
        com.sap.idm.ic.ToODBC.doSQLUpdate(ToODBC.java:294)
        com.sap.idm.ic.ToODBC.addEntry(ToODBC.java:518)
        com.sap.idm.ic.ToPass.putNextEntry(ToPass.java:888)
        com.sap.idm.ic.ToODBC.putNextEntry(ToODBC.java:40)
        com.sap.idm.ic.ToPass.putNextEntry(ToPass.java:733)
        com.sap.idm.ic.ToODBC.putNextEntry(ToODBC.java:40)
        com.sap.idm.ic.DSERunTime.runToPass(DSERunTime.java:2653)
        com.sap.idm.ic.DSERunTime.runPass(DSERunTime.java:3137)
        com.sap.idm.ic.DSERunTime.runJob(DSERunTime.java:1264)
        com.sap.idm.ic.DSERunTime.loopJob(DSERunTime.java:667)
        com.sap.idm.ic.DSERunTime.doCommand(DSERunTime.java:1888)
        com.sap.idm.ic.DSERunTime.doCommand(DSERunTime.java:333)
        com.sap.idm.ic.DSERunTime.run(DSERunTime.java:3526)
        com.sap.idm.ic.DSERunTime.main(DSERunTime.java:3449)