none
How to Achieve This Functionality in BizTalk ? RRS feed

  • Question

  • Hello,

    Project Details

    Data Base Name : Employee

    Table name        :  CityMaster

    Fields                 :  CityId (PK,Numeric(18,0)), CityName(Navarchar(50)).

    Now i have to generate the xml of this file at particular Location using Biz-talk 2010.

    By configure receive port and send port in admin console using orchestration.

    So any one have step by step guidance then reply me.

    Thanks Regards

    Hardik Ramwani

    Wednesday, February 6, 2013 8:31 AM

Answers

All replies

  • hi Hardik

    You can used Typed -Polling functionality of WCF-SQL Adapter.

    Refer Article

    Instead of create StoredProcedure , you can directly done using sql query.

    Regards

    Mohit

    Wednesday, February 6, 2013 10:01 AM
  • Hello,

    I have follow all the steps. Application created & started Successfully, But Output file not generated. While I show in event log i found following error.

    Is their any problem in configuration problem ?  I think about the "BIZTALKWIN7\sa" this is not a valid 

    My SQl Instance is : biztalkwin7/SQLEXPRESS

    user ID : sa   -  Password : XXXXXXX

    =========================================================================================================

    The Messaging Engine failed to add a receive location "Receive Location2" with URL "mssql://biztalkwin7/SQLEXPRESS/Employee?InboundId=ID1" to the adapter "WCF-SQL". Reason: "Microsoft.ServiceModel.Channels.Common.ConnectionException: Cannot open database "Employee" requested by the login. The login failed.
    Login failed for user 'BIZTALKWIN7\sa'. ---> System.Data.SqlClient.SqlException: Cannot open database "Employee" requested by the login. The login failed.
    Login failed for user 'BIZTALKWIN7\sa'.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Adapters.Sql.SqlAdapterConnection.OpenConnection()
       --- End of inner exception stack trace ---
       at Microsoft.Adapters.Sql.SqlAdapterConnection.OpenConnection()
       at Microsoft.Adapters.Sql.ASDKConnection.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.AdapterChannelListener`1.OnOpen(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
       at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)".

    What will be reason this error show in Event Log.

    Thanks Regards

    Hardik Ramwani 

    Wednesday, February 6, 2013 11:17 AM
  • Hi hardik

    it seems some login error

    If you are using windows authentication , use None Option

    if Sql Authentication use User Account Option

    Regards

    Mohit Gupta

    ======================================================================================

     If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.

    Wednesday, February 6, 2013 11:32 AM
  • I have Applied Same...... One More Error  Occur in the Event Log is 

    Wednesday, February 6, 2013 11:50 AM
  • Hi Hardik

    check your orchestration or send port are enlist and started.

    use xmlReceive pipeline

    Regards

    Mohit

    Wednesday, February 6, 2013 12:11 PM
  • Hi Hardik,

    Have you resolved the above issue.

    I am facing the same authentication issue when connecting to SQL Server using WCF-SQL adapter. Though I am able to access the DB from SQL Server

    Tuesday, July 8, 2014 4:38 PM