community-content

Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 9,648 total)
  • Author
    Posts
  • in reply to: (500) Internal Server Error with HTTP Adapter #16338

    Thanks Man,

    Is there any way to check where is problem lies… Whether BTS adapter is receiving any request or not ??

    I have tired with sample @ SDK .. Its working fine…

    in reply to: (500) Internal Server Error with HTTP Adapter #16337

    Thanks Man

    in reply to: What does Sibling means? #16335

    not sure I agree with this.

     

    <root>

        <base1>

              <something1>

         <base2>

               <something2>

               <something3>

         <base3>

     

    In the above, the siblings are: base1, base2, base3 …. also, something2 & something 3 are siblings.

    Base1 & Something1 are parent/child.  so is Base2 & Something2.

    Think of a sibling as "brother/sister"… not parent/child.

     

     

    in reply to: Debatching Files Flat or XML #16332

    I’ve never done exactly what you are asking.  I think it could be done using custom XSLT. 

     

    If you are not an expert XSLT coder (not many of them), you could always pass the message into a .net component inside an Orchestration.  Then, you could use any type of logic you wanted to sort the message and break it up.  It wouldn’t perform well though and if the message got to big it would “Out of memory” on you.

    in reply to: BizTalk 2004 #16331

    I’m guessing if you opened up HAT, you should use the query builder or modify one of the pre build queries to get this information.  Don’t really know off the top of my head though.

    in reply to: Send flat file to SOAP Receive Adapter through Web Services #16330

    I’ve never really tried this before.  Have you tried receiving the flat file as a String and they calling a Receive Pipeline inside the Orchestration that does the Flat File work?

     

    That might work.

     

    Might be able to do it all on the Receive Location side as well just using a flat file pipeline.

    in reply to: Promoting context properties #16329

    You need to use a Correlation Set to promote the properties when you send a message out of the Orchestration using Direct Binding.  It seems a little odd, but it is the only way to accomplish what you want. 

     

    Just define a correlation set with your property in it and initialize it on the Send Port.  You will not have anyone following the correlation set. 

     

    Charles Young talks more about it here: http://geekswithblogs.net/cyoung/articles/17364.aspx or http://geekswithblogs.net/cyoung/articles/19546.aspx

    in reply to: ASP.Net calling Biztalk Orchestration ? #16328

    Well the easiest way is to expose your Orchestration as a web service.  Then you could just consume it as you would any other web service. 

     

    If you need to use HTTP Post, you’ll need to format your post according to the schema defined for the input into your Orchestration. 

     

    Hope this helps.

    in reply to: What does Sibling means? #16327

    A sibling is related to another node like:

    <root>

      <base>

        <something>

     

    In this example, the something node is a sibling to the base node.

     

    It is also called a Parent – Child relationship.

     

    Hope this helps.

    in reply to: Http Adapter – URI ? #16325

    Are you using one-way receive port to receive the file from the asp.net page….and one way send port to send the result back to the asp.net page.

    If yes then therez the mistake.

    You should use Request-Response receive port…..and you will get the response perfectly.

    Hope you find it helpful.

    in reply to: SQL Schema Generation Wizard does not generate schema #16321

     

    Doug,

    I did try adding a parameter to the stored proc but that didn't make a difference.  Thanks for the tip.

    Greg,

    I tried running a simple select on the generator but I also so no activity in SQL Profiler when running it.  Everything looks good in MSDTC.  The same stored proc does execute from the SQL receive port, so permissions and communications seem ok.

    Anyway, as a workaround, I deployed the BizTalk project to another machine on which both BT and SQL for BT run.  I created a database on this machine with a table and stored proc identical to those from which I was trying to create the schema.  Running the wizard on this machine, pointing to the local database's stored proc, the schema generator worked and I got my schema, which is now working fine on the original BT machine.  When I have some free time I'll try to troubleshoot the original problem out of curiosity but for now I have a workaround.  I'll be sure to post what I find out.

     Thanks to everyone for the suggestions.  They're much appreciated!

     – Shawn 

     

    in reply to: SQL Schema Generation Wizard does not generate schema #16320

    I don't think the stored proc is at fault. Typically if the select statement or stored procedure is at fault you will get an error message.

    Have you checked MSDTC connectivity to this SQL Server.

    A quick check is to run the wizard and use a select statement you know will work
    like: select * from sysobjects for xml auto

    in reply to: Error evaluating Distinguished Fields? #16319

    The problem is the namespace:

    Your message has a namespace of:  http://BizCompTest2.BizCompTest3OutSchema

    While the xpath has a namespace of http://BizCompTest4.BizCompTest4OutSchema

    The xpath namespace is set when you promote the distinguished field in your schema and will match the schema target namespace.  

    You need to change the namespace in the second line of your code above
    Also, if you set the "Use Default Constructor" property on xmlDocVar you do not need the first line. 

     

    in reply to: SQL Schema Generation Wizard does not generate schema #16316

    I assume the proc runs where executed by isql.  Have you tried having parameters in the procedure?

    I usually have a begin and end statement in the proc, but maybe that is implicit.

    Doug

     

    in reply to: SQL Schema Generation Wizard does not generate schema #16315

    Thanks for the ideas Stephen.  I tried simplying the stored proc per your suggestion but the schema still wouldn't generate.  Monitoring SQL Profiler indicates that the wizard isn't even executing the stored proc.  However, if I enable the sql receive port for which I'm trying to generate the schema then I can see that it does execute the stored proc.  The data link settings are the same for both, so it seems that the account has sufficient permissions.  I've also tried just running a select statement instead of the stored proc at the wizard.  The wizard says to not include the xmldata predicate in select statements.  Is this because the predicate's native schema builder handles what the predicate does?  Should I also leave the predicate out of the stored proc?

    Well the main thing I need to figure out now is why the wizard isn't even able to execute the stored prod.

Viewing 15 posts - 6,691 through 6,705 (of 9,648 total)