none
Send Port Exception Handling In Biztalk Server 2006 RRS feed

  • Question

  • Hi All..

    I have developed a Biztalk Solution where i used SQL Data at receive port using stored procedure and send this to SAP port where in response i get some token number which i need to store back to SQL table aganist serial number...

    In production environment i am concerned if SAP port fails how should i handle exception ..my objective is not to pick the same data from SQL instead if i can use something like retry on Port untill port starts to work ..but if i use this then the receive continously picking data from SQL so number of Xml will increasing ..which i think i not a good solution

    Instead if we can reset flags in SQL table if exception is there ..or if we can stop receive port to not pick further Data from SQl...

    What would be the ideal procedure to work for this senario in prodution Environment..

    Thanks

    Sandeep

    Friday, May 1, 2009 6:49 AM

All replies

  • Hi sandeep

    i am facing problem from 4 days

    sap version is 6.0,biztalk is 2006,framework 2.0,os windows server 2003

    i want to intigrate biztalk with sap server

    i am connecting sap server with our sap adapter .

    i am following below steps

    step 1.right ckick solution  add genarated items-->add adapter metadata
    2.select sap  then in add adapter wizad -->after finishing sap adapter properties(like system,username,password etc)
    3.in search window i am selecting idoc as order in this select one check box then next after this i am getting the error .

    this is visual studio error :

    EventType clr20r3, P1 devenv.exe, P2 8.0.50727.42, P3 4333e699, P4 sapadaptermanagement, P5 2.0.1.0, P6 411be7c3, P7 74, P8 3a, P9 if2kqpmkbiyloiigzqv4ukgfrz3wqoqr, P10 NIL.



    let me tell u some thing

    1)i am thinking this was licence problem

    is it correct

    2) our sap adapter is third porty tool am i right

    is it support for our biztalk with out licence...


    plese help me...

    regards
    vittalaranga

    Monday, May 4, 2009 5:45 AM
  • Hi Vittalaranga,

    I think you have to use Microsoft BizTalk Adapter for MySAP Business Suite v2.0 ..This would be compatible for Visual Studio 2005 ..Pls check which version of Visual Studio are you using..

    Thanks
    Sandeep 
    Monday, May 4, 2009 9:38 AM
  • Hi

    let me tell u installation of biztalk server 2006..

    here i  installed biztalk 2006 (frame work 2.0,visual studio 2005,sqlserver 2005),after installing biztalk i am not getting sap adapter in my adapters.

    so for this i installed Connector_Ver1.0.3 and BiztalkAdapter_SAP(this was downloded from google) after this i have sap adapter in adapter list
    using this sap dapter  i am  configuring sap server ,when i am connecting sap server here i am facing problem....


    regards
    vittalaranga

    Monday, May 4, 2009 10:01 AM
  • Pls use Biztalk Adapter for MySAP Business Suite v2.0 from the following link

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5594f7-d31c-4930-b3bc-9ab3ad42b6f1&DisplayLang=en

    Regards

    Sandeep

    Monday, May 4, 2009 12:04 PM
  • Hi sandep

    thanks to u , help a lot...

    i am connecting to sap successfully....

    prob is MySAP Business Suite v 1.0 ,that was not suporting to vs 2005.

    now i installed MySAP Business Suite v2.0 it is working fine....


    Regards
    vittalaranga
    • Marked as answer by Sandeep.Handa Thursday, May 7, 2009 3:55 AM
    • Unmarked as answer by Sandeep.Handa Monday, May 11, 2009 2:28 AM
    Wednesday, May 6, 2009 11:52 AM
  • Hi All.
    My question still unanswered..
    My question was regarding exception handling in Send Receive Port.
    I am fetching employee data with unique serial number and sending this to SAP in response SAP returns some receit number which i again store back in SQL table ..
    Now senario is if due to transmission failure or if wrong data is send to SAP ..i get either warning in Biztalk Console or i get error..
    Client is asking to handle error or warnings by send mail to Administrator and reset the flags in SQL table so that it can again be ready for SAP...
    How can i catch exception and second how i can read elements in suspended messages so that i can reset flag in database having unique serial number mentioned in Suspended Xml..

    Pls Help me out..
    Thanks
    Sandeep
    Friday, May 8, 2009 11:51 AM