Forum Replies Created
-
AuthorPosts
-
If you cant use inline XSLT to do what you need (for example, you need to create your own xsl functions etc) I would use the helper class to call XSL with your C# (or VB) functions.
Had your same situation and needed the DB clean last week. There is a stored proc in the DTA db named something along the lines of “purge all completed transactions”
I just run that as needed then shrink the log. Its a good way to clean the DB while still running in production when you dont have an option on taking your servers into maintenence.
Its relativly lightweight and although youll see it drop performance a bit, youll still be moving data at a good speed.
Thanks Nick, I’ve updated my blog post at this link above.
Hi,
Better use a helper class to fix this.It wont be fixed through a simple mapping.You will need a XSLT if you dont want to use a Helper class.
January 2, 2009 at 11:18 PM in reply to: Deployment: orchestration web service proxy on NLB Cluster ?? #21462Dear Friends,
i have posted the same on MSDN forums and i have got couple of replies from techies , for more info please go ahead with the following forum discussion.
Thanks Alot!!
Rajesh Gorla.
After I installed the Biztalk server, I did run “Biztalk server configuration”. The configuration failed indicating an Enterprise SSO error. I checked out the SSO administrator and tried to add my machine, I was unable to change the status of my server to active in the SSO administrator. On the status it showed no SSO database and the status of my machine was represented as “Question mark”. I tried to create the SSO database from within the SSO administrator, this was also not successful. This was the reason I thought the SQL server could be an issue.
So essentially SQL server install was successful, Biztalk server install was successful but Biztalk configuration was not. Based upon the knowledge base on errors the problem seemd to be with the SSO, but since I cannot add my machine in the SSO console, I am at an impasse as how to proceed.
December 31, 2008 at 10:07 PM in reply to: Deployment: orchestration web service proxy on NLB Cluster ?? #21458I have been thru the following article but still not clear with the blue box in all depicted diagrams. Where the web service is hosted? On BizTalk boxes? In that case why blue box is not within the orange box ?
Scalability of “SOAP adapter” while maintaining fault tolerance using Network Load Balancing (NLB).http://msdn.microsoft.com/en-us/library/aa972198.aspx
I don’t know I am really confused do you guys think my post has any valid points to consider for discussion?
–Rajesh Gorla.
December 31, 2008 at 9:40 PM in reply to: Deployment: orchestration web service proxy on NLB Cluster ?? #21457Dear Friends,
Happy New Year!! i am just updating one reference i have found to the above open item.
http://arnulfowing.blogspot.com/2007/08/how-to-publish-odx-on-machine-without.html
Still not clear, working around with WCF Adapter for alternative..still expecting some replies..
Thanks,
— Rajesh Gorla.
If its a requirement to process the messages in order, then implement singleton pattern. Only one instance of orchestration will process the messages.
But if its not, I guess you need analyze the causes for database locks and try to avoid them.
-try using stored procedures
-minimize the scope of database transaction
Also check SecureBlackbox for BizTalk and it’s SFTP adapter.
I used this one
http://www.codeplex.com/SftpAdapter
and it worked well for me. My needs were simple and the performance requirements were not extreme.
/n Software includes SFTP/FTPS/OFTP adapters in their BizTalk adapters suite. Here’s the info on the SFTP adapter
Correct me if I understood your problem. You are saying that after you install BTS, you dont see the databases. Thats right, you need to run the “BisTalk Server Configuration” tool after installation.
Do you mean that the databases are not getting created even after running the configuration wizard. If so check the event log for errors.
Looks like the service account that currently runs SSO Service does not have required access on the SQL Server database. Ensure that the user account has access to databases in SQL Server.
December 26, 2008 at 4:08 AM in reply to: How to implement Canonical Message Pattern using BizTalk Server 2006 R2 #21443Anon,
A few links to get you started:
- http://msdn.microsoft.com/en-us/magazine/cc163423.aspx – 8 Tips And Tricks For Better BizTalk Programming
- http://lingenfelder.wordpress.com/ – Create a Canonical Schema – Step by Step.
Nick.
-
AuthorPosts