oracle stored procedure problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › oracle stored procedure problem

Viewing 0 reply threads
  • Author
    Posts
    • #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 

       

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.