Home Page › Forums › BizTalk 2004 – BizTalk 2010 › oracle stored procedure problem
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
October 17, 2006 at 2:22 AM #16074
hi
I am using Oracle adpter with version 10.1.0.400. I am passing parameters to oracle stored procedure from Biztalk 2004.
parameters consists of Date fields. when i execute it i got following error.
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Database Transport.System.FormatException
String was not recognized as a valid DateTime."
Exception InnerException = {
String HelpLink = ""
String Message = ""
String Source = ""
String StackTrace = ""
String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 5128
String ProcessName = "D:\PROGRA~1\MICROS~2\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
String ActivityID = ""
String ApplicationID = ""
String TransactionID = ""
String DirectCaller = ""
String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
String CurrentAccountName = "CORP\jyotsnad"
String ProcessAccountName = "BUILTIN\Administrators"
}
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.Updategram.Client.Execute(Group group)
at BTSUtils.Adapters.Databases.Transmit.Batch.SendMessages(IBaseMessage[] messages)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "0e412a6d-2cc2-4a58-82cf-6ca8a8ac4c2e"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 32
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 10/17/2006 11:33:27 AM
String AppDomainName = "DefaultDomain"
String MachineName = "AE3"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}How to pass date to Oracle Adapter from Biztalk server and also in which format?
Plz help me.
Thanks in advanced.
Sam
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.