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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Mon September 10, 2007 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 Wed September 12, 2007 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 Wed September 12, 2007 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 Wed September 12, 2007 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


Related Content