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. ERROR

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

    Posted Mon September 10, 2007 04:18 PM

    Hi All,

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

    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 [URL=“http://advantage.webmethods.com/article/?id=SR-1-64518051”]http://advantage.webmethods.com/article/?id=SR-1-64518051[/color][/font][/URL][FONT=Tahoma][COLOR=black], 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 suggestion to solve this issue? Thanks!


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


Related Content