Problem with Oracle receive port

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

Problem with Oracle receive port

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 >> Problem with Oracle receive port

Page: [1]

Message

<< Older Topic Newer Topic >>

Problem with Oracle receive port - 13 November 2006

Shreyas

Posts: 26
Score: 0
Joined: 1 November 2006
Status: offline

Hi
I have craeted oracle receive port to retrive data from oracle by writing procedure inside a oracle adapter. The orch build without any error. But when i have deployed this orch and created port for oracle I receive following error :

"BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Oracle Data Provider for .NET Version 10.1.0.400//selStatusCnt'
Oracle.DataAccess.Client.OracleException
ORA-01403: no data found
ORA-06512: at "SYS.ALPS_COUNT_ORDER_STATUS_PACK", line 12
ORA-06512: at line 1"
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 4932
String ProcessName = "D:\PROGRA~1\MICROS~2\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "CORP\jyotsnad"
     String ProcessAccountName = "BUILTIN\Administrators"
}
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.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
String EventSourceInstance = "8254f9e7-896b-40ef-9f16-d811092cab4a"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 6
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 11/13/2006 6:21:23 PM
String AppDomainName = "DefaultDomain"
String MachineName = "AE3"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}"

even if data to retrive from database is present in table.
How to solve this error?

Thanks

Post #: 1

RE: Problem with Oracle receive port - 13 November 2006

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

It seems that there is an issue with your Stored Procedure.

Have a look at the following link:

http://www.techonthenet.com/oracle/errors/ora01403.php

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Shreyas)

Post #: 2