Error: BizTalk Utilities Adapter for Databases Receiver

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Error: BizTalk Utilities Adapter for Databases Receiver

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Error: BizTalk Utilities Adapter for Databases Receiver

Page: [1]

Message

<< Older Topic Newer Topic >>

Error: BizTalk Utilities Adapter for Databases Receiver - 4 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

We resently upgraded to the most current release of the Biztalk Utilities adapter to correct an Oracle Pipes problem. We have encountered problem with the Database Transport adapter that connectes to oracle through the Oracle Data Provider .Net. The Receive port executes a stored procedure that returns back a Ref Cursor with a row of data that we pass to another process for processing. The polling does execute the stored procedure correctly because we can see the after effects on the database as a result of the procedure being run. It just when data is returned the adapter failes.

The previous version of the adapter worked beautifully with the execption of generating an error when no rows returned. The upgrade does not generate the execption when no rows are returned, however is does generate the following when a row is returned. We have even gone so far as to delete the receive location and recreated from scratch incase it required some new parameters. We have a number of these built on different servers and they are error the same way. According to our support group that takes care of the installation and setting of the adapters, everything has been installed properly.

Any suggestions would be greatly appreciated. I have included a snap shot of the installed assemblies showing the version numbers of the properties.

Event Information message before Error:
----------------------------------------------
Event Type: Information
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  1/5/2007
Time:  10:01:19 AM
User:  N/A
Computer: S116V504
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.BizTalk.TraceMessageBoxEvent
{
String Message = ""
String BodyPartName = "body"
EventSystemMessageContext Context = {
     String BackUpEndPointInfo = <null>
     Boolean BatchRequired = False
     String CorrelationToken = <null>
     String DecryptionCert = <null>
     String DestinationParty = <null>
     String DestinationPartyID = <null>
     String DestinationPartyQualifier = <null>
     String EncryptionCert = <null>
     String EndpointGroup = <null>
     DateTime ExpirationTime = 1/1/0001 12:00:00 AM
     String FaultQueue = <null>
     String InboundTransportLocation = "database://Oracle Data Provider for .NET/LocateUndatedOrderCreateT2s/LocateUndatedOrderCreateT2"
     String InboundTransportType = "BizTalk Utilities Adapter for Databases Transport"
     String InterchangeID = <null>
     Boolean IsFragmented = False
     Boolean IsSolicitResponse = False
     String MessageID = ""
     String MessageType = <null>
     String Namespace = "http://schemas.microsoft.com/BizTalk/2003/system-properties"
     String OutboundTransportLocation = <null>
     String OutboundTransportType = <null>
     Boolean PassThrough = False
     Int32 PipelineExecuted = 0
     String ProcessingParts = <null>
     String ReceivePipelineID = ""
     String ReceivePortID = ""
     Int32 RetryCount = 0
     Int32 RetryInterval = 0
     String SignatureCertificate = <null>
     String SigningCert = <null>
     String SourceParty = <null>
     String SourcePartyEvidence = <null>
     String SourcePartyEvidenceQualifier = <null>
     String SourcePartyID = ""
     String SourcePartyQualifier = <null>
     String SOAPAction = <null>
     String SSOTicket = <null>
     String TransmitPipelineID = ""
     String WindowsUser = <null>
     EventMessageContextProperty[] Context = {
        EventMessageContextProperty Context[0] = {
           String Namespace = "http://schemas.microsoft.com/BizTalk/2003/system-properties"
           String Property = "InboundTransportLocation"
           String Value = "database://Oracle Data Provider for .NET/LocateUndatedOrderCreateT2s/LocateUndatedOrderCreateT2"
        }
        EventMessageContextProperty Context[1] = {
           String Namespace = "http://schemas.microsoft.com/BizTalk/2003/system-properties"
           String Property = "InboundTransportType"
           String Value = "BizTalk Utilities Adapter for Databases Transport"
        }
        EventMessageContextProperty Context[2] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Provider"
           String Value = "Oracle Data Provider for .NET"
        }
        EventMessageContextProperty Context[3] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Connectionstring"
           String Value = "Data Source=wkmgmtdv;Connection Timeout=15;Enlist=True;Persist Security Info=True;User Id=biztalk;Password=Integr8te;Pooling=True;Connection Lifetime=0;Decr Pool Size=1;Incr Pool Size=5;Max Pool Size=100;Min Pool Size=1;"
        }
        EventMessageContextProperty Context[4] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Transactional"
           String Value = "Native"
        }
        EventMessageContextProperty Context[5] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Lock"
           String Value = "False"
        }
        EventMessageContextProperty Context[6] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "IsolationLevel"
           String Value = "Serializable"
        }
        EventMessageContextProperty Context[7] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "TargetNamespace"
           String Value = "http://UnionGas.Wkmgmt.LocateOrderSend.BizTalk"
        }
        EventMessageContextProperty Context[8] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Root"
           String Value = "LocateUndatedOrderCreateT2s"
        }
        EventMessageContextProperty Context[9] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Record"
           String Value = "LocateUndatedOrderCreateT2"
        }
        EventMessageContextProperty Context[10] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "Sql"
           String Value = "onecall.pkglocate_order_detail.pkglocateundatedordercreatet2"
        }
        EventMessageContextProperty Context[11] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "CommandType"
           String Value = "StoredProcedure"
        }
        EventMessageContextProperty Context[12] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "ConnectionTimeout"
           String Value = "15"
        }
        EventMessageContextProperty Context[13] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "CommandTimeout"
           String Value = "30"
        }
        EventMessageContextProperty Context[14] = {
           String Namespace = "http://theenablergroup.com/btsutils/databases/properties/receive"
           String Property = "MessageSize"
           String Value = "1"
        }
     }
}
String MessageID = "5726ac1e-e041-40c8-a639-02e520db5344"
Int32 PartCount = 1
Int32 ProcessID = 816
String ProcessName = "d:\Program Files\Microsoft BizTalk Server 2004\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = <null>
WindowsSecurityInfo WindowsSecurity = <null>
ManagedSecurityInfo ManagedSecurity = <null>
String StackTrace = ""
String EventSourceInstance = "a145637c-5da0-4321-bc49-9d9aea930a59"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 61
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 1/5/2007 10:01:19 AM
String AppDomainName = "DefaultDomain"
String MachineName = "S116V504"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 4
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

First Error message:
---------------------------

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  1/4/2007
Time:  1:30:45 PM
User:  N/A
Computer: S116V504
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle/LocateUndatedOrderCreateT2s/LocateUndatedOrderCreateT2'
System.ArgumentException
The parameter is incorrect."
Exception InnerException = {
   String HelpLink = ""
   String Message = ""
   String Source = ""
   String StackTrace = ""
   String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 572
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\btutr_str"
   String ProcessAccountName = "DEGT\btutr_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.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
String EventSourceInstance = "087135a3-8d6c-46e6-b1bb-fae043232d70"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 24
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 1/4/2007 1:30:45 PM
String AppDomainName = "DefaultDomain"
String MachineName = "S116V504"
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.

Second Error message:
---------------------------

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  1/4/2007
Time:  1:30:45 PM
User:  N/A
Computer: S116V504
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to BizTalk Server.
A common cause for this type of Exception is the fact that the Property Schema Assemblies for the Adapter are not correctly deployed.
Please ensure that the Property Schema Assemblies for the Adapter are correctly deployed.
System.ArgumentException
The parameter is incorrect."
Exception InnerException = {
   String HelpLink = ""
   String Message = ""
   String Source = ""
   String StackTrace = ""
   String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 572
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\btutr_str"
   String ProcessAccountName = "DEGT\btutr_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.Core.Adapters.Receive.EndPoint.Batch.Submit()
at BTSUtils.Adapters.Databases.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
String EventSourceInstance = "087135a3-8d6c-46e6-b1bb-fae043232d70"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 23
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 1/4/2007 1:30:45 PM
String AppDomainName = "DefaultDomain"
String MachineName = "S116V504"
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.

Attachment (1)

< Message edited by phummel -- 5 January 2007 >

Post #: 1

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 6 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Can you confirm the exact version of the Adapter?

Also is this a multi server environment?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to phummel)

Post #: 2

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 8 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

We are at version 4.0.4. The adapters are running on multiple Win2003 virtual servers.

The configured receive ports are currently only ruinning on single Virutal Win2003 servers so we don't have them clustered at this time.

(in reply to phummel)

Post #: 3

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 8 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Can you double-check to see if the assemblies are actually present within the GAC as well.

BTS may report these, but they may not be in the GAC.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to phummel)

Post #: 4

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 9 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

I have attached a picture of the gac.

Attachment (1)

(in reply to Pieter)

Post #: 5

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 10 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

This is totally strange.

Can yuo please mail your bindings for the Receive Location to support@theenablergroup.com?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to phummel)

Post #: 6

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 10 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

The receive locations aren't attached to any orchestration/assembly so we can't export the binding file. We use the inbound maps function on the receive port to send the data to a map and then have send ports with filters listening for the output from the map. This was all working excellently prior to the 4.0.4 release.

What are you specifically looking for. We are checking to see if there is a way to create a binding file for just receive port.

(in reply to Pieter)

Post #: 7

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 10 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

We are specifically lloking at getting this replicated in our test environment.

e would need your table structures and SPs as well as the configuration for the Receive Location.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to phummel)

Post #: 8

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 12 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

another group in our department is running into the same problem, except he is using and orchestration. I have email support with the binding file and error text. If you need more let us know please.

(in reply to Pieter)

Post #: 9

RE: Error: BizTalk Utilities Adapter for Databases Rece... - 24 January 2007

phummel

Posts: 6
Score: 0
Joined: 4 January 2007
Status: offline

Problem resolved. After reinstalling version 4.0.5 on a different server and setting up our code on it everything worked out just fine without any other modification. Then went back to our development server, uninstalled version 3, installed version 4.05, and we go the missing property schemas error again. Taking a closer look it seemed that the install did not properly install the property schemas for the adapters. Uninstalled and then reinstalled again then the property schemas for the adapters showed up. Tested and we are back in business. I have attached pictures to show what the differences are for the good install and the incomplete install on the two different servers. The picture on the left is from the bad installed and the one on the right is the good install.