App Connect

 View Only
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