Many thanks for reading thispost.
i'm chasing an issue and i desperatly need any idea or help to resolve
this
faceless problem.
My interface is pu****ng XML messages to INSERT/UPDATE in Oracle database,
btw Connectivity with DB is solid, this interface processes messages
everynight. nightly we get a load of anywwhere between 10,000 - 20,000
invoices which ultimately needs to go to ORACLE. & in first attemt about
50-60% of the messages do go thru leaving about 40-50% in suspended Queue
whcih we then resume manually and then they eventually all go thru.
I have checked with Oracle DBAs for any issue on their side and found
none.
i'm using TheEnablergroup's BizTalk Utilities Adapter for Databases
Trans****t.
Any idea what would be the problem & error i get is mentiond below....
has anyone been in same boat ever???
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5754
Date: 7/10/2008
Time: 2:10:26 AM
User: N/A
Computer: HSIHUF04
Description:
A message sent to adapter "BizTalk Utilities Adapter for Databases
Trans****t" on send ****t "xxxxInvoiceYYYYSend****t" with URI
"database://Microsoft .NET Data Provider for Oracle Version 2.0.0" is
suspended.
Error details: Object reference not set to an instance of an object.
MessageId: {2765F7CD-45D4-457F-B13C-6B4471588EA2}
InstanceID: {3866180F-F9DE-43A8-AD20-B39066251BFB}
