 Forum main
page
Most
active member
Login page
Register
Log out
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
|
|
Users viewing this topic: none
|
|
Login  | |
|
Oracle Alert Dropped - Please Help! - 2 February 2007
|
|
|
tomtom
Posts: 13
Score: 0
Joined: 2 February 2007
Status: offline
|
Hi all:
Ref: BizTalk Server 2006 with BizTalk Utilities Adapter for Databases Version 4.0.0/BizTalk Utilities Version 2.1.2
We are having issues with the BizTalk Utilities Adapter for Databases Oracle Alerts Transport dropping or not receiving all Oracle alerts during testing. The test scenario is simple: we insert records into an Oracle table configured with a trigger to fire the Oracle alerts via dbms_alert.signal(), just like the tutorial document.
- Test #1: insert 1 record every 5 seconds continuously - Passed. All Oracle alerts were received and processed.
- Test #2: insert 1 record every 4 seconds continuously - Failed. A total of 116 records were inserted, but only 91 alerts were received.
The tests went down hill from there for any interval less than 4 seconds. One interesting thing was that if we sent a batch of inserts say 2, 3, 4, or 5 records at a time, only one alert was received and it was almost always the last record of the batch. We knew the trigger fired the alerts properly since we recorded to the audit table after the alert was fired.
Does anyone have the same issue? As you can see, capturing 1 alert in 5 seconds is definitely not an acceptable standard. Is there anything we have to twist to prevent the adapter from dropping the alerts? Please help.
Thanks,
Tom
< Message edited by tomtom -- 2 February 2007 >
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML