Posts

Showing posts from March, 2009

Application File Not Valid in XBAP

Image
When you see this error in XBAP application, which means you changed application manifest file from outside. To resolve this
we can use .net tool, which comes with .net SDK, called mage.exe or mageui.exe. More about mage.exe Frequently used commands to resolve this is mage.exe -u and mage.exe -cc. Actually this really happened to me, for one user, problem was remain even use mage.exe until he re-install .net runtime.

How to create Biztalk schema from FOR XML EXPLICIT

Image
It's very straightforward to create Biztalk schema for SQL adapter if we use FOR XML AUTO. But we'll come across that FOR XML AUTO is not enough to get data from SQL, so that we use FOR XML EXPLICIT. In this case we have to follow some additional things to get biztalk schema generated properly. I''l go step-by-step with an example. This situation really came to me that's why I motivated to do this post.

Assume my SP,BIZTK_GetPPS300Attributes @pono, will generates required XML data set with FOR XML EXPLICIT.
Open Visual Studio and switch to Biztalk Explorer.
Create a Receive Port.
Create a Receive Location for that port and set following properties

Set Address(URI) property as following

Value of Document Root Element Name will be Root Element of schema.
Document Target Namespace will be schema's target namespace
For this example SQL Command will be exe BIZTK_GetPPS300Attributes 12345

Create a send port and set following properties

Enable Receive Location and start Send po…