Forum Replies Created
-
Posts
-
I am using dynamic Port to send a mail to the Email addresses which are coming from database.
SQL adapter Response schema is as follows:
<LoopMessage_IdeaSend_Resp>
<ot>
<ut>
<RMail>zasds</RMail>
</ut>
<orderID>hfh </orderID>
<status>fgfdg</status>
</ot>
</LoopMessage_IdeaSend_Resp>I have created another schema consists of only one node as
<Schema>
<ut><Email>cxv</Email></ut>
</Schema>Also i have promoted this Email node. And sending mail to Email address coming from this schema. Before that, a Email address is assigned to message by using following code in Expression box..
Xpathst = system.string.Format(\”/*[local-name()=’LoopMessage_IdeaSend_Resp’]/*[local-name()=’ot’]/*[local-name()= ‘ut’]{[0]}\”,i)
MailMsg= xpath(Insert_idea_Resp.parameters, Xpathst);
i = i+1;
MailMsg is a message created from second schema.
Now sending mail to address as
\”mailto:\” + MailMsg.Email
I have also used a custom pipeline with the MIME/SMIME encoder component at Send port.
So the maintenance jobs for shrinking the database/logfile are really running, but the logfile still grows?
Did you try shrinking the logfile manually through the \”Enterprise Manager\” mmc?Good morning.
Thanks Greg, seems like there is no other way around.But I was wondering if there wasn’t another solution to this problem. In fact the OAGIS schemas are an industry standard afaik…
And yes, these datetime fields were really nasty!
It runs automatically, but the .ldf file grows and grows.
The DataBizTalkMsgBoxDb.mdf file is only19 Mb.
Why can then the log file so big? Can I delete the logs by hand? Or are there a Stored Proc in the SQL that makes it?
Today, the disk has 0 byte free space. There must be a way, to clean the log file. I don’t like to reinstall the server.There are another server I use, there the log.ldf is only 1.75 Mb. In the setting I didn’t find any difference.
my sql server is local .
i had searched yhe rror and i didn’t find th esolution taht fits with my problem.
when i push the botton retry after the error message it displays me this message.
\”the service can not run because it is desactivated or ther is no device associated to it\”Installing BizTalk 2004 just sucks.
Is SQL local or remote? Make sure that logon is Admin on SQL as well. Otherwise, try Goggling your exact error message with the OS. You should get many results.
That’s kind of a hard question to answer.
At one level, every BizTalk Adapter (File, MQ, MSMQ, SOAP, Custom, ect) can have reliable messaging built in by using Delivery Notification inside an Orchestration.
It really depends on what you want to accomplish. If you need to get a message back from a destination in real-time then Web Services is a common approach assuming it’s supportable by the destination. Otherwise, IBM MQ or MSMQ is common for long running process. In both cases, an Orchestration can be used to help correlate the response messages.
So, it really depends on your exact requirements and what level you want reliable messaging.
Hope this helps.
I see two ways to accomplish what you want.
1. Use an expressions shape and .net code to create and write you text file without using a BizTalk Message
2. Create an Xml Document and assign that to a node.
Like this:
<Something>
<Data>your data</Data>
</Something>Define this as a flat file schema. Then, set your properties to format the data as you want (i.e. could create multiple lines, etc if needed). Lastly, use the Flat File Assembler to create your text file.
Best of luck.
Hi everyone.
We would like to use Biztalk 04 to realize communication with one of our customers. The customer uses schemas provided by the Open Applications Group. However, the OAGIS schemas (7.2.1.) don’t work correctly in our Biztalk Server (003_process_po, 057_change_po, 161_show_shipment). We tried the supplied .xsd-files. Converted and tried the supplied .dtd- and the sample .xml-files.
Manually editing the generated files resolved some major errors. So validating the schemas works correctly, but the generation of sample .xml-files and validating these against the Schema-files creates serveral errors as validating the supplied .xml-files do.The point is that we can’t use the Schemas in the BT-Server and/or can’t validate or check any xml-files
against these schemas.Does anyone know these kind of errors and/or has a solution or workaround?
Any help would be much appreciated.Thanks in advance.
PeterDo you have SQLAgent running.
There are a number of SQL jobs continuously cleaning and archiving the Biztalk databases. You need to have SQLAgent set for automatic start.
There is no way of creating a blank Xml document that would suit all implementations. So when constructing an Xml message you have to build it yourself.
When you create a new XmlDocument it is empty, it has no nodes .
There are a number of ways of constructing a blank XmlDocument.
1. Use an XmlDocument variable
[code:1:6548ce32bb]XmlDocVariable.LoadXml(\"<root><record><field/></record></root>\");
YouMessage = XmlDocVariable;[/code:1:6548ce32bb]2. Use a .NET serializable class
[code:1:6548ce32bb]using System;
using Microsoft.XLANGs.BaseTypes;namespace NetClass
{
[Serializable]
public class MsgClass
{
public MsgClass()
{
StrField = \"OK\";
IntField = 1;
}[DistinguishedFieldAttribute()]
public String StrField;[DistinguishedFieldAttribute()]
public int IntField;
}
}
[/code:1:6548ce32bb]
The in a message assignment shape
[code:1:6548ce32bb]message = new NetClass.MsgClass[/code:1:6548ce32bb]3. Use a .NET helper class
[code:1:6548ce32bb]
namespace CreateMsgHelperpublic class Helper
{
private static XmlDocument _template = null;
private static object _sync = new object();
private static String LOCATION = @\":\\MyTemplateLocation\\MyMsgTemplate.xml\";public static XmlDocument GetXmlDocumentTemplate()
{
XmlDocument doc = _template;
if (doc == null)
{
// Load the doc template from disk.
doc = new XmlDocument();
XmlTextReader reader = new XmlTextReader(LOCATION);
doc.Load(reader);// Synchronize assignment to _template.
lock (_sync)
{
XmlDocument doc2 = _template;
if (doc2 == null)
{
_template = doc;
}
else
{
// Another thread beat us to it.
doc = doc2;
}
}
}// Need to explicitly create a clone so that we are not
// referencing the same object statically held by this class.
doc = (XmlDocument) doc.CloneNode(true);
return doc;
}
}[/code:1:6548ce32bb]
The in a message assignment shape
[code:1:6548ce32bb]MsgOut = CreateMsgHelper.Helper.GetXmlDocumentTemplate();[/code:1:6548ce32bb]
3.Use a map with a Transform shape.I know it, and I use the Event viewer, but this special case, there are no error messages about permissions.
In fact, the Biztalk orchestration works, if the were no errors. It makes the xml, and stores in the file, but without the data from the data table.Well, now it works, so I simply must watch the permissions in the future.
The first error is due to the fact that the XmlDisassembler cannot find the schema for message type http://Loop_Message#ut.
I am assuming you retrieve a message from SQL and break it apart in an orchestration so you have not declared a schema for the message fragments. This is not a problem as long as you use the Passthru pipeline.
The second problem is due to no email address specified in the adress Url for the port.
Are you using a dynamic port.
Where does the email address come from.
How are you assigning the email address.In order to send email using the SMTP adapter you will need to use a custom pipeline with the MIME/SMIME encoder component.
I have tried it with PassThruTransmit pipeline but still it gives me error as follows:
[b:c439e7277a]The adapter failed on an attempt to transmit a message going to send port with the address \”Mailto:\” Details: \”At least one receipient is required but none were found\”[/b:c439e7277a]
I think that it gives me empty message. But when I had taken the output of SQL response adapter in Folder without breaking message it gives me whole XML file.
So how can i resolve this problem?
Thanks in advance.
