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

  • 1.  BatchInsertSQL - nvarchar2 - (17004) Invalid column type. ER

    Posted 09/10/07 10:06 AM

    Hi All,

    I am using BatchInsertSQL to insert values to my oracle table which is having nvarchar2 fields.

    The above mentioned nvarchar2 fields are NOT NULL fields.

    While inserting data into table, i am getting the following error.
    (17004) Invalid column type.

    As I referred advantage site http://advantage.webMethods.com/article/?id=SR-1-64518051, suggested to
    install patch JDBC_6-0-3_Fix15 or JDBC_6-0-3_FP1_Fix10.

    Trying to install this patch in our server, we are getting version conflict error.
    “Error: The version of the existing package does not match the version of the package to be installed. Installation fails”

    Server Details : 6.1
    Updates Installed:
    WmPRT_6-1_SP2_Fix4
    IS_6-1_SP2

    WmJDBCAdapter package version : 6.0.3.1
    (Still now there is no bug fix installed for This package)

    Do you have any ideas to solve this issue? Thanks!


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


  • 2.  RE: BatchInsertSQL - nvarchar2 - (17004) Invalid column type. ER

    Posted 09/12/07 09:03 AM

    Hi,

    which patch did you try?

    JDBC_6-0-3_Fix15?


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


  • 3.  RE: BatchInsertSQL - nvarchar2 - (17004) Invalid column type. ER

    Posted 09/12/07 09:04 AM

    Hi,

    which patch did you try?

    JDBC_6-0-3_Fix15? will not work

    JDBC_6-0-3_FP1_Fix10?


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


  • 4.  RE: BatchInsertSQL - nvarchar2 - (17004) Invalid column type. ER

    Posted 09/12/07 09:07 AM

    Sorry for the duplicates, but my keyboard got a little bit crazy.

    JDBC_6-0-3_FP1_Fix10? Should work, but you should check for JDBC_6-0-3_FP1_Fix17 instead. Remember to check the dependencies between fixes as JDBC Fixes (might) have depenedencies to ART and XA-Fixes.

    Regards,
    Holger


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