I'm getting this error message:
Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Transmitter
Event Category: None
Event ID: 0
Date: 2/8/2006
Time: 9:59:20 AM
User: N/A
Computer: S116V501
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Batch of Messages to the Database Transport.
System.ArgumentNullException
Value cannot be null.
Parameter name: type"
Exception InnerException = {
String HelpLink = ""
String Message = ""
String Source = ""
String StackTrace = ""
String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 8144
String ProcessName = "d:\Program Files\Microsoft BizTalk Server 2004\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
String ActivityID = ""
String ApplicationID = ""
String TransactionID = ""
String DirectCaller = ""
String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
String CurrentAccountName = "DEGT\btuts_str"
String ProcessAccountName = "DEGT\btuts_str"
}
ManagedSecurityInfo ManagedSecurity = {
String IdentityName = ""
String AuthenticationType = ""
Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Transmit.Batch.SendMessages(IBaseMessage[] messages)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "b74fce07-1a80-4c9d-a4af-7e2750d33cb8"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 130
String EventSchemaVersion = "2.0.170.0"
DateTime TimeStamp = 2/8/2006 9:59:20 AM
String AppDomainName = "DefaultDomain"
String MachineName = "S116V501"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I don't know why I'm getting this error message as the schema and mapping seems right. I have added a send shape to see what the parameters I'm giving my Stored Proc as shown below and it does not have any Null parameters.
<ns0:UserIDsRecsRequest xmlns:ns0="http://MyCompany.MyGroup.Messaging.BizTalk">
<ns0:Operation1>
<ns0:BIZTALK_MESSAGING.Return_UserIDs>
<ns0:Parameters>
<ns0:PMSGTYPEID>13</ns0:PMSGTYPEID>
<ns0:PCONTRAXCOID>4111</ns0:PCONTRAXCOID>
<ns0:PSUBTYPE>SA</ns0:PSUBTYPE>
<ns0:PUSERSUPID>787</ns0:PUSERSUPID>
<ns0:PMESSAGEID>411562</ns0:PMESSAGEID>
<ns0:PRECVDATE>2006-09-06T00:00:00.0000000-04:00</ns0:PRECVDATE>
</ns0:Parameters>
</ns0:BIZTALK_MESSAGING.Return_UserIDs>
</ns0:Operation1>
</ns0:UserIDsRecsRequest>
The mapping looks good (see attached jpeg) and no compile or deploy exception occurs.
Any help would be appreciated. Thanks, Bill N
[image]local://upfiles/1510/994ED82180484B8CB67282339B44B78C.jpg[/image]