community-content

Forum Replies Created

Viewing 15 posts - 841 through 855 (of 9,648 total)
  • Author
    Posts
  • in reply to: How to handle response messages you don’t want? #25383

    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! 🙂

    in reply to: Debatch a flat file and drop in database #25382

    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.

     

    in reply to: Connecting to MQSeries via a WIndows Box #25379

    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.

    in reply to: How to handle response messages you don’t want? #25378

    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.

     

     

    Hi,

     

      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.

    in reply to: WCF-SQL LOB Adapter – How to change configurations #25376

    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

    http://blogs.msdn.com/blogfiles/sachipa_biztalk/WindowsLiveWriter/Err.TransactionProxyExceptionduringConfi_2B3/image_4.png

     

     

     

    in reply to: WCF-SQL LOB Adapter – How to change configurations #25374
    in reply to: How to handle response messages you don’t want? #25372

    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.

     

    in reply to: Root element is missing?? #25371

    source schema of the map may be not deployed properly.Try to redeploy the input schemas and check…..i hope it works…

    in reply to: Routing methodeology #25370

    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

    in reply to: How to handle response messages you don’t want? #25369

    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!
    Christophe

    in reply to: Schedule Question – Receive Location #25368

    Hello Daniel.

    Thanks a lot for your reply – I will check this out.

    Thanks again.

    Wolfgang

    in reply to: Poll While Data Found #25367

    Hi.

    Thanks a lot for your answer and your reply – no it is clear.

    Thanks for the link.

    Wolfgang

    in reply to: Routing methodeology #25366

    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…?

     

    in reply to: Default Receive Pipeline #25365

    I had similar problem and all i did was remove old assembly from GAC, change assembly version and reploy… all worked  [:)]

Viewing 15 posts - 841 through 855 (of 9,648 total)