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

Error Connecting ACE with DB Oracle Express

  • 1.  Error Connecting ACE with DB Oracle Express

    Posted Fri January 05, 2024 08:49 PM
    Edited by Arnold Julian Herrera Quiñones Fri January 05, 2024 08:49 PM

    Hi,

    I have a environment with App Connect Enterprise, MQ Server and Oracle DataBase Express 21c

    For this purpose, I run every system in a separated container with bridge network, I am trying connect the App Connect with Oracle Database using a ODBC connection, since the developmnet uses a compute node with a datasource to insert the data into a db table.

    The configuration  I am doing is the following.

    1. I copy the follow odbc.ini file in the ace container in the path:  /home/aceuser/ace-server
    ;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 2. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;#                                                                        #
;##########################################################################

;#######################################
;#### List of data sources stanza ######
;#######################################

[ODBC Data Sources]
AUDITORIA=DataDirect ODBC Oracle Wire Protocol
;###########################################
;###### Individual data source stanzas #####
;###########################################


;# Oracle stanza
[AUDITORIA]
Driver=/opt/ibm/ace-12/server/ODBC/drivers/lib/UKora95.so
Description=DataDirect ODBC Oracle Wire Protocol
HostName=host.docker.internal
PortNumber=1521
ServiceName=XEPDB1
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
EnableNcharSupport=0
;# Uncomment the next setting if you wish to use Oracle TIMESTAMP WITH TIMEZONE columns
;# EnableTimestampwithTimezone=1

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=/opt/ibm/ace-12/server/ODBC/drivers
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

    2. I run the follow command on the ace container

    mqsisetdbparms -w /home/aceuser/ace-server -n AUDITORIA -u AUDITORIA -p *********

    3. I restart the ace container

    4. I run the SoapUI Project with the data to insert it into the database.

    When I debug with ACE Toolkit, since the data is not inserted in the table, the exception throw is the following:

    Database error: ODBC return code '-1' from data source 'AUDITORIA' using ODBC driver manager ''. 
Database error: SQL State 'IM002'; Native Error Code '0'; Error Text 'System information file not found. Please check the ODBCINI and the ODBCSYSINI environment variables are correct

    Would you mind try to explain me, what is wrong with environment configuration.

    Request a quick support.

    Best regards

    -----------------------------
    Arnold Julian Herrera Quiñones
    ------------------------------



  • 2.  RE: Error Connecting ACE with DB Oracle Express
    Best Answer

    Posted Mon January 08, 2024 01:13 AM

    Error mentioned in provided logs highlights ODBCINI environment variable hasn't been configured against your environment. For verification purposes you must verify ODBC configuration and connectivity using mqsicvp command first. Furthermore, to resolve network and other ODBC connectivity issues, you can enable ODBC trace as well. Refer to the following links for details.

    mqsicvp command - IBM Documentation

    ODBC trace - IBM Documentation



    ------------------------------
    Irfan Shahzad
    Integration Architect
    ------------------------------

    Original Message