none
Error while running Oracle WCF DB adapter from adapter pack V2 Beta with BTS2006R2 RRS feed

  • Question

  • I get this error in Event Viewer:
    The adapter failed to transmit message going to send port "SendPort_SelectAccTable" with URL "oracledb://10.77.97.80:1521/Walter". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.InvalidUriException: Both ServiceName and ServiceType should be specified
       at Microsoft.Adapters.OracleDB.OracleDBConnectionUri.set_Uri(Uri value)


    My tnsnames.ora contains:
    Walter = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.77.97.80)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=Walter)))
    (I copied this string from the Oracle Enterprise Manager console)

    In BizTalk Server Admin Console > Application > Sample Application > Configure > Send Ports > SendPort_SelectAccTable > URI contained oracledb://adapdoc in Binding.xml, and after importing it, I modified it to oracledb://10.77.97.80:1521/Walter .

    Could you please help?

    Thanks in advance.

    Regards,
    Advait
    Friday, April 3, 2009 7:05 AM

Answers

  • Hi Advait,

    You need not specify hostname and port in URI when you specify tnsnames.ora entry in URI. Your URI should look like : oracledb://Walter.

    Thanks,
    Gaurav
    Friday, April 3, 2009 7:12 AM

All replies