PDA

View Full Version : rulemigrator.bat file gone postal on me !

scoobydoo
12-28-2007, 09:29
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
reamon
12-28-2007, 13:27
"sequence does not exist"

Have you run all DB scripts?
scoobydoo
12-28-2007, 14:40
Rob,
Im sure i ran all the scripts.
I found this on advantage, but it doesnt make a lot of sense to me.

http://advantage.webmethods.com/article/?id=SR-1-71953161
scoobydoo
12-28-2007, 15:49
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!
reamon
12-31-2007, 09:10
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.
scoobydoo
12-31-2007, 12:13
Is there anyway we could find out what sequence its targeting?
That would make a lot of things easier.
Thanks
Rob
reamon
12-31-2007, 13:14
A DB admin should be able to capture the statement being executed by the DB at the time of the error.
scoobydoo
01-04-2008, 11:05
Rob , i guess you were right , Tables were messed up and missing and some sequences were missing.
:(
Guess I gotta start all over again.
Is Noooo Bueno Hermano!

Thanks for all your help Eamon.

Scooby