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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Expand all | Collapse all

Error in Trading Network while Migrating

  • 1.  Error in Trading Network while Migrating

    Posted 08/20/11 04:21 PM

    Hi All,

    we are doing one POC for migrating from 6.5.3 Version to 8x. version.

    As per migration guide your webMethods components are sink.

    we are performing side by side migration from 6.5 to 8x version.

    As per Migration guide while Installing the webMethods 8 components at time of Trading Network of 8 we had connection at the 6.5 Trading Networks database component.'.

    For MWS also we a had used same userName /Passwords as of 6.5 database pointing.

    While lauching the TN of 8 we got the following error.

    0003.4114 Could not get profile summary (username=Administrator). com.wm.app.tn.profile.ProfileStoreException Could not get partners for user (username=Administrator). (0) java.sql.SQLSyntaxErrorException: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    (1) java.sql.SQLSyntaxErrorException: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    

    Please advice on this . Are we had missed any steps of running the script.

    Regards


    #webMethods-General
    #webMethods
    #webMethods-Upgrade
    #Integration-Server-and-ESB


  • 2.  RE: Error in Trading Network while Migrating

    Posted 08/21/11 05:03 PM

    Hi Sgour,
    If I understood correctly, during the 8.x installation, you have pointed the TN db to use the database used in wM 6.5 version…

    But did you execute the dbConfigurator migration scripts to migrate the TN data?

    If you have done that, plz check if you have ISInternal tables created in the database… You can choose the catalog option in DB Configurator to check that…

    Regards
    Senthil


    #webMethods-Upgrade
    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods