Forum Replies Created
-
AuthorPosts
-
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.
you can access your variable by using select ststement
SELECT @ISOK AS ISOK FOR XML RAWMarch 13, 2006 at 4:59 AM in reply to: Problem: The Messaging Engine failed to add a receive URL #13119I am not sure why you would get a Invalid cast exception. What type of message are you submitting to Biztalk?
There is no effective difference between the way you are implementing Web Services and the way Biztalk publishes an orchestration or schema as a Web Service.
You have had to write an ASP.Net Web Service that calls an unsupported adapter – SubmitDirect. You have to specify the Web Service message in two places one as a Biztalk schema and the a .Net object in your ASP.NET application.
With Biztalk, a wizard creates the ASP.NET Web Service and it uses the supported SOAP adapter. The interchange message is declared once within Biztalk and you also get access to SOAP properties within Biztalk. You can even customise the web service code if you are careful.
Publishing the web service using Biztalk does not make the Orchestration transparent to users, they will see the the same interface as your custom web service.
All the web service interfaces I have created in Biztalk have used the wizard to publish an orchestration or schema.
March 13, 2006 at 3:14 AM in reply to: Problem: The Messaging Engine failed to add a receive URL #13116Hi Greg,
I tried the installer that I made and I still got the same error.
\”There was a failure executing the receive pipeline: \”Microsoft.BizTalk.DefaultPipelines.XMLReceive\” Source: \”Microsoft.BizTalk.Messaging\” Receive Location: \”Submit://ProcessRequest\” Reason: Specified cast is not valid.\”
When you suggested to me to stop and restart the BiztalkServerApplication, at first it worked but when I re-installed the application again. It now has the error. Somehow I can’t understand what is the cause of the problem.
I just tried the installer in an XP Machine and it works just fine.
Why is it not working well on Windows Server 2003??
Thanks in advance,
Fred -
AuthorPosts