Forum Replies Created
-
AuthorPosts
-
Thanks again! 🙂
About the custom pipeline component:
That’s what I did, indeed 😉 But I keep on getting that error… It’s strange though, because I find the same information when I google a bit for the problem. It seems there must be something else wrong with my piece of code? When I step through the code (debug it), it gives no errors. But when I check the eventlog afterwards, I get the “object reference not set to an instance of an object” errors…Here’s the piece of code I’m using:
public Microsoft.BizTalk.Message.Interop.IBaseMessage Execute(Microsoft.BizTalk.Component.Interop.IPipelineContext pc, Microsoft.BizTalk.Message.Interop.IBaseMessage inmsg)
{
string messageTypeIncomingMessage = “”;
object oMessageType = inmsg.Context.Read(“MessageType”, “http://schemas.microsoft.com/BizTalk/2003/system-properties“);
if (oMessageType != null)
{
messageTypeIncomingMessage = (string)oMessageType;
messageTypeIncomingMessage =
messageTypeIncomingMessage.Substring(messageTypeIncomingMessage.IndexOf(‘#’) + 1);
}// Make sure the properties aren’t null and the messageType was found
if (!String.IsNullOrEmpty(messageTypes)
&& !String.IsNullOrEmpty(messageTypeIncomingMessage))
{
String[] messageTypesArray = messageTypes.Split(new char[] { ‘;’ }, StringSplitOptions.RemoveEmptyEntries);// Loop all elements to check if the message needs to be ignored
for (int i = 0; i < messageTypesArray.Length; i++)
{
string messageTypeFromArray = messageTypesArray[i];
if (messageTypeIncomingMessage == messageTypeFromArray)
{
// messageType was found -> message needs to be ignored
return null;
}
}
}return inmsg;
}About the null adapter:
Thanks a lot for the information about the 64-bit systems! This adapter works like a charm and does exactly what we need it to do! Great! 🙂
Hi,
The better approach depends on how many rows of data from the debatched flat file you are expecting to insert into a DB table. Is it in the hundreds? Thousands? Millions?
If you have a fairly small set of records and don’t expect it to grow or vary widely over time, I would recommend using WCF SQL Adapter to insert the rows into the DB table.
If you have a large set of records (i.e. think ETL, datawarehouse style), you should look into implementing a custom .NET helper class (that can invoke the BCP program from the command line, bulk copying your records in an efficient and fast way to your DB table) that can be called from BizTalk.
Hope this helps,
Daniel.
Hi,
If I remember correctly – MQ Series Adapter needs configuration in COM +, last version I worked with it was 3 years ago, and it did need configuration as described here: http://msdn.microsoft.com/en-us/library/aa561858(v=BTS.20).aspx
Also need to cofigure MSDTC.
Hi,
If you intend to use the null adapter, it should be registered with “32 bit” reg (read this article http://www.biztalkgurus.com/blogs/biztalksyn/archive/2008/04/23/registering-null-adapter-on-64-bit-machines.aspx )
I downloaded solution for null adapter from winterdome site, and compiled the adapter. There’s no installer, but you can write one 😉
For me, it’s just ll wich needs to be in GAC and registered with *.reg file. Very simple, very useful.
July 26, 2010 at 1:16 PM in reply to: Create a complex flat file schema using the flat file schema wizard #25377Hi,
If you haven’t figured out by now, you should create a second schema that conforms to your output XML structure, and a map that transforms your flat file schema to that XML schema.
HI Neal,
1. The URI can be changed, in this pattern: mssql://SQLServerName//DBName? -You can configure connection to database by wizard – button “Configure..” above the URI should be
2. Username and password – need to be added, if you don’t use windows authentication – in “Credentials” tab, in configuration of an adapter.
3. Is MSDTC configured for working in distributed environment? See this links:
http://msdn.microsoft.com/en-us/library/aa544733(CS.70).aspx
Hi Christophe,
If you want to give the custom pipeline another shot, I found this statement somewhere on the internet:
“Say that you want to write a custom pipeline component that writes some data into a database and
don’t want to include further BizTalk processing. Once the database write is successful you do not
need the message anymore. You do not want the engine to write any data into the message box,
basically one message gets into the pipe and none goes out.
What you need to do to support this scenario is to return null from the IComponent.Execute,
IDisassemblerComponent.GetNext or IAssemblerComponent.Assemble methods“See if you can make this work, otherwise go with Yonathan’s example.
Daniel.
source schema of the map may be not deployed properly.Try to redeploy the input schemas and check…..i hope it works…
Hi,
For an explanation of the Group Min Occurs and Min Occurs properties, see the following MSDN articles:
http://msdn.microsoft.com/en-us/library/ee254031(BTS.10).aspx
http://msdn.microsoft.com/en-us/library/ee254070(v=BTS.10).aspx
Thanks for the replies!
The solution with the custom pipeline doesn’t seem to work though… If you return null, you get an error in the eventlog saying Object reference not set to an instance of an object”… So I think this means it’s not possible to return null from that method?
The solution with the null adapter seems to work exactly as we wish for! There does seem to be a little issue in getting this adapter to work on a 64-bit environment, though… Isn’t there a good installation-file for that adapter? Or a complete (as in “also for 64-bit”) installation-guide for it?
Thanks!
ChristopheHello Daniel.
Thanks a lot for your reply – I will check this out.
Thanks again.
Wolfgang
Hi.
Thanks a lot for your answer and your reply – no it is clear.
Thanks for the link.
Wolfgang
Hi ,
Thanks for your reply…
hey i have another doubt…
what is the difference between group min occures and min occures in xml schema properties…?
I had similar problem and all i did was remove old assembly from GAC, change assembly version and reploy… all worked [:)]
-
AuthorPosts