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

Problems switching MWS 7.1.2 from Oracle to SQL

  • 1.  Problems switching MWS 7.1.2 from Oracle to SQL

    Posted Fri June 11, 2010 09:21 PM

    Hello,

    We are attempting to switch our MWS 7.1.2 install from using Oracle back end Databases to MS-SQL back end databases and we are receiving an error when MWS starts up after setting up SQL the error is as follows:

    2010-06-11 14:10:08 EDT (eventService : WARN) - Failed to publish event com.webMethods.portal.event.system.impl.LogMessageEvent to queue com.webMethods.portal.system.error.queue JMSException: [wm-cjdbc36-0039][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column ‘EVENT_ID’, table ‘MWS71D.dbo.T_JMS_EVENTS’; column does not allow nulls. INSERT fails., LinkedException: null
    javax.jms.JMSException: [wm-cjdbc36-0039][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column ‘EVENT_ID’, table ‘REMOVEDDBNAME.dbo.T_JMS_EVENTS’; column does not allow nulls. INSERT fails.

    We are running MWS 7.1.2 with CL_Fix11 and CL_Fix4 installed. Connecting to MS-SQL 2005. We used Microsoft’s migration assistant to migrate the databases.

    Here is the mws.db.xml file configuration:

    <?xml version="1.0" encoding="UTF-8"?> com.webmethods.portal.service.sql.core.BaseSqlWorker com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider com.wm.dd.jdbc.sqlserver.SQLServerDriver jdbc:wm:sqlserver://REMOVEDSERVERNAME:REMOVEDPORT;databaseName=REMOVEDDBNAME MWS71D REMOVEDPASSWORD 100 false SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1 2 300

    Anyone have any ideas or suggestions?


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


  • 2.  RE: Problems switching MWS 7.1.2 from Oracle to SQL

    Posted Mon June 14, 2010 09:13 PM

    Well the error is correct, that fields does not allow nulls.

    The question then should be, what is causing your MWS to get null values for EVENT_ID?

    Maybe start “mws.sh/bat -debug -s default start” and check for any issue before that error.


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


Related Content