[community-content]

You will need to use a Trigger to create a message and send this to Biztalk.
There would be a number of options for sending the message including MSMQ or SQL Service Broker .

Check out Jesus Rodriguez SQL Service Broker Enhancements on GotDotNet:
[url]http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=f2e863c6-3444-47ae-8d13-668484a449f9[/url]

[community-content]

It would appear that you have installed Biztalk developer using the same Biztalk Server group as production i.e. both Biztalk servers are sharing the same database.
You have two choices.

1. Upgrade production to the Enterprise version
2. Remove the Developer server from the Biztalk Group.

The best option would be 2. You do not want your development server connected to your production database.

You will need to reinstall the development server using a different SQL Server.

[community-content]

The variable values are UrlEncoded by the sender. All characters that ar illegal in a url are converted into their escaped values e.g. %2A etc.

In the map I supplied earlier I call the System.Web.HttpUtility.UrlDecode() method for each value variable to convert these escaped characters back to their original character value.

I also have a map that will does the opposite i.e.
from
<FieldA>Value1</FieldA><FieldB>Value2</FieldB>
to
<Items><Item><Name>FieldA</Name><Value>Value1</Value></Item>…….</Items>

This map also calls UrlEncode to escape to illegal characters so they can be HTTP Posted.

This assembly is generic and can be used for any Html form interface.
Let me know your email address and I will send you the assembly and source

[community-content]

Another problem i ran into, i needed to http post back so i needed to map something like:

<FieldA>Value1</FieldA><FieldB>Value2</FieldB>

into

<Items><Item><Name>FieldA</Name><Value>Value1</Value></Item>…….</Items>

It was easier going in reverse using a Value Mapping (flattening)

any idea how to do this?

Thanks

[community-content]

So i receive an HTTP Post with Form Variables. The values of the variables containing characters such as (‘:’,’/’,’) become ;amp, %2A, %35…etc

the question is, how do i convert this to normal text?

Is creating a scripting functoid that takes \”string html\” as parameter and does something like html = html.replace(\”%2A\”,\”:\”); ?

That’s what i have right now, is there a better way?

I am not sure if i rmeber the codes right….so pls dont call me on it 🙂

[community-content]

the problem is, it needs to be a direct response to that request which is being made by the other party. it seems to me, the scope is changed one you are in the exception code because if an exception occurs there is no quarantee for the receive shape to be successful and therefore there cannot be a corresponding send shape….. 🙁

[community-content]

Not sure on this one. I have not seen that before.

Did you make sure you installed all the SQL pre requirements like SQL Xml, etc?
I’d double check the list and make sure you had them all.

Also, make sure you are not using VS 2005 and SQL 2005. That’s not supported with BizTalk 2004.

[community-content]

I think i am getting closer to a solution to my problem. I created MessageAssignemtn shape and then I am trying to send a msg type System.String from a HttpRequest-Response with a Passthrough pipeline.

Now i have another problem. All my shapes are inside a scope shape and I have an exception handler which catches System.Exception. So what i want to do is, inside the Scope shape, send an html msg with sucess as a reply to the original http post. or if something inside the scope fails, send a failure html msg to the same port where i got the request from as a response. Now that’s a problem since the Receive shape is not in the same scope as the Send shape that resides in the ExceptionHandler.

Any ideas?

[community-content]

So I have an HTTP Request-Respond port. I receive an http post on that port, parse the variables, do what i have to do basically. Now I need to send a response but I am not sure. Can I just send HTML back through a PassThrough Pipeline? If so, I have a generic message I want to send. Something like,

[code:1:b706d9b817]
<br><br>Your order has been received. Thank you.<br><br><center><a href=’javascript:window.close();’>Click to close</a></center>
[/code:1:b706d9b817]

of that nature……

I was thinking that i’d have to use a transform shape and create my own XSLT code with the HTML and the use it in a MAP? That sounds too complicated for a thing like that.

So basically, I need to be able to respond back with HTML.

Anyone have any idea on how to accomplish this?
Thanks
Gino

[community-content]

nice.thanks alot. very useful. I am sure other people will find use for this too

[community-content]

Oops forgot to log in for that last post.

I tried to use the standard mapping tool, but this has some limitations. So I ended up with the custom Xslt.

To create a map using a custom Xslt is relatively simple.
1. Create your Xslt file and extension Xml file and add to project.

2. Add a map to your project, specify the source and destination schema and click on the map grid.
3. You can now set the compiler properties, Custom Extension Xml and Custom Xsl Path

You now have a Biztalk Map that uses the custom Xslt.

[community-content]

thanks for the input guest.

In light of what you said about generic maps. I was just wondering, is it possible to somehow send the name of a destination field into an \”=\” functiod so that it is not needed to type in each fieldname in each \”=\” functoid but instead just drag-drop?

Thanks

[community-content]

Greg,

I really appreciate the response. Sorry I couldn’t get to this forum to post sooner but I have figured out the problem exactly the same way that you have described. The only thing differnt with my solution is that I read the POST Stream where the Form Variables are in the form of

FieldA=Value1&FieldB=Value2

so what i did is i created a flatfile schema which parses it into

[code:1:52537684d8]
<Items><Item><Name>FieldA</Name><Value>Value1</Value></Item><Item><Name>FieldB</Name><Value>Value2</Value></Item></Items>
[/code:1:52537684d8]

after that, i have a map which transforms it into

[code:1:52537684d8]
<Record><FieldA>Value1</FieldA><FieldB>Value2</FieldB>
[/code:1:52537684d8]

using Value Mapper (Flattening) shaps along with \”=\” shape.

Is that a good way to do this? Any suggestions are welcome.

Btw, I’ve encountered a problem where Biztalk kept giving me error msgs about the schema used in the pipeline not being properly deployed. I checked and it was GACked and everything seemed fine but still didn’t work. So i had to create a new Biztalk project and went it went through fine and i got it to work finally.

Gino[/code]

[community-content]

Thanks,
The thing was that it was not getting loaded to the SQL tables because I figured out later that the Stored Procecdure had the database name prefixed which was not correct.
It ran fine after I modified the Store Procedure.
Thanks

[community-content]

Dehydrated means the service instance is waiting on some event and has been removed from memory – state is maintained within the database.

This service instance will be rehydrated when an event, it is waiting on, occurs.

This is a mechanism to free resources on the server. Some service instances can last hours, days or even months. Rather than maintain all service instances within memory, they are dehydrated after a period of no activity.

If your service instance has been dehydrated, you need to determine what it is waiting on.
Have you checked the event log for error messages

[Author]

Posts