[community-content]

I’m sure I’ve seen that error before.

You might want to check and make sure your user is a member of the SSO Admin group.
Also, make sure you have all the default values set like Send Pipelines.

If you have existing Send Port and Receive Locations, can you view them and change properties? If so, then the above is not the problem.

[community-content]

I don’t think so since it uses features not available on SQL Express like SQL Integration Services.

[community-content]

Wow.

Have you contacted Microsoft Support about this? Is there anything they can do?

I’ve never worked with Schema that referenced items that crossed projects myself.

[community-content]

Here are some ideas to focus on:

1) Does your SQL Stored Proc work in Query Analyzer? Remember that if you follow my prior instructions, every time you run it, it will update the database, so there will no output when you run it again – unless some other job has inserted new data back into the database.

2) For a quick test, you can just create a flat file send port and subscribe it to the SQL receive port. Then you can test without an orchestration. The receive port should run every x minutes, and the send port should be able to grab the output (in addition to the orchestration).

3) Check the event log (and HAT) for errors but with SQL, often the messages in the System Event Log are more specific and helpful.

Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End User Videos

[community-content]

I have switched to doing complex maps like this all in XSLT (and using Stylus Studio to debug).

Following is one way to do it that comes to mind – there may be better alternatives – if someone knows one – please reply also!

Here’s an idea of how to do it in native XSLT – do a for-each loop on something like:

/ItemDetails/Orders[Branch1/Type01/Name]
i.e. select all Orders that have a child called \”Branch\”.

Then build a variable that will contain another XPATH to lookup the other values – your goal will be to build a variable that equals something like this:

/ItemDetails/Orders[ID=’Order01′]/Branch1/Type02/ItemCode

The trick is you have to contatenate in the value ‘Order01’ from the order you current have in your for-next loop.

Then you use this Xpath/Variable to build a select statement and copy over the item, then repeat the same type of logic for the \”type\”.

Another idea – I have a complex map I’ve been working on – and I have seriously been thinking about not using a map at all, but using a C# static helper class/method. If you know C# and XML classes well, this might be a valid alternative.

I suppose you’ll also have to create a CSV flat file schema.

Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End User Training

[community-content]

Hello,

I have an installation of BizTalk 2006 and I am using it on a test domain, and stupidly one of the users delete all of the user accounts that we had made in A.D. so now we can’t do anything with BizTalk 2006. This isn’t affecting our production network, but I don’t want to have to reinstall everything on our testing network.

Does anyone know of a way to get BizTalk to map to diferent user accounts, or a way to remove Biztalk manually?

[u:a9e16dc6bd]Thank you very much!!![/u:a9e16dc6bd]

[community-content]

Thanx both …I think I have got a break to it, however, Some problem still remains.

I have made a receive node as the first node and have made a SQL Adapter configured to receive . Then I have transformed the received message to a schema and then send it using usual send port to a folder.
I have made a receive port configured to SQL Transport and have made it receive my Sql Adapter messagena danother send port configured to the particular folder.

am I doing it the right way…. well, it looks right to me… 😀

However, no output is comming to the output folder.

Please confirm the same to me.

If I have forgot any aspect please guide me with it.

Thanks

Neha

[community-content]

hi

first of all i thank you for the reply nishil

let me be more descriptive on what i require. for e.g if you have an interface which as an Receive port A and do some Buziness processing (either using orchestration or not even using orchestration) and give the output to Send port B and one more Send port C to some other systems.

The count i require is to be 3 that is 1 input to the hub and two output as spike(hub and spoke model).so at an end of the spcific period if i run the query i should get total count based on the above logic.(i dont know whether this can be achieved at a single stroke)

so am looking in to the Database to find out which table in the biztalk databases can provide me such type of count.

The solution which you provide wont work it there is no orchestration at all for some interface.can you pleas suggest me any thing on the subscription tables or any other way to obtain the neccessary output.

Thanks once again for you esteemed help,expecting the same

[community-content]

I’m not sure why you need a multi-part message.

There should be steps elsewhere in this forum of how to use the SQL adapter. You will have to write an orchestration to call the SQL adapter with a send and receive the result back (use a request/response type of send port).

Then you can create a \”flat file\” schema. Flat files schemas can be either CSV or positional. I’m not sure where instructions are on how to build this type of schema – but it’s probably on the web somewhere (I have also have a video on this topic and the SQL adapter on my website below.)

Then in your orchestration, map the response from SQL to the flat file schema and send it to a flat file send port (or maybe even an FTP send port). Biztalk process userid will have to write access to the output file directory.

Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End-User Videos

[community-content]

Hello

has anybody an idea how to use a bizTalk project. I mean, after making the orchestrations how can I consume them in a web application?

My application is OnlineBooks. The user enters the book info that he/she searches, into a web-page. This info is sent to book suppliers as a message, XML doc. Then the suppliers search for the book in their database. And they send the found book(s) info and price to OnlineBooks(OB) in a XML doc. And OB presents this info in a web-page to user.

OB -> supplier (BookRequest message)
supplier -> OB (BookResponse message)

I make this project with BizTalkOrchestrations and ASP.NET project.

After making orchestrations, how can I integrate it to web application?

by the way, thanks for the answers of my earlier configuration problem. as u guess, now it works? :))

[community-content]

You can achieve this by Multipart message. Request is SP call and Response is data from SP in a form xml document. U can map that outputted data in any form you want.

Mohit

[community-content]

Thanks a lot to both of you.. Both the solutions just worked fine.

[community-content]

I started thinking about this some more – so apparently XML doesn’t support things like – or even   (I just now noticed your URL’s in your original message – sorry I didn’t look at them earlier.)

Since   is more common I googled it and found this:

http://lists.xml.org/archives/xml-dev/200009/msg00048.html \
  is not a default XML entity. Either use a DTD to define it or use the
unicode hex value directly in the entity (Š IIRC).

http://www.xml.com/pub/a/2003/01/02/xmlchar.html
http://xmlchar.sourceforge.net/

http://www.dwheeler.com/essays/quotes-in-html.html

But I’ll stick with my earlier statement that your trading partner must send your well-formed XML.

Neal

[community-content]

Okay, let’s go back to the original issue. According to Stylus Studio, the XML is not well-formed. Even Internet Explorer browser says:

Reference to undefined entity ‘ndash’. Error processing resource ‘file:///C:/TestNdash.xml’. Line 1, Position 37

So rule #1 of XML is that XML has to be well-formed. How can another company send you XML that is not well-formed?

In my opinion, they must provide well-formed XML.

If they refuse, then you must somehow translate it to well-formed XML, probably through writing your own ReceivePipeline.

Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End-User Videos

[community-content]

That’s an easy one – when you add a Receive Location and set the \”TransportType\” to SQL, click the \”…\” by the property \”Address (URI)\”
then set the property \”Polling Interval\” to 5 and \”Polling Unit of Measure\” to minutes.

Neal

[Author]

Posts