rulemigrator.bat file gone postal on me !

, ,
1

Hello everyone,
Here is my issue:
Everytime i try to run the rulemigrator.bat to import preset Manager Console rules as mentioned in the pdf ( Manager 6.5.1 on windows XP Pro , Oracle DB)
I get slapped with this.
I have looked and searched but could not come up with a resolution.
I got the PRTL CORE FIX 2 AND MANAGER CONSOLE 651 SP2 FIX 7 in there.

java.sql.SQLException: [wm-cjdbc35-0027][Oracle JDBC Driver][Oracle]ORA-02289:
sequence does not exist

    at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Sourc

e)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Sourc
e)
at com.webMethods.managerconsole.utils.migration.RuleMigrator.import_Dg_
Analysis_Rule(RuleMigrator.java:393)
at com.webMethods.managerconsole.utils.migration.RuleMigrator.main(RuleM
igrator.java:64)
Releasing database connection

Thanks for advance for anyhelp.
Scoobydoo

2

“sequence does not exist”

Have you run all DB scripts?

3

Rob,
Im sure i ran all the scripts.
I found this on advantage, but it doesnt make a lot of sense to me.

[url]http://advantage.webmethods.com/article/?id=SR-1-71953161[/url]

4

I know the DB schema that will be effected by running rulemigrator.bat file is Analysis.
I had to run the SQL script which is a part of ManagerConsole_6_5_1_SP2_Fix7 patch which ran without any issues. So im thinking that stuff is there.

Any other pointers?
Thanks Rob.
Scooby!

5

Possibly a privileges issue? If the sequence in question exists in the DB (might be worth triple checking), this is the only other possibility I can think of.

6

Is there anyway we could find out what sequence its targeting?
That would make a lot of things easier.
Thanks
Rob

7

A DB admin should be able to capture the statement being executed by the DB at the time of the error.

8

Rob , i guess you were right , Tables were messed up and missing and some sequences were missing.
:frowning:
Guess I gotta start all over again.
Is Noooo Bueno Hermano!

Thanks for all your help Eamon.

Scooby