Production INSERT/UPDATE PROBLEM using Utilities Adapter

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

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

Production INSERT/UPDATE PROBLEM using Utilities Adapter

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 >> Production INSERT/UPDATE PROBLEM using Utilities Adapter

Page: [1]

Message

<< Older Topic Newer Topic >>

Production INSERT/UPDATE PROBLEM using Utilities Adapter - 10 July 2008

bizGuru

Posts: 1
Score: 0
Joined: 10 July 2008
Status: offline

Many thanks for reading this post.
i'm chasing an issue and i desperatly need any idea or help to resolve this
problem.

My interface is pushing XML messages to INSERT/UPDATE in Oracle database,
btw Connectivity with DB is solid, nightly we get a load of anywwhere between 10,000 - 20,000
invoices which ultimately needs to go to ORACLE. & in first attempt 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 Transport.

Any idea what would be the problem & error i get is mentiond below....
has anyone been in same boat ever??? we resume the remaining messages then it again pushes about 50-60% leaving others & we keep resuming until all the messages are pushed in to Oracle.

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
Transport" on send port "xxxxInvoiceYYYYSendPort" 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.