 Forum main
page
Most
active member
Login page
Register
Log out
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
|
|
Users viewing this topic: none
|
|
Login  | |
|
Oracle Alerts Question - 16 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Hi all,
I've created an Oracle Alerts project based on the HR.JOBS sample shown on this website. My project will be very similar, I need a trigger when a row is inserted in an Oracle table, and I need BizTalk to receive the id of that new row and then query the row from the database. At this point it will need to generate an email but that's the easy part.
I have the project deployed and my trigger out in my Oracle table, but am not seeing any activity when a row is inserted on the table (i.e. no "BizTalk Utilities Adapter for Databases Oracle Alerts Receiver" information events in the event log). I have tested the dbms_alert.signal package in the database using the trigger info I configured and it executes without incident. I can't tell whether BizTalk is just not receiving the info or if it is just ignoring it.
Does any one have an idea where I can start troubleshooting?
Thanks in advance
|
|
|
|
|
RE: Oracle Alerts Question - 16 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Would it be possible to tell us which version of the Adapter you are currently using?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 16 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Hi Pieter thanks for your quick reply.
The version we are using is 3.1.3. We've had to roll back from 4.0.4 because of issues 4.0.4 was causing in our environment.
|
|
|
|
|
RE: Oracle Alerts Question - 16 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
What are the issues with 4.0.4?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 17 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
One of the people here on our team is working with you on the issue with the database adapter polling, calling a stored procedure. It returns an error that the assemblies need to be deployed, but they are both deployed and gac'd.
|
|
|
|
|
RE: Oracle Alerts Question - 18 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Can you please explain more?
Are the property schemas correctly deployed for the Adapter?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 18 January 2007
|
|
|
kmfinley
Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline
|
Hi Pieter,
You are working with Pieter Hummel on an issue with the 4.0.4 adapter. The post is titled Error: BizTalk Utilities Adapter for Databases Receiver - 4 January 2007
It is the receive adapter that is set up to poll or call a stored procedure at a specified interval. He has sent the port info and table layouts and stored proc to you to set up to verify the problem.
Is the issue Brian Rupert is seeing been fixed in a new release or have you seen this issue before?
thanks
Karen
|
|
|
|
|
RE: Oracle Alerts Question - 18 January 2007
|
|
|
kmfinley
Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline
|
Hi Pieter,
I just deployed to the database the BTSUtils.Adapters.Databases.Properties schema and the BTSUtils.Adapters.Databases.Oracle.Pipes.Properties property schema. The BTSUtils.Adapters.Databases.Oracle.Alerts.Properties schema was deployed previously to the database. Are there any additional property schemas that need to be deployed??
thanks
Karen
|
|
|
|
|
RE: Oracle Alerts Question - 18 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
No they are the only ones that are required.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 18 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
We tested the issue on our side with 4.0.4 on our side with your exact configuration. It worked without any issues.
The only issue we could see with the config was that a very old ODP.NET Provider was used.
We need to know what version of ODP.NET you have installed on the BTS machine.
I have sent mail requesting this.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 19 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Hi Pieter, the rest of the poperty schemas have been deployed and I have tested it again but still am seeing no messages at all in the event log.
|
|
|
|
|
RE: Oracle Alerts Question - 22 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Would it be possible to send your solution tosupport@theenablergroup.com?
We want to place it into our Test Environment to make sure things are working on the Adapter side.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 22 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Hi, I've sent the files as requested including the oracle table ddl. Please let me know if you don't receive them, our firewall might not let it through.
Thanks.
|
|
|
|
|
RE: Oracle Alerts Question - 23 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Hi Pieter, I was playing around some more with this project and am now getting this error in the event log:
Event Type: Error
Event Source: BAM EventBus Service
Event Category: None
Event ID: 16
Date: 1/23/2007
Time: 2:32:35 PM
User: N/A
Computer: S1181393
Description:
Unhandled exception caught, exception details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.ConnectionPool.CreateConnection()
at System.Data.SqlClient.ConnectionPool.PoolCreateRequest(Object state).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
< Message edited by brupert -- 23 January 2007 >
|
|
|
|
|
RE: Oracle Alerts Question - 24 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
This sounds like the Sql Server is not available.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Oracle Alerts Question - 30 January 2007
|
|
|
brupert
Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline
|
Pieter, thanks for your reply. We have since had the updated adapters deployed and I am now receiving the Oracle Alerts. I am having a problem with my schema though, I am getting the message: There was a failure executing the receive pipeline: "UnionGas.CARE.WBTMessage.BizTalk.CAREOracleAlertsMessageID" Source: "Flat file disassembler" Receive Location: "oraclealert://Microsoft .NET Data Provider for Oracle/CARE.CARE_EMAIL_ALERT.INSERT" Reason: Unexpected data found while looking for:
'|'
The current definition being parsed is CAEOracleAlert. The stream offset where the error occured is 0. The line number where the error occured is 1. The column where the error occured is 0. I've modelled my flat file schema after the sample for JobsMessage.xsd. I'm not really sure what the incoming file looks like from Oracle. Would you be able to assist?
PS - the JobsMessage.xsd has the same problem when you try to validate an instance of it.
Thanks in advance,
Brian
< Message edited by brupert -- 30 January 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