none
WCF Oracle run time connection error RRS feed

  • Question

  • Hi,

    I try to use WCF Oracle, but I get the following error when I use the following Action:

    ACTION:

    <BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <Operation Name="Select" Action="http://Microsoft.LobServices.OracleDB/2007/03/ADMIN/Table/WATCH_IDS/Select" />
    </BtsActionMapping>

    ERROR:

    The adapter failed to transmit message going to send port "WcfSendPort_OracleDBBinding_ADMIN_Table_WATCH_IDS_Custom" with URL "oracledb://192.10.192.10:1521/TestService/Dedicated". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.MetadataException: Argument <BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <Operation Name="Select" Action="http://Microsoft.LobServices.OracleDB/2007/03/ADMIN/Table/WATCH_IDS/Select" />
    </BtsActionMapping> is invalid.

     

    And if I use the following action, then I get another eror:

    ACTION:

    http://Microsoft.LobServices.OracleDB/2007/03/ADMIN/Table/WATCH_IDS/Select

    ERROR:

    The adapter failed to transmit message going to send port "WcfSendPort_OracleDBBinding_ADMIN_Table_WATCH_IDS_Custom" with URL "oracledb://192.10.192.10:1521/TestService/Dedicated". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/ADMIN/Table/WATCH_IDS/Select". ---> Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters.
       at Microsoft.Adapters.OracleDB.OracleDBConnection.OpenConnection(OracleCommonExecutionHelper executionHelper)

     

    Can someone help?

    Thanks,
    Tuan

     

    Monday, May 3, 2010 3:52 PM

Answers

  • Hi Tuan,

    You should check this thread on the forum about TNS Names as first exception speaks for it self as action was invalid.

    HTH

    Regards,

    Steef-Jan Wiggers
    MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by TuanL Tuesday, May 4, 2010 6:41 AM
    Tuesday, May 4, 2010 2:38 AM
    Moderator

All replies

  • Hi Tuan,

    You should check this thread on the forum about TNS Names as first exception speaks for it self as action was invalid.

    HTH

    Regards,

    Steef-Jan Wiggers
    MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by TuanL Tuesday, May 4, 2010 6:41 AM
    Tuesday, May 4, 2010 2:38 AM
    Moderator
  • Thanks Steef-Jan.

    I didn't look further than my nose long :-). Set the setting "useAmbientTransaction" to False helps me out. The first error is because I use the custom binding file generated by the wizard "oracleDBBinding".

    Regards,
    Tuan

    Tuesday, May 4, 2010 5:58 AM