Error in Controller

, ,
1

Dear All,

I have installed the Manager Server6.5 & MywebmethodsUserInterface. And I have applied few fixes also.

1.ManagerConsole_6-5-1_SP1_Fix1.zip
2.Manager_Console_6-5-1_SP1_Fix3.zip
and altered the database according to another fix (Optimize_6-5-1_Fix2_readme.txt). But still I am getting error like…

org.hibernate.exception.GenericJDBCException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96
)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId
(AbstractSaveEventListener.java:91)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGene
ratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTran
sient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:520)

    at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:513)
    at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:509)
    at com.dante.config.controller.ConfigInstanceStorage.addOrUpdateView(Con

figInstanceStorage.java:159)
at com.dante.config.controller.View.save(View.java:150)
at com.dante.config.controller.ConfigRepository.registerListener(ConfigR
epository.java:327)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.jdmk.MBeanServerImpl.invoke(MBeanServerImpl.java:1624)
at com.sun.jdmk.MBeanServerImpl.invoke(MBeanServerImpl.java:1519)
at com.dante.config.ConfigRegistry.registerListener(ConfigRegistry.java:
285)
at com.dante.config.ConfigRegistry.registerCallback(ConfigRegistry.java:
341)
at com.dante.config.ConfigRegistry.registerCallback(ConfigRegistry.java:
325)
at com.dante.model.ModelCallbackService.registerCallbackOnType(ModelCall
backService.java:68)
at com.dante.model.ModelTopologyProvider.registerCallbacks(ModelTopology
Provider.java:69)
at com.dante.model.ModelTopologyProvider.onStart(ModelTopologyProvider.j
ava:54)
at com.dante.station.Service.run(Service.java:329)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]O
RA-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.prepare(Unknown Source)
    at com.wm.dd.jdbc.base.BaseImplStatement.prepare(Unknown Source)
    at com.wm.dd.jdbc.base.BasePreparedStatement.prepareSQL(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
    at com.wm.dd.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
    at com.wm.dd.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
    at com.wm.dd.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
    at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delegat

ingConnection.java:185)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
prepareStatement(PoolingDataSource.java:278)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:442)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBat
cher.java:99)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73
)

whether I am missing any fixes?

Please help me.

Thanking you in Advance
jacob

2

Hibernate is the object to relational mapping solution used by Manager and Optimize. The error message at the end of the stack trace that you pasted …

ORA-02289: sequence does not exist

… suggests that there was either an error when creating the database objects for Manager (using the Oracle.bat script) or that something has happened to delete the Oracle sequence.

Mark

3

Thank you for your immediate reply…

Yes you are right…while running oracle.bat i got error like (only one error)

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object MANAGER.METADATAPKG is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

And warning like packaged compile with errors…i just ignored it…
Do you think b’coz of this the sequence got errored?

B’coz i tried oracle.bat file several times but this errors and warning was still there…Is this b’coz of any authorization problem?.

Thanking You in Advance
jacob

4

This error is still remaining in current oracle.bat/.sh.

As a work-around for this problem you have to give permissions to Manager oracle user with following script <WEBMETHODS_HOME>/common/db/scripts/oracle/code/common/create/ora_cmn_c_ddl_user.sql

Example :

[SIZE=2]sqlplus /nolog
SQL>connect sys/sys as sysdba;
SQL>@code/common/create/ora_cmn_c_ddl_user.sql MNS MANAGERUSER MANAGERUSER WEBMMANAGERSERVERDATA WEBMMANAGERSERVERDATA WEBMMANAGERSERVERDATA WEBMMANAGERSERVERINDX WEBMMANAGERSERVERINDX WEBMMANAGERSERVERINDX TEMP world.world.com dba@world.COM;
SQL>quit

After that you can run the wizard with the existing MANAGERUSER or simply rebuild MANAGER.METADATAPKG

Regards,
Djibril.
[/size]