none
Error while executing oracle adpter sample for biztalk server RRS feed

  • Question

  • Hi,

    I am trying to run oracle adapter sample given with Biztalk Adapter pack V2.0. When I copy sample input XML file in MessageIn folder, the file disappears but there is no file created in ResponseOut folder. I am getting following error in event log.

    Event Type: Warning
    Event Source: BizTalk Server 2006
    Event Category: BizTalk Server 2006
    Event ID: 5743
    Date:  5/14/2009
    Time:  5:24:57 AM
    User:  N/A
    Computer: PS5922
    Description:
    The adapter failed to transmit message going to send port "SendPort_SelectAccTable" with URL "oracledb://Warehous". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: ORA-1017: invalid username/password; logon denied ---> Oracle.DataAccess.Client.OracleException ORA-1017: invalid username/password; logon denied    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheckForOra1000Error)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
       at Oracle.DataAccess.Client.OracleConnection.Open()
       at Microsoft.Adapters.OracleCommon.OracleCommonConnectionWrapper..ctor(String connectionString, OracleCommonExecutionHelper executionHelper)
       at Microsoft.Adapters.OracleDB.OracleDBConnection.Microsoft.ServiceModel.Channels.Common.IConnection.Open(TimeSpan timeout)
       --- End of inner exception stack trace ---

    Server stack trace:
       at Microsoft.Adapters.OracleDB.OracleDBConnection.Microsoft.ServiceModel.Channels.Common.IConnection.Open(TimeSpan timeout)
       at Microsoft.ServiceModel.Channels.Common.Design.ConnectionPool.GetConnection(Guid clientId, TimeSpan timeout)
       at Microsoft.ServiceModel.Channels.Common.Design.ConnectionPool.GetConnectionHandler[TConnectionHandler](Guid clientId, TimeSpan timeout, MetadataLookup metadataLookup, String& connectionId)
       at Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel.OnOpen(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open()

    Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at System.ServiceModel.ICommunicationObject.Open()
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.GetChannel[TChannel](IBaseMessage bizTalkMessage, ChannelFactory`1& cachedFactory)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.SendMessage(IBaseMessage bizTalkMessage)".

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    I have ensured that the correct Oracle username and password is specified in the Biztalk Administration panel at WCF-Custom transport properties >> Credentitals>> User name credentitals>>Do not use Single Sign On.


    thank you in advance

    Thursday, May 14, 2009 12:41 PM

Answers

  • To add to Murali's response, in most cases, the UserName is in UPPERCASE, while the password is in the case you normally type. Therefore,
    Username: SCOTT
    Passowrd: tiger
    You can try on similar lines.

    Thursday, May 14, 2009 6:08 PM

All replies

  • The credentials are case sensitive. Can you pls make sure that you've specified in the correct case?
    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
    Thursday, May 14, 2009 12:59 PM
  • To add to Murali's response, in most cases, the UserName is in UPPERCASE, while the password is in the case you normally type. Therefore,
    Username: SCOTT
    Passowrd: tiger
    You can try on similar lines.

    Thursday, May 14, 2009 6:08 PM