Each time I tried to test my new mapping using BizTalk I got this error: The system cannot find the file specified (Exception from HRESULT: 0x80070002).
So the full error in the event viewer looked like this:
A message received by adapter "FILE" on receive location "RECEIVE ORDERS PCE FILE" with URI "C:\B2B.TRADCOM.COM\ORDERS\INBOUND\PCE\*.xml" is suspended.
Error details: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
MessageId: {F83F1E4B-3B09-4F9B-A9D5-F6C1BD5C2698}
InstanceID: {E162E5AB-E621-4EA1-B643-FD843D7F8D44}
I was able to map the message using Visual Studio, so I was quite sure my BizTalk mapping was correct.
Now it turned out that I forgot to sign the assembly. So the system was unable to place the assembly in the GAC. Because I used a deploy script I didn't notice the resulting warning.
"People are complaining about query timeouts. I don't see anything happening in SQL Server, but they always say the database is the problem. How can I tell what's really going on?"
When your users keep hitting timeouts in their application, they naturally think the database is killing off helpless queries. In this webinar Kendra Little will tell you how to triage treacherous timeout situations and collect hard evidence about whether or not the problem is in the database. Do the right detective work and you can turn your frustrated users and irate developers into raving fans.
This session is be 200-level - you should have familiarity with OLTP concepts and understand what DMVs and Profiler are, but you don't have to be an expert with them.
Pinalkumar Dave has published a neat series of FAQ on SQL Server.
The series of blogs provides a simple way to go back over the building blocks of SQL Server. It's way to remind yourself of what you already know.
A Question and Answer discussion can also be a way to go over old topics in a more interesting manner. Especially if you have been working in the industry, or taking lots of classes on the topic, everything you read can sound like a repeat of what you already know. Going over a topic in a new format can make the material seem fresh and interesting. And an interested mind will be more engaged and remember more in the end.
The list of interview Questions and Answers is helpfull as a refresher for SQL developers/administrators or as a way to learn about SQL (as a beginner or to learn new things).
The cumulative update package 3 for BizTalk Server 2009 is available.
included hotfixes:
BizTalk Server EDI support
The EDI batching orchestration does not release batches on time in BizTalk Server 2006 R2 and in BizTalk Server 2009
AS2 messages remain active after they are processed when the "Track Message Bodies - Request message after port processing" option is enabled on a send port in a BizTalk Server 2009 environment
BizTalk Server Administration Tools & Configuration Tools
"The group BizTalk Isolated Host Users doesn't exist" error message is logged when you configure the Exception Web Services by using the ESB Configuration Tool in a BizTalk Server 2009 environment
All the tracking options under "Track Events" are selected unexpectedly after a BizTalk orchestration is created or updated in BizTalk Server 2009
Applications stop responding or crash when System Center Operations Manager monitors BizTalk Server 2009 applications
BizTalk Server Message Box and Message Agent, Pipelines & Tracking
Performance decreases when a server that is running BizTalk Server 2009 processes a large batch of messages after you customize the settings of the "Large Message Threshold" option and of the "Large Message Fragment size" option
Error message when you receive a MIME or SMIME document in BizTalk Server: "Item has already been added"
BizTalk Server XLANG engine
White space is removed if a message is processed by a mapping operation that is included in a Construct Message shape in BizTalk Server
BizTalk Server Setup
Cumulative update package 2 for BizTalk Server 2009 fails if a BizTalk group uses a database that uses a case-sensitive collation
Prerequisites
To apply this update, you must have BizTalk Server 2009 installed. For detailed information about how to install this update, see the Readme.txt file that is included in the update package.
Notes
You have to stop the following services before you apply this update:
ENTSSO
IISADMIN
WINMGMT
BTSNTSVC
To install this update in a BizTalk group that includes multiple BizTalk servers, install this server update on each server individually instead of concurrently.
