Forum Replies Created
-
Posts
-
This is a strange one,
On my work, we have a domain something.be. If i plugin my laptop to the network and I sent an e-mail with the smtp adapter, it works fine.
On my laptop, I installed a local mailserver so that I can test the BizTalk application without using the compagnies e-mailserver.
In my DNS on my win2000 laptop, I’ve created the same structure
.
.be
something.beWhen I sent an e-mail using the smtp adapter, I receive following error:
The message could not be sent to the SMTP server. The server response was not available.
The strange thing is, I can sent an email with outlook express and it works fine.
Any ideas?
[quote:af01d6f7a8=\”DavidL \”]If i have an apps running with oracle and other running in SQL server, is it good to invest into biztalk if i would like to export data from orable to SQL server?[/quote:af01d6f7a8]
Again, it depends. If you are basically doing mass data extraction, you’re better of using SQL Server Integration Services (SSIS), which is far more suited to the task. If you are looking for a more on-line experience, then biztalk might be a good fit.
If i have an apps running with oracle and other running in SQL server, is it good to invest into biztalk if i would like to export data from orable to SQL server?
There are a number of ways to do this.
One is to use a custom Xslt with a <xsl:key>
If you can post your schema, I can show you how this would work.Not real sure on this one. Are you trying to use Certificates on a pipeline? That’s what is sounds like.
Here are some quick answers for you.
1. Make sure your rules are deployed and the rules engine update service is running. I’m guessing this is already done or you’d get some errors.
2. You just need to pass in what the rules are expecting. That means if you are using an Xml Fact you need to pass that in. Using the Call Rules shape inside the Orchestration should help with this.
3. No, should need this.
4. Are you sure both rules actually ran? You should see the rule being evaluated.
Hope this helps.
Yes, it’s a separate download.
I think they are called Microsoft Adapters for Enterprise Applications or something like that. If you have MSDN, you should be able to find them under subscriber downloads.
Thanks for the reply. It is a xml file, RN standard.
When i open the file in the biztalkHATDumpSite\\raw folder, I am able to see all the data..
However, when i open the file in the Process Tracking Interface, I will see a truncated service content.
What went wrong ? I am actually using a custom receive pipeline from Optional Fields Editor Pipeline.
Pls help.
I believe that dta_debug holds records related to supporting orchestration debugging. if you don’t need to debug your live system (using the HAT orchestration debugging facilities), you can disable this on a per-orchestration basis from HAT. I don’t remember the exact location right now (don;t have a machine with BTS04 I can test right now off hand), but it shouldn’t be hard to find.
David,
From your description, I would venture that BizTalk is probably not the product you’re looking for, but it’s hard to say for sure with so little detail.
BizTalk is, at its core, a tool to integrate business applications (or integrate with trading partners) so that you can build more automated business processes. Does not sound like that is your specific need.
You can find a good whitepaper describing the capabilities of BizTalk server here: [url]http://www.microsoft.com/biztalk/techinfo/whitepapers/understanding.mspx[/url]
I learned about this table when using a free tool called Orchestration Profiler (which does \”Code Coverage\” for orchestrations). That utility was giving us SQL Connection Timeout because scanning this table was happening in the default Timeout connection in .NET of 30 seconds.
This table contains the start/stop time of every shape of every orchestration (since time immemorial).
This SQL will show you the history of your dta_DebugTrace table (it might take a while to run):
[code:1:4ddb31865c]select datepart(year,dtTimeStamp),
datepart(month,dtTimeStamp),
count(*) as ‘rowcount’
from dta_DebugTrace
group by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp)
order by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp) [/code:1:4ddb31865c]The above will show you how many records you have per year/month.
Probably you don’t need anything prior to 15 days ago.Then to cleanup/delete
[code:1:4ddb31865c]select * from dta_DebugTrace where dtTimeStamp < ‘2006-01-01′[/code:1:4ddb31865c]
Verify first, then change the \”Select * from\” to \”Delete\”.The question is do you need any of this history, or want to archive it first?
There are some purge/cleanup jobs provide in Biztalk SDK/Samples that might also address this.
When you check that box, you then need to build a process to subscribe to the error messages. Check out my sample under BizTalk 2006 on Suspended Message Routing.
As long as you haven’t turned off tracking, you should be able to see most errors and suspended messages inside the BizTalk admin Tool. Just open the BizTalk Admin Tool and go to the main BizTalk Group Node. You should see all kinds of information on your messages.
Hope this helps.
What is the format of the file you are dropping in? Is it XML?
Is it well-formed? It sounds like the processing is validating for well-formed XML to either the file you are dropping is not well-formed, or the XML created by the pipeline is not well-formed.
