Forum Replies Created
-
Posts
-
thanks for your reply. the sample was helpful.
i was wonder though if there is a possibility to create a simple html page, insert my xml inside the form tag, set form action url to my virtual directory, and then post the page via html submit button? Is that possible?
thanks again…
You can do this using HttpWebRequest. There are lots of samples around the net for that (here's one, though not the best: http://www.netomatix.com/Development/XmlWebRequest.aspx).
Thanks for your replies. the expression got crazy trying to put in the namespaces and local-name's stuff. but whew it worked.
Anonymous,
This "stripping off" is called parsing, and the translator breaks the EDI document into each ST-SE as it transforms them from EDI to their XML representation.
You can select fields to carry across into "property bag", which goes along side each individual ST-SE transaction from the batch and it is available to allow the document to be "routed" via the publish-subscribe mechanism. So you make receive ports that subscribe to the flow of particular transactions on an arbitrary basis. These ports are then linked to maps.
– weak architect
Without knowing the entire solution and where BizTalk and SQL Server may fit into the bigger picture, I'm trying to restrict my line of thought to what I've seen and/or how I would approach this from a BizTalk angle. I spend hours and sometimes days try to convince customers NOT to use BizTalk when it makes no sense…especially when I either have to support the effort or build the solution. It ends up being a waste of time, effort and money…so I see where you're coming from.
That said, I've seen DTS used where either it shouldn't be or where it performed poorly when it was not expected to do so. I'm leaving those suggestions and decisions to the architects responsible since they know far more than I about the current project. I like using sprocs for various reasons. It can hinge on where the maintenance falls and the comfort level of the folks responsible at the end of the day. Back to the point, I think, my suggestion…if using BizTalk…is to NOT do table inserts in the map, and use Orchestration for the logic. However, I won't dispute anything you suggest because you have the knowledge to make that assessment, and I'm only looking at BizTalk. Sorry for being long winded.
I hope to see how this is ultimately resolved.
The table I was inserting to was set to a decimal so it chopped off all the leading zeros. Thanks for the replies !
Hi,
thank you for your answer. I'm using HAT for to terminate suspended messages but error is the follow:
"One or more service instances could not be terminated. It is possible that the instance has already completed or terminated, or it may have a pending control message".
For me is important to cleanup msgboxDB.
Anyidea?
Sajid –
I believe that if the transactions are small and the server is not overloaded, this will work fine. Given the fact that it was already com/.net, that implies that volume should not be an issue as you are not changing that much technology. I see no reason why this would not work well in Biztalk.
Can you kindly keep us informed as to how well this solution works?
– wa
BizTron – He has to take records from a file, compare them with values in a table and move the results to another table.
It appears that the file data only has to get into the database and then all of the compare and table load can be done there.
Wouldn't it be easier to DTS the file in to SQL Server and then trigger a sproc to do the compare with the first table and the insert into the second table?
-wa
[quote user="Anonymous"]Hello,
I have a xml source file and will pass through Biztalk and transformed to flat file.
In my source xml file, some special character will be included, (e.g. úóíá) and the file failed schema validation, here's the error:
An error occurred when parsing the incoming document: \"Invalid character in the given encoding.\"
The source file doesn't have XML declaration included. And the schema i created in BTS 2006 has the default:
<?xml version=\"1.0\" encoding=\"utf-16\" ?>To solve this problem i want to change the schema encoding to
<?xml version=\"1.0\" encoding=\"iso-8859-1\" ?>But i didn't find any attribute in XML Schema for source file to change the setting that like what we got in Flat File schema, change \"Code Page\" to set to other encoding, though i didn't find iso-8859-1 there.
If i changed the encoding for source file, do i need to change it for transformed schema (in this case, flat file schema) as well?
Can anybody shed some light on this?
Many Thanks.
Merry[/quote]
I would suggest using an orchestration to help with the logic instead of trying to return data using the map. Of course, I'm not saying it won't work, but I've run into similar issues. I created a sproc and send the data out a port then use the response(s) for other decisions. It's easier to regenerate a schema if things change than to rewrite the custom functoid everytime you need more parameters IMHO.
If you write the functoid, you should look at the performance differences and make an educated decision. I think it makes sense to do simple lookups in the map but leave wholesale data exchange to a request-response port. Then an orchestration can string it together.
If this is the only Warning/Error you are receiving, it should build and deploy. Since you just downloaded it, I'll ask…
- Is this the first time you're trying to deploy?
- Did you create a strong name key?
- Are you deploying from the solution or the project?
- Is this installed on XP or Windows 2003 Server?
- Is SQL Server running?
- …in other words have you checked-off the installation and configuration list?
So I assume you also installed "Microsoft BizTalk Adapters for Enterprise Applications", or you wouldn't have this message. Can you say at what point this error occurs? …When you Select the type, hit the configure button, enter a password, save the properties (OK/Apply), etc.
- Did you have to add the Adapter (under Adapters) manually after you installed Enterprise Adapters?
- Do you have other Oracle ports configured? Working?
Actually having the Oracle Client installed and ODBC configured shouldn't matter during configuration, only execution. Please, someone confirm this if I'm wrong…since I haven't actually tried this scenario. That said, what Oracle client are you using? (8i, 9i, 10g)
If this is a first time event for you, I'm sure there is something I can help with if you need this working soon. If it's the first time you've see this error where other ports are working, then it could take some thought.
Thanks for your repsonse.
I did shut down Visual Studio, even did the extreme and did the "Microsoft Fix" and did a reboot. When all that did not work I built a new simple BizTalk app and still the warning was there. With that warning I cannot successfully deploy my app.
I do appreciate your feedback, and will keep digging or see what other responses I may get.
Dave
