UCM service can't start and stay in "Admin" mode in WebLogic Console
From weblogic .out file ,we can see such error
java.sql.SQLException: !csJdbcTempTableExists,USERSTemp,Users
at intradoc.jdbc.JdbcWorkspace.alterTable(JdbcWorkspace.java:1679)
at intradoc.server.datastoredesign.DataDesignGenerator.alterTable(DataDesignGenerator.java:2075)
at intradoc.server.datastoredesign.DataDesignGenerator.generateTable(DataDesignGenerator.java:255)
at intradoc.server.datastoredesign.DataDesignInstall.configTableForComponents(DataDesignInstall.java:284)
at intradoc.server.IdcExtendedLoader.dataStoreDesignConfigTables(IdcExtendedLoader.java:2551)
at intradoc.server.IdcExtendedLoader.performDatabaseUpgradeTasks(IdcExtendedLoader.java:397)
It's quite possible there was hiccup when we create weblogic DataSource or mis-communication somewhere among UCM cluster. The temp was not deleted after test
we need to drop it manually on DB end to fix the issue
No comments:
Post a Comment