CODEWITHSUNDEEP
oracle11godp.netoracle-aq
Philip Fourie
Philip Fourie

Reputation: 117007

Cannot enqueue large Oracle AQ message

I am trying to Enqueue a message onto an Oracle Queue from a .NET client. If the message exceeds a certain size, the following error occurs:

ORA-01013: user requested cancel of current operation

This happens with both XMLTYPE and raw as the queue table's message type.

It seems that the size of the message is to blame but cannot tell for sure be cause of the limited Oracle error message.

Is there a limit on the size, can I increase the size or is there another way to overcome this issue?

Update:

Upvotes: 0

Views: 1251

Answers (2)

Lukas Eder
Lukas Eder

Reputation: 221145

There are a couple of size-related issues being fixed for 11.2.0.3. See this non-authoritative list here:

http://www.eygle.com/Notes/11.2.0.3.html

Some examples:

9878459  Specific length object binds over 4k may be bound as NULL
10389881 Raw buffered message payload > 8k corrupted when dequeued 
         from a buffered queue

Maybe, your issue is in this list?

Upvotes: 1

Kiran Mothe
Kiran Mothe

Reputation: 685

This sounds like a connection timeout from the .net client. Try increasing the timeout. If that doesn't work, check if the issue is with the message payload by inserting the message directly through dbms_aq.enqueue(...). If you are able insert, then the message itself is fine.

Upvotes: 1

Related Questions