Oracle Alerts Event Errors

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

Oracle Alerts Event Errors

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 >> Oracle Alerts Event Errors

Page: [1]

Message

<< Older Topic Newer Topic >>

Oracle Alerts Event Errors - 22 February 2007

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

Hi Everyone...I've just created a new Oracle Alert based on the samples documentation and am getting the following error in the event viewer as the hosts are starting up. Does anyone know what this means? Does it mean my alert filter is too long?

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Oracle Alerts Receiver
Event Category: None
Event ID: 0
Date:  2/22/2007
Time:  1:29:38 PM
User:  N/A
Computer: S1181393
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to start an EndPoint. The Uri is 'oraclealert://Microsoft .NET Data Provider for Oracle/CARE_DP_FORECAST_CONS_LOG.insert'
System.Exception
An Error occurred attempting to Register for an Alert. Details are as follows:
System.Data.OracleClient.OracleException: ORA-01401: inserted value too large for column
ORA-06512: at "SYS.DBMS_ALERT", line 103
ORA-06512: at line 1
   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciHandle& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at BTSUtils.Adapters.Databases.Oracle.Alerts.Client.Register(String name)"
Exception InnerException = {
     String HelpLink = <null>
     String Message = "ORA-01401: inserted value too large for column
ORA-06512: at "SYS.DBMS_ALERT", line 103
ORA-06512: at line 1
"
     String Source = "System.Data.OracleClient"
     String StackTrace = "   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciHandle& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at BTSUtils.Adapters.Databases.Oracle.Alerts.Client.Register(String name)"
     String TargetSite = "System.Reflection.RuntimeMethodInfo.CheckError"
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 4668
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 = "DEGT\btutr_str"
     String ProcessAccountName = "DEGT\btutr_str"
}
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.Alerts.Receive.EndPoint.Start()
at BTSUtils.Core.Adapters.Receive.Asynchronous.Receiver.AddReceiveEndpoint(String bstrURL, IPropertyBag pConfig, IPropertyBag pBizTalkConfig)"
String EventSourceInstance = "9ce7fddd-a87a-415a-81f6-d2d68f3c6a8f"
String EventSourceName = "BizTalk Utilities Adapter for Databases Oracle Alerts Receiver"
Int64 EventSequenceNumber = 6
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 2/22/2007 1:29:38 PM
String AppDomainName = "DefaultDomain"
String MachineName = "S1181393"
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.

Post #: 1

RE: Oracle Alerts Event Errors - 22 February 2007

Pieter

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

This seems to be an issue with the name of the alert. What is the name of the alert?

_____________________________

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

(in reply to brupert)

Post #: 2

RE: Oracle Alerts Event Errors - 23 February 2007

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

Hi Pieter
If I understand what you are asking for the alert text (configured in the address URI) is "CARE_DP_FORECAST_CONS_LOG.insert".

(in reply to Pieter)

Post #: 3

RE: Oracle Alerts Event Errors - 25 February 2007

Pieter

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

Any idea what the size of the messages are?

_____________________________

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

(in reply to brupert)

Post #: 4

RE: Oracle Alerts Event Errors - 26 February 2007

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

Here is my trigger, the commented out line is the value I'm intending to send, but since I had trouble I changed it to something smaller ("test").

CREATE OR REPLACE TRIGGER CDPFCL_BTS_TRIGGER
AFTER
INSERT OR UPDATE
ON CARE_DP_FORECAST_CONS_LOG
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
message varchar2(800);
begin
--message := :new.year || ' ' || :new.month || '|';
message := 'test';
dbms_alert.signal('CARE_DP_FORECAST_CONS_LOG.insert',message);
end;
/

(in reply to Pieter)

Post #: 5

RE: Oracle Alerts Event Errors - 27 February 2007

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

Pieter, I fixed my problem - changing the length of the alert text got me going. Now I'm having issues with it not finding a matching subscription for the message. Not sure what that is.

(in reply to Pieter)

Post #: 6

RE: Oracle Alerts Event Errors - 28 February 2007

Pieter

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

This means that biztalk did not recognize the message.

_____________________________

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

(in reply to brupert)

Post #: 7