community-content

Forum Replies Created

Viewing 15 posts - 6,991 through 7,005 (of 9,648 total)
  • Author
    Posts
  • in reply to: SQL Adapter – SPROC Help?? #15868

    Can you execute the procedure outside of BizTalk?

     Is there a reason you are assigning the results to output parameters

     Try

    Select Loan.LoanID, Mortgage.LoanAmount From…

    in reply to: SQL Adapter – SPROC Help?? #15867

    Not sure why you need to select into params.  Just select the columns and then promote the schema attributes if you need to use those values.

    SELECT  Loan.LoanID,
       Mortage.LoanAmt
     FROM Loan
     JOIN MortgageTerms on Mortage.MortageType = Loan.MortageType
     WHERE Loan.LoanNumber = @Loan_Num FOR XML AUTO, XMLDATA

     Or if you need those names…

    SELECT Loan.LoanID as [LnndCaseNum],
         Mortage.LoanAmt AS [LnAmount ]
     FROM Loan
     JOIN MortgageTerms on Mortage.MortageType = Loan.MortageType
     WHERE Loan.LoanNumber = @Loan_Num FOR XML AUTO, XMLDATA

     

    No need to put them to vairables unless you explain why you wanted that.

    in reply to: Biztalk 2006 EDI #15866

    What is wrong with using Covast? There is more to it than just schemas; for example an EDI translator is supposed to be able to perform additional functions some of which I will list:

    1. Document Validation in terms of compliance with X12 and Edifact EDI standards. Covast has a special language for expressing these rules that it validates at parse or serialize time. Your hacked standards will not implement compliance checking.

    2. Presentation of detailed error messages for Compliance Violation.  Shows you where your error or your partner's error(s) is.

    3. Functional acknowledgement reconciliation

    4. Enveloping options – there are a variety for EDI.

    5. Archiving. Are you aware of the legal requirement to archive your EDI transaction for a period of 7 years?  

    etc.

    As an EDI professional, it is not my recommendation to try to go into production with an application that you hacked into "working". In managing an EDI application, there is much more to consider than simply passing a document through an application. 

    It seems strange for Microsoft to enter agreement with a solution provider and then sneak in a KB article about a "hack" to entice users to avoid using their solution partner's product, does it not? 

    Do you all really believe that Microsoft is going to release schemas and that alone eliminates the need for Covast?

     

     

    in reply to: PassThruReceive PassThruTransmit #15865

    Paul,

    You can use BizTalk Deployment Wizard to create Binding XML

    export it and import the xml into u r customer server.

    or

    Create .MSI file and do the same…

    Nar-

    in reply to: PassThruReceive PassThruTransmit #15864

    Paul,

    You can use BizTalk Deployment Wizard to create Binding XML

    export it and import the xml into u r customer server.

    or

    Create .MSI file and do the same…

    Nar-

    in reply to: Mapping sequential xml records . . . #15863

    Seems you could have skipped this if you had defined your parsing schema as having 'NoteToRecord' element subordinate to the 'Record' element.

    i.e Record contains 0 or more NoteToRecord 

    This is assuming you are parsing. otherwise the generator fo the source XML could have stacked NoteToRecord subordinately.
     

     

    in reply to: Multiple invoices in edi file to one xml out file? #15862

    parsing each transaction is how it is designed to work.

    Can you describe the requirement to join them all into one XML file?  Do you need to generate a summary across all invoices from a batch?
     

    in reply to: Select Property within inline script #15860
    in reply to: HOWTO Error Handling in BTS-2006 #15855

    have a look this blog:

    http://blogs.conchango.com/matthall/archive/2005/07/28/1894.aspx

    Hope you got some information.

    Nar- 

     

     

    in reply to: failed to deploy #15853

    I figured it out, it's caused by non-exists reference path in project.

    Right click the project > Properties, in the Pop-uped the window, go to the "Referenced Paths", check if there's any path not exists anymore, this will happen when you move the solution to another machine.

    Delete those path and deploy it, everything's working fine. 🙂

    in reply to: BRE Function Customisation #15852

    Hi, I would really like to know how you did it?  What I'm trying to do this is following.

     Problem:  Needs to access some value from .NET class while processing the rules.

    Approach:  I created a class library with one property called public string getData {get{return "Hello World";";}}

                     I registered the resulting dll in the GAC tool.

                     I then created a new Vocabulary in the BizTalk Rules engine and added a definition of to retrieve data from .NET Class.

                     I then selected my DLL using the BROWSE button.

                     When I'm using this vocabulary in my rules, the string "Hello World" is not being returned? Also I think the whole rule cease to executed     if I use my new vocabulary.

     

    I'm not sure what is happening.  Any help will be appreciated.

     

    Iftikhar.

     

                   

    in reply to: oracle send port problem #15851

     I had a couple of problems….

    The error 'method does not exist' was caused by the fact I hadn't ….
    added generated item
    added adapter metadata
    oracle database … created for the the sendport that I had previously defined

    The namespace wasn't quite right, should have been …

    h ttp://schemas.microsoft.com/[MyOracleDbAdapter://MYDATABASE/MYBIZTALKSCHEMA/Tables/SAMPLE_XCHANGE]

    Last, I did validate the schema, generate instance and then validate instance.

     

    in reply to: Calling a .NET Assembly from Orchestration #15849

    is it possible to call to some method asynchronously ??

    in reply to: XPath Error #15846

    I figured out my problem. The XPath query need to have a surrounded "string()" function call as follows:

    XPath Query:

    string(/*[local-name()='batch']/*[local-name()='rec'][position()='1']/*[local-name()='messageId'])

    P.S. This site is great!

    Thanks,
    –Marcin 

    in reply to: .net Class Library #15843

    There really isn't any problem, you can call it from an expression shape without issues. If the method in your .net class is static, you can call it directly. Otherwise, you need to first add a variable to your orchestration with the correct type, and then call it later on.

Viewing 15 posts - 6,991 through 7,005 (of 9,648 total)