IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

MWS doesnot start throws No function or procedure(SPTYPELOAD

  • 1.  MWS doesnot start throws No function or procedure(SPTYPELOAD

    Posted Fri August 14, 2009 10:34 PM

    Please let me know if you have seen this error

    When I ran the start up script, and we get this error:

    [wm-cjdbc37-0008][DB2 JDBC Driver][DB2]No function or procedure was found with the specified name (SPTYPELOAD) and compatible arguments.

    java.sql.SQLException: [wm-cjdbc37-0008][DB2 JDBC Driver][DB2]No function or procedure was found with the specified name (SPTYPELOAD) and compatible arguments.

        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.db2.drda.DRDARequest.processSQLCA(Unknown Source)

at com.wm.dd.jdbc.db2.drda.DRDARequest.processCodePoint(Unknown Source)

at com.wm.dd.jdbc.db2.drda.DRDAStatementRequest.processCodePoint(Unknown Source)

at com.wm.dd.jdbc.db2.drda.DRDAExecuteStatementRequest.processCodePoint(Unknown Source)

at com.wm.dd.jdbc.db2.drda.DRDARequest.processReply(Unknown Source)

at com.wm.dd.jdbc.db2.DB2ImplStatement.getNextResultType(Unknown Source)

at com.wm.dd.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.wm.dd.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.wm.dd.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.wm.dd.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.wm.dd.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcResult(BaseSqlWorker.java:651)

at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcResult(BaseSqlWorker.java:604)

at com.webmethods.portal.service.meta2.impl.XTypeService.loadDefaultMap(XTypeService.java:216)

at com.webmethods.portal.service.meta2.impl.XTypeService.init(XTypeService.java:134)

at com.webmethods.portal.system.impl.BaseProvider.initComponent(BaseProvider.java:609)

at com.webmethods.portal.service.meta2.impl.MetaContext.initComponent(MetaContext.java:109)

at com.webmethods.portal.system.impl.BaseProvider.initComponents(BaseProvider.java:512)

at com.webmethods.portal.system.impl.BaseProvider.init(BaseProvider.java:125)

at com.webmethods.portal.service.meta2.impl.MetaContext.init(MetaContext.java:86)

at com.webmethods.portal.system.impl.BaseProvider.initComponent(BaseProvider.java:609)

at com.webmethods.portal.service.meta2.impl.MetaManager.initComponent(MetaManager.java:94)

at com.webmethods.portal.system.impl.BaseProvider.initComponents(BaseProvider.java:512)

at com.webmethods.portal.system.impl.BaseProvider.init(BaseProvider.java:125)

at com.webmethods.portal.service.meta2.impl.MetaManager.init(MetaManager.java:58)

at com.webmethods.portal.system.init.impl.DefaultPhase.initComponent(DefaultPhase.java:99)

at com.webmethods.portal.system.impl.BaseProvider.initComponents(BaseProvider.java:512)

at com.webmethods.portal.system.impl.BaseProvider.init(BaseProvider.java:125)

at com.webmethods.portal.system.init.impl.DefaultPhase.init(DefaultPhase.java:44)

at com.webmethods.portal.system.init.impl.DefaultPhaseProvider.initComponent(DefaultPhaseProvider.java:257)

at com.webmethods.portal.system.impl.BaseProvider.initComponents(BaseProvider.java:512)

at com.webmethods.portal.system.impl.BaseProvider.init(BaseProvider.java:125)

at com.webmethods.portal.system.init.impl.DefaultPhaseProvider.initializePhases(DefaultPhaseProvider.java:89)

at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initializePhases(ClusterPhaseProvider.java:27)

at com.webmethods.portal.system.PortalSystem.init(PortalSystem.java:868)

at com.webmethods.portal.system.PortalSystem.main(PortalSystem.java:827)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.webmethods.portal.system.start.Main.start(Main.java:131)

    We modified the scripts to reduce the tablespace . Will that cause this issue?


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine


Related Content