I have the following error when running my BizTalk package in the server:
The published message could not be routed because no subscribers were found
Package Description: Import a CSV flat file into SQL Server using a stored procedure.
Breakdown:
Create Table Code:
CREATE TABLE [dbo].[Accounts](
[Id] [int] IDENTITY(1,1) NOT NULL,
[AccountName] [nvarchar](150) NULL,
[ServiceAddress] [nvarchar](150) NULL,
[AccountNumber] [nvarchar](50) NULL,
CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Create Stored Procedure Code:
CREATE PROCEDURE [dbo].[InsertAccount]
@AccountName AS NVARCHAR(150) ,
@ServiceAddress AS NVARCHAR(150) ,
@AccountNumber AS NVARCHAR(50)
AS
INSERT INTO dbo.accounts
( AccountName ,
ServiceAddress ,
AccountNumber
)
SELECT @AccountName ,
@ServiceAddress ,
@AccountNumber
Flat File: Named it sample.csv
Account Name,Service Address,Account Number
JOE BLOW,ADDRESS X CITYX IL 61999,932F623Y52
I am using WCF to connect to the database
I created a schema for the flat file
Receive Port Configuration
Send port configuration
I created a message to receive the flat file
I created a message to send the XML to SQL
I dropped the Receive component and assigned the Flat File Message
I dropped the Send component and assigned the Stored Proc Message
I dropped a receive response component for the stored proc
Then I dropped a Construct Message component to initialize the XML document and create the map.
I deployed the package to the server, without deploying to the GAC, Then I registered the component in the GAC manually.
In the server:
I set all the receive and send ports:
Send port
The I configure the application
I started the application:
- Receive Location Enable
- Send Port Started
- I completely stop and restarted the application.
I drop the file, the file disappears and I get the error
I get the following errors
The Messaging engine failed to process a message submitted by adapter:FILE Source URL:C:\Biztalk Test\Sales\SampleFile*.csv. Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.
A message received by adapter "FILE" on receive location "ServerReceiveLocation" with URI "C:\Biztalk Test\Sales\SampleFile*.csv" is suspended. Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.