Tuesday, 20 January 2015

BPM12c: Patch for 'ora:getAttachmentProperty: Failed to decode properties string '

Last december I reported running into a problem getting attachments and attachments properties in this blog-post. I created a Service Request for it and last week it resulted in a one-off patch:

  • Patch 18511990 VITAL INFORMATION LOST WHEN RECEIVING EMAILS WITH CONTENT-TYPE MULTIPART/RELATED (Patch)
Because there are multiple versions available for download, you should make sure to download the appropriate version; in my case it was 12.1.3.


2 comments :

Vaibhav Saraogi said...

Hi,

I too tried using ora:getAttachmentProperty. And the error which I get is weird. I am not able to understand possible reason for it. Can you please help-

What I am trying to do - Currently able to save attachment to disk however I want to save attachment with same name which came in email.

Error thrown by SOA server is

XPath expression failed to execute.
An error occurs while processing the XPath expression; the expression is ora:getAttachmentProperty('Content-Description',$Receive1_ReceiveNotification_InputVariable.body/ns3:attachment[$counter]/@href).
The XPath expression failed to execute; the reason was: java.lang.ClassCastException: oracle.xml.parser.v2.XMLAttr cannot be cast to java.lang.String.
Check the detailed root cause described in the exception message text and verify that the XPath query is correct.


**$counter used in expression is to loop through multiple attachments.

Any help would be appreciated. :)

Martien van den Akker said...

Hi Vaibhav,

I think it's in the fact that you added '/@href' to the xpath. Can you try without it?
The input of the function is the attachment object where it interprets it by getting the attribute.

Regards,
Martien