Forum Replies Created
-
AuthorPosts
-
Hi,
Maybe it’s a matter of refreshing the reference to your SAP function module in the VS IDE?
Good luck!
I worked on this all day Friday and tried again this morning and it seems to have worked.
Maybe BTS just needed a weekend.
Thanks,
g
This makes a lot of sense – thanks for the clarification Greg! Ok, I am going to work on a proof of concept today with the aproach you have described. Thanks again!!
Any chance of seeing the rest of your class definition.
Although you mark your class as Serializable, if it contains a non-serializable class, it will throw an exception at runtime.if your stored proc signature looks like this:
bts_Load_XmlData @loaddata XMLThen your message will look like this:
<Request xmlns=”yournamespace”>
<bts_Load_XmlData loaddata=”<escaped Xml as a string>” />
</Request>When you generate the schema for the stored proc it will only contain a single attribute for the loaddata. You will need to create a schema describing the loaddata manually so that it matches your XQuery commands inside the stored proc.
You can create a message for the load data using a map from your source message. I would imagine you have done this already.
Then in a message assignment shape inside an orchestration you can construct the stored procedure message. You will need to make the loaddata attribute a distinguished field.
xmlDocumentVariable.LoadXml(“<Request xmlns=’yournamespace’><bts_Load_XmlData loaddata=” /></Request>”);
storedProcMessage = xmlDocumentVariable;xmlDocumentVariable = LoadDataMessage;
storedProcMessage.bts_Load_XmlData.loaddata = xmlDocumentVariable.OuterXml;Now send this to your SQL Send port.
You can create you store proc message in a single map, but you will need to use custom Xslt and a small external C# assembly.
Thanks Greg!! This seems like the best approach I have tried and researched thus far. I get the stored procedure part about passing the records as XML and then shredding for the inserts. I should be able to use Scope_Identity or @@Identity to solve my foreign key issues which is great.
I’m a little confused on how to assign the stored procedure parameter from BizTalk. Right now, I have a map that represents the canonical schema I want to insert. What field is Leonid making distinguished and I’m assuming that is the field that is passed as the stored procedure parameter?
Thanks again….
September 12, 2009 at 11:51 AM in reply to: Separating the BizTalk Server and SQL Server into two machines #23232did you enable Remote connection from Surface area configuration on SQL Server?
September 11, 2009 at 5:13 PM in reply to: Separating the BizTalk Server and SQL Server into two machines #23231The Biztalk Administrators Group and all the other Biztalk accounts and groups, need to be in the domain when using a two server install.
One method is to construct an Xml message with all records and pass this to a stored procedure as an Xml parameter. Inside the stored procedure, shred the Xml and apply your inserts. SQL does all the heavy lifting so it is fast. All inserts/updates occur in a single transaction.
Here is an old example from Leonid Ganeline that uses OPENXML to shred the Xml in the stored proc.
http://geekswithblogs.net/LeonidGaneline/archive/2008/04/03/biztalk-sql-port-how-to-pass-several-rows-to-the.aspxWith SQL 2005 using XQuery is much faster to shred your Xml
http://articles.techrepublic.com.com/5100-10878_11-6140404.htmlYou have to pass your Xml as a string in an attribute of your stored procedure request message. Leonid’s example uses a distinguished field assignment to do this but you can also do it in a custom Xslt, with an external C# routine.
September 11, 2009 at 11:53 AM in reply to: Separating the BizTalk Server and SQL Server into two machines #23228Yes I have a domain user account. Yes, I have sysadmin rights on the SQL Server.
I attempted to configure the BizTalk Server giving the SQL Server name of the other machine. Only the Enterprise SSO, MSMQT and BRE features succeeds. All the other features fails. Tried to reconfiger the Group feature (which trys to create Managment, Messagebox and Data DB’s in the other Machine) fails.
In the log i get a set of errors loged. It is as below.
[12:01:14 PM Error Configuration Framework]Feature: [Group] Failed to configure with error message [Failed to create SQL login for BizTalk Administrators Group on database server “CT-SDESILVA”.
Windows NT user or group ‘CT-SDESILVA\BizTalk Server Administrators’ not found. Check the name again.]
[12:01:14 PM Error Configuration Framework]Feature: [BizTalk Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [HWS Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [HWS WebService] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (HWS Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BAM Tools] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BAM Portal] Failed to configure with error message [Feature is skipped due to dependent feature (Group) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [BizTalk EDI/AS2 Runtime] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]
[12:01:14 PM Error Configuration Framework]Feature: [] Failed to configure with error message [Feature is skipped due to dependent feature (BizTalk Runtime) failed to configure correctly.]The BizTalk box has the “BizTalk Server Administrators” Group. The SQL Box doesn’t have the “BizTalk Server Administrators” Group. BizTalk is not installed in the SQL box. I tried manually creating a “BizTalk Server Administrators” group in the SQL Box, yet no use.
Everything is on same server… If i don’t give a call to .NET code everything is working fine…
You can have your orchestration subscribe to the binary file – declare a message of type System.Xml.XmlDocument. add a receive shape for this message amd bind the orchestration port to your receive port. This way both the orchestration and your original send port will receive the message.
Once the orchestration has received the message, you can access the file name in the FILE.ReceivedFilename property of this message.
are you connecting to Local server or remote SQL server ?
if it’s a remote , domain User must be a user of SQL database
Hello,
I am having the same problem right now, and I can’t find any help in the forums. Did you manage to find a solution?
Actually everything works fine for a few hours, then Biztalk says it can’t connect to it’s mgmt database. It’s a bit weird because I have no problem at all connecting myself to this database, using SQL Server Management Studio!
Any help would , errrr… help 🙂
Thanks!
Simon
Sorry for bringing up this old topic, but while searching the web this page was the only one that describes almost the exact problem I’m having. I’m hoping Per found a solution and still reads this forum, or maybe someone else can help me.
A small difference between Per’s environment and ours is that we have BizTalk 2006 R2 Enterprise Edition (v3.6.1404.0). Our system is a physical Dell system, running Windows Server 2003 Standard Edition SP 1 (v5.2) with an Intel Xeon 2.8 GHz cpu and 2 GB RAM.
Just like described above, our system is running fine most of the time. A dozen of different document types are being processed very fast and if anything wrong happens, we get a nice alert (if we programmed it to do so).
We have experienced that BizTalk may stop working properly without warning. We process a lot of files every day and most of them require quick processing. Some people try again if they don’t receive an answer within a minute, so another file is submitted to BizTalk. Meanwhile BizTalk isn’t doing anything with those files, so they just keep adding up to its queue until it decides to continue working. Often some files are processed incorrectly because other services can’t handle all the requests they receive from BizTalk. If someone notices something’s wrong, we can manually correct everything, but the later that happens, the more there is to fix.
The above happened yesterday for – I think – the third time this year. And the fourth time this morning. And the fifth time this afternoon. We decided to do a full reboot and everything seems okay for now. You can understand that I’m a bit concerned however, maybe even scared.
Unlike Per however, we don’t get any errors in our event log that I can relate to these problems. Also, I don’t believe the mentioned error has anything to do with what we describe.
The worst thing about this is that I don’t know what’s causing this. Like I said the problem on this page is the only one I found on the web that is [pretty much] the same as ours.
Hopefully anyone can help me out here. Thanks in advance.
-
AuthorPosts