IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  Failed to connect to Oracle database

    Posted 05/16/14 05:57 AM

    Originally posted by: johnxp


    Hi,

    Anyone can help me with the connection issue, please.

    I am using WTX8.2 on Windows 7. I can create MDQ file without problem.

    However, when I try to access remote Oracle, got below the error:

    <15552-5004>: Validating the adapter command...
    <15552-5004>: Database type is Oracle
    <15552-13760>: Connecting...
    <15552-13760>: Host string: 192.168.1.10:1521/MYDB
    <15552-13760>: UserID     : User1
    <15552-13760>: Password   : *****
    <15552-13760>: DBLOOKUP Function, Transaction scope: Map
    <15552-13760>: TRACE command specified, append mode, file: D:\WTX\Workspace\MyProject\.\Logs\Database\TestGFX.dbl
    <15552-13760>: Returned status: (-1005) Failed_to_connect_to_the_database

     

     

    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Failed to connect to Oracle database

    Posted 05/16/14 09:31 AM

    Originally posted by: paul.brett


    Your MDQ file will have an entry for connection to the database, something like this:

    <DESIGNSOURCE>ora11_bocadb6</DESIGNSOURCE>

    ...and the same string needs to be used in the runtime entry, or in any override you use.

    Your log shows: "Host string: 192.168.1.10:1521/MYDB"

    ...and this does not look right to me.  This should be an entry from the tnsnames.ora, the same as in your MDQ.

    If you need further help, paste in your MDQ file, the map aconnection string (from the card or rule) and the new log file.

    Thank-you.

    Paul

    Follow me on Twitter


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Failed to connect to Oracle database

    Posted 05/18/14 11:33 PM

    Originally posted by: johnxp


    Hi Paul,

    I am using connection string: 

    <DATABASE name="MYDB">
    <TYPE>ORACLE</TYPE>
    <PLATFORM>WINDOWS</PLATFORM>
    <QUALIFIEDNAMES>true</QUALIFIEDNAMES>
    <SURROUNDCHARS></SURROUNDCHARS>
    <DESIGNSOURCE>192.168.204.180:1521/MYDB</DESIGNSOURCE>
    <EXECUTIONSOURCE>192.168.204.180:1521/MYDB</EXECUTIONSOURCE>
    <USER>User1</USER>

    In map rule, I am using the same mdq file, it's not working on my machine. However, it works on my colleague's.

    You reminded me to use the entry from tnsnames.ora, now the issue is solved.

    Thank you.

     


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


Related Content