 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  | |
|
Problems with Oracle Pipes Adapter - 27 October 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello trying to receive a flat file from a dbms_pipe and just using the passthru pipeline to send it out to a directory. Seems to be making a connection to the pipe but no data is coming through. This is Biztalk 2004.
these are the messages showing up when i execute the code sending the message on the pipe.
BTSUtils.Core.EnterpriseInstrumentation.Schema.TraceMessageEvent
{
String Message = "Updating Receive Endpoint. Uri is 'oraclepipe://Oracle Data Provider for .NET/Receive/BNRTSLTPIPE'."
DETAIL OMITTED
BTSUtils.Core.EnterpriseInstrumentation.Schema.TraceMessageEvent
{
String Message = "Removing Receive Endpoint. Uri is 'oraclepipe://Oracle Data Provider for .NET/Receive/BNRTSLTPIPE'."
DETAIL OMITTED
BTSUtils.Core.EnterpriseInstrumentation.Schema.TraceMessageEvent
{
String Message = "Adding Receive Endpoint. Uri is 'oraclepipe://Oracle Data Provider for .NET/Receive/BNRTSLTPIPE'."
DETAIL OMITTED
BTSUtils.Adapters.Databases.EnterpriseInstrumentation.Schema.TraceEvents.CustomEvents.Databases.Oracle.Pipes.Receive.Receiver
{
String Message = "Receive Configuration"
DETAIL OMITTED
And this is the code I'm using in the database, it is part of a large package in the database.
DETAIL OMITTED
DBMS_OUTPUT.ENABLE(1000000);
DBMS_PIPE.PACK_MESSAGE(msg_type);
DBMS_PIPE.PACK_MESSAGE(msg_exp_date);
DBMS_PIPE.PACK_MESSAGE(reply_pipe);
DBMS_PIPE.PACK_MESSAGE(inquiry_data);
--
/*
|| now send the message down the pipe to RM communication process
*/
--
pipe_status := DBMS_PIPE.SEND_MESSAGE('BNRTSLTPIPE');
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 28 October 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
I would not recommend using a pipe to push this much data. Rather us the Pipe as a notification mechanism and then us your Orch to pull the data from for instance a table or a proc.
In anyhow, what is your polling interval set to for the Pipe?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 28 October 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Thank you for the reply. I'm not sure why they set the enable for 1000000 but the pipe is actually only sending 341 characters. If you still think that is too much we might be in trouble, the code is part of the interface with an oracle forms application. We don't use a table because for some reason when passing this data across the interface if you try to write to a table the original transaction that started it gets stopped. So that's why they have continued to use the pipes.
The interval on the adapter is set to the same as your sample for using the oracle pipes adapter. 5 min. Although when it does poll it gets an error in the event log. I'm at home right now so can't actually get at it but it was something like "cancel requires an open connection".
Thanks
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 October 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello I have the message that the pipe gives when it trys to poll.
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'oraclepipe://Oracle Data Provider for .NET/Receive/BNRTSLTPIPE'
System.InvalidOperationException
Connection must be open for this operation"
Exception InnerException = {
DETAIL OMITTED
Thanks for your help
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 October 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
This seems like a connection issue. Does the Test Connection Button work when configuring the connection?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 October 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Yes the Test Connection results in a successful connection.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 October 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Are any other specific Adapter messages being logged except this one?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 October 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Well when we send the message down the pipe we get those messages that I put in my first post. But those are all we seem to get from the adapter.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 2 November 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
So can I confirm you are receiving initial messages with the Adapter, but no subsequent ones?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 2 November 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello Pieter
Well I'm not completely sure what you mean. The messages I showed you in the first post, I get those everytime I send data down the pipe. Even if I do it a few times in a row I still get all 4 four messages each time I execute the send_message for the pipe. But those 4 messages are all that I get, I don't get any of the actual data that I packed into the pipe.
Does this answer your question?
Thanks for all of your help
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 10 November 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hi Pieter
Just wondering if you've had a chance to work on this problem?
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 21 November 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
We have just released a version patching the issue.
Can you please download the latest version from TopXML?
Please read the ReadMe carefully there are incompitibilities between 3x versions and 4x versions de to a new stratey in Transaction Handling.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 24 November 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello
we have installed version 4.0.2 of the Database Utilities Adapters, but we are still having the same problem.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 25 November 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
The latest version which inludes the fix is actually 4.0.3
We've double checked that is the version avilable fro download.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 30 November 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello
I'm still having problems with the Oracle Pipes Adapter. This is the message I got when the adapter polled and there where messages waiting for it to pick up.
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to retrieve Messages from the Uri 'oraclepipe://Oracle Data Provider for .NET/Receive/BNRTSLTPIPE'
System.Exception
An Error occurred attempting to read a Message from 'BNRTSLTPIPE'. Details are as follows:
System.Exception: An Error occurred attempting to unpack a Message. Details are as follows:
System.MissingMethodException: Member not found.
at BTSUtils.Adapters.Databases.Provider.Factory.Parameter(String name, OracleType parameterType, Int32 size)
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.unpackMessage() ---> System.MissingMethodException: Member not found.
at BTSUtils.Adapters.Databases.Provider.Factory.Parameter(String name, OracleType parameterType, Int32 size)
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.unpackMessage()
--- End of inner exception stack trace ---
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.unpackMessage()
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.Read(String pipe)"
Exception InnerException = {
String HelpLink = <null>
String Message = "An Error occurred attempting to unpack a Message. Details are as follows:
System.MissingMethodException: Member not found.
at BTSUtils.Adapters.Databases.Provider.Factory.Parameter(String name, OracleType parameterType, Int32 size)
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.unpackMessage()"
String Source = "BTSUtils.Adapters.Databases.Oracle.Pipes.Client"
String StackTrace = " at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.unpackMessage()
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.Read(String pipe)"
String TargetSite = "System.Reflection.RuntimeMethodInfo.unpackMessage"
I'm currently using Oracle Data Provider for .NET as the provider, I did notice however that when the new version of the adapter was installed that there was a new version of that provider (Oracle Data Provider for .NET Version 10.2.0.200), I did try to use this version but when doing the Test Connection, I got this error "The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception."
I had another question after this though, do both the Oracle Pipes and Alerts adapters work on polling? It just seems that those should both be alert type functions (pick up the data when it is sent).
Thank you
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 1 December 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Is this with BizTalk Server 2006 or 2004?
Also what happens when you use the ODP.NET Provider?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 1 December 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello
It is Biztalk Server 2004.
And the adapter I'm not quite sure what you mean. If ODP.NET is the one I mentioned above (Oracle Data Provider for .NET) there are 4 versions on the server, one with no version number, 10.1.0.301, 10.1.0.400, and 10.2.0.200. When I tried the one that i thought was the new version 10.2.0.200, it wouldn't even make a test connection, gave me the error in my previous post. So I was using the one with no version number. My coworker is using that one for the Databases Adapter, and it is working for her, she is using the same database that i am. That one makes a test connection successfully, but nothing happens when i actually send data down the pipe, but when it polls and i have just sent a message down the pipe, it gets the error in my previous post. When it polls and there are no messages waiting for it, it doesn't get an error. I haven't tried the other versions yet.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 2 December 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Sorry I meant to ask if you tried using the Microsoft one?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 4 December 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Thank you soo much!
The Microsoft .NET for Oracle provider worked, I am now getting my DBpipes messages.
Thank you!
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 4 December 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Oops! I spoke too soon, my problems aren't over with yet. I am now trying to transmit with the pipes adapter and it is throwing the following exception. Thinking it's something internal.
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Oracle Pipes Transport.
System.NullReferenceException
Object reference not set to an instance of an object."
Exception InnerException = {
The "BizTalk Utilities Adapter for Databases Oracle Pipes Transport" adapter is suspending an outbound message going to destination URL:"oraclepipe://Oracle Data Provider for .NET/Transmit/0123456789". Details:"Object reference not set to an instance of an object.".
And similarily with the Microsoft provider it is the same error.
The adapter failed to transmit message going to send port "oraclepipe://Microsoft .NET Data Provider for Oracle/Transmit/0123456789". It will be retransmitted after the retry interval specified for this Send Port. Details:"Object reference not set to an instance of an object.".
Could this happen if the stored proc waiting on the response timesout before Biztalk sends it?
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 9 December 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
We have just released version 4.0.4 of the Adapter which patches the issue.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 21 December 2006
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Sorry it took so long to reply.
It works! Thank you soo much!
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 2 January 2007
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello again
While that adapters are now working with my receive port and a static send port. I need to make them work with a dynamic send port. Based on the thread you have with paul, i was able to figure out that after creating the dynamic port with my custom pipeline, i need to add the URI to the Address property of the port in an expression shape, which I have copied from the static port. I then add the Connection string to the connection string property of the message in the construct shape, also copied from the static port.
I'm getting the same error i was getting before you released the new version of the adapter. This is a failure to transmit messages. And the error is Object not set to reference of object. here is the error.
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Oracle Pipes Transport.
System.NullReferenceException
Object reference not set to an instance of an object."
Exception InnerException = {
String HelpLink = ""
String Message = ""
String Source = ""
String StackTrace = ""
String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 3884
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 = "XXXXXX"
String ProcessAccountName = "XXXXXX"
}
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.Oracle.Pipes.Transmit.Batch.SendMessages(IBaseMessage[] messages)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "555d355f-58bc-4cfa-b73f-4ff5c1f69af3"
String EventSourceName = "BizTalk Utilities Adapter for Databases Oracle Pipes Transmitter"
Int64 EventSequenceNumber = 32
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 1/2/2007 3:42:24 PM
String AppDomainName = "DefaultDomain"
String MachineName = "XXXXXXX"
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.
I don't know whether it's an error with the adapter, or that i'm just missing a property i need to set, but if you could help me out, i'd much appreciate it.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 4 January 2007
|
|
|
msinnet
Posts: 18
Score: 0
Joined: 27 October 2006
Status: offline
|
Hello
I sent the email to support. It is from Matthew Sinnett at UnionGas.
Thanks
Matt
|
|
|
|
|
RE: Problems with Oracle Pipes Adapter - 6 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Thank you very much for the sample.
We have patched the issue in version 4.0.5 which is currently available for download.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
 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