App Connect

App Connect

Join this online user 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

Issue in inserting timestamp value into Oracle database (Post migration from IIB V10 to ACE 12)

  • 1.  Issue in inserting timestamp value into Oracle database (Post migration from IIB V10 to ACE 12)

    Posted Mon May 02, 2022 12:04 PM
    Hello,
    We are migrating the flows from IIBV10 to ACE V12. During the testing in ACE12, we are facing the issue while inserting the timestamp values into Oracle database.

    Sample Query:
    PASSTHRU('INSERT INTO DatabaseName(TRANSACTTIME) VALUES(to_timestamp_tz(?, ?)','20220413-09:23:36.705','YYYYMMDD-HH24:MI:SS.FF TZR')

    When we execute this command in ACE12, we are receiving the below error.

    Exception List:
    Insert
    Type:INTEGER:14
    Text:CHARACTER:/opt/ace-12.0.4.0/ie02/lib/libodbcinterface.so
    DatabaseException
    File:CHARACTER:/build/jenkins_swg/slot0/product-build/WMB/src/DataFlowEngine/MessageServices/ImbOdbc.cpp
    Line:INTEGER:4252
    Function:CHARACTER:ImbOdbcStatement::checkRcInner
    Type:CHARACTER:
    Name:CHARACTER:
    Label:CHARACTER:
    Catalog:CHARACTER:BIPmsgs
    Severity:INTEGER:3
    Number:INTEGER:2322
    Text:CHARACTER:Child SQL exception
    Insert
    Type:INTEGER:5
    Text:CHARACTER:22018
    Insert
    Type:INTEGER:2
    Text:CHARACTER:0
    Insert
    Type:INTEGER:5
    Text:CHARACTER:[IBM][ODBC Oracle Wire Protocol driver]Invalid character value. Error in parameter 30.

    could you please check and let us know if there are any differences in ODBC drivers?

    Thank & Regards,
    Vimal Raj D

    ------------------------------
    Vimal Raj
    ------------------------------


  • 2.  RE: Issue in inserting timestamp value into Oracle database (Post migration from IIB V10 to ACE 12)

    Posted Thu May 12, 2022 12:33 PM
    Hi @Vimal Raj thanks for your post! Please expand the Embedded components and versions included in this release section here: https://www.ibm.com/support/pages/node/6555100/ for ACE 12.0.4. Hope that helps!

    ------------------------------
    Jina K
    ------------------------------

    Original Message