Sql adapter receive ports

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Sql adapter receive ports

Viewing 1 reply thread
  • Author
    Posts
    • November 29, 2006 at 1:30 AM #16581
      community-content

        hi,

         

        i have many sql receive ports.

        many times in logs i get connection failures and then an error that

        error threshold has increased and ports are shutting down.

        then ports are shut down and we need to restart ports

         

        is there any soln for same

      • December 2, 2006 at 2:28 PM #16675
        community-content

          I think you’d need to build a windows service to response to the WMI event of the receive location shutting down.

          • December 13, 2006 at 3:19 AM #16871
            community-content

              hi,

               How will i get the wmi event of port shutting down.

              what should i write in the service.

               

              thanks and regards

               

              Shreyas

              • December 13, 2006 at 5:06 AM #16874
                community-content

                  I’m not sure exactly what you want to listen for.  Best thing is to check the SDK and then the help guide.  The list all the WMI events.  I think is one for RL shutting down.

                   

                  You could also look at using a monitoring tool like MOM – but that can cost a lot of extra money.

                  • December 13, 2006 at 10:42 PM #16892
                    community-content

                      hi i want to listen the receive location shutdown event

                      • December 14, 2006 at 10:41 PM #16939
                        community-content

                          You should be able to write a simple Windows Service to do this.  Might even be something on DotGotNet that already does something close to this.

                           

                          If you download the sample code with my BizTalk 2004 Convoy Deep Dive white paper, I have a listener for Zombies.  You could always modify that for the other WMI event.

                          Hope this helps.

              • Author
                Posts
              Viewing 1 reply thread
              • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.