Forum Stats

  • 3,851,423 Users
  • 2,263,974 Discussions
  • 7,904,701 Comments

Discussions

Missing sequence

3004
3004 Member Posts: 204,171 Green Ribbon
When starting iFS, I get the following error in ifsAgents.log and ifsProtocols.log:
java.sql.SQLException: ORA-02289: sequence does not exist.
Any idea what's missing ?
Thanks,
Franck.

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Did the iFS Configuration complete successfully? Are there any errors in the IfsConfigLog?
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Actually I got the error:

    java.sql.SQLException: ORA-04042: procedure, function, package, or package body does not exist

    at java.lang.Throwable.<init>(Compiled Code)
    at java.lang.Exception.<init>(Compiled Code)
    at java.sql.SQLException.<init>(SQLException.java:43)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
    at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
    at oracle.jdbc.oci8.OCIDBAccess.executeFetch(Compiled Code)
    at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteOther(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.execute(Compiled Code)
    at oracle.ifs.utils.sql.SQLCommands.grantPriviledgeToUser(SQLCommands.java:386)
    at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.createIfsUser(IfsConfiguration.java:493)
    at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.perform(IfsConfiguration.java:464)
    at oracle.ifs.utils.action.ActionQueue.performActions(Compiled Code)
    at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:244)
    at java.lang.Thread.run(Thread.java:466)
    recording that configuration failed
    saving:D:\Oracle\Ora81\ifs\settings\oracle\ifs\installer\properties\IfsConfig.properties
    iFS configuration failed; the following error occurred:

    oracle.ifs.utils.action.ActionFailedException: java.sql.SQLException: ORA-04042: procedure, function, package, or package body does not exist

    at java.lang.Throwable.<init>(Compiled Code)
    at java.lang.Exception.<init>(Compiled Code)
    at oracle.ifs.utils.action.ActionFailedException.<init>(ActionFailedException.java:76)
    at oracle.ifs.installer.IfsConfiguration$CreateSchemaAction.perform(IfsConfiguration.java:481)
    at oracle.ifs.utils.action.ActionQueue.performActions(Compiled Code)
    at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:244)
    at java.lang.Thread.run(Thread.java:466)

    configuration failed on Mon May 22 16:52:44 EDT 2000

    null
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Ah, yes. For the solution, see the message thread in this forum entitled "Ifs configuration problem", originally posted by Haiying:
    http://technet.oracle.com:89/ubb/Forum36/HTML/000023.html
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    I found out that I had run the script catobtk.sql as 'SYSTEM' instead of 'SYS'.
    Everything works fine now.
    Thanks,
    Franck.
This discussion has been closed.