Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refresh from My Oracle Support Job Failed in OEM Grid Ctrl 11g

859985Jul 17 2011
Hi,

The job "Refresh from My Oracle Support Failed" with the error provided below. Need you input on this.

Online Mode. Using My Oracle Support.


Checking My Oracle Support authorization.
Username: karthick.s.thoppean@verizon.com
Password: ******
Patch Search URL: https://updates.oracle.com


Proxy Server details
-------------------------
Either you are using a 'No proxy' connection or the Patch Search URL is not set up to use the Proxy Server.



ARU Data Details
---------------------------
URL : .../metadata?table=aru_products
Got From : the update site over HTTP.
Size (bytes) : 199538
Download Time (ms) : 2496

URL : .../metadata?table=aru_releases
Got From : the update site over HTTP.
Size (bytes) : 442985
Download Time (ms) : 14118

URL : .../metadata?table=aru_platforms
Got From : the update site over HTTP.
Size (bytes) : 4651
Download Time (ms) : 858

URL : .../metadata?table=aru_languages
Got From : the update site over HTTP.
Size (bytes) : 3098
Download Time (ms) : 842

URL : .../metadata?table=aru_product_groups
Got From : the update site over HTTP.
Size (bytes) : 333286
Download Time (ms) : 11060

URL : .../metadata?table=aru_product_releases
Got From : the update site over HTTP.
Size (bytes) : 4396144
Download Time (ms) : 145587

URL : .../metadata?table=aru_component_releases
Got From : the update site over HTTP.
Size (bytes) : 117642
Download Time (ms) : 13157

URL : .../metadata?table=aru_targets
Got From : the update site over HTTP.
Size (bytes) : 12910
Download Time (ms) : 1404

URL : .../search?language_id=0&classification_group=recommended&patch_type=all&group_by=target_type&group_by=release&group_by=platform
Got From : the update site over HTTP.
Size (bytes) : 7940165
Download Time (ms) : 627881


.../metadata?table=aru_products : Parsing...Done : Loading...Done
Parse Time (ms) : 758
Load Time (ms) : 18214

.../metadata?table=aru_releases : Parsing...Done : Loading...Done
Parse Time (ms) : 77
Load Time (ms) : 3741

.../metadata?table=aru_platforms : Parsing...Done : Loading...Done
Parse Time (ms) : 1
Load Time (ms) : 887

.../metadata?table=aru_languages : Parsing...Done : Loading...Done
Parse Time (ms) : 1
Load Time (ms) : 954

.../metadata?table=aru_product_groups : Parsing...Done : Loading...Done
Parse Time (ms) : 73
Load Time (ms) : 2183

.../metadata?table=aru_product_releases : Parsing...Done : Loading...Done
Parse Time (ms) : 1908
Load Time (ms) : 16475

.../metadata?table=aru_component_releases : Parsing...Done : Loading...Done
Parse Time (ms) : 24
Load Time (ms) : 283

.../metadata?table=aru_targets : Parsing...Done : Loading...Done
Parse Time (ms) : 3
Load Time (ms) : 594


Patch Recommendations Details
-----------------------------
Parsing and storing patch recommendations...



- Error encountered when parsing patch data. oracle.xml.parser.v2.XMLParseException: Unexpected EOF.

Thanks in Advance,
-KarthicK

Comments

Martien van den Akker

Hi,

You can transform them directly, using an XSLT. But, if you want to loop over the elements, and perform an action approver by approver, you should create a loop with a loop counter that selects each approver into a variable. Take a look at this article where I describe how I did it in PCS: https://blog.darwin-it.nl/2017/07/process-cloud-service-and-how-to-loop.html It works exactly the same way in BPM.

Regards,
Martien

d465f42a-f285-4724-b7d9-9bbf75085cf4

With Metastorm BPM v7 becoming 'Past Maintenance' in January 2018, users left on versions previous to the current OpenText MBPM v9, will run an ever-increasing risk that changes to their applications, infrastructure or operating systems will cause issues in business-critical BPM solutions.

Martien van den Akker

I'm sorry, but what does this have to do with the question? How is this related to Oracle BPM Suite?

Regards,
Martien

Robinson J

Hi,

Thanks for the help but in your case , you already have a list, in my case I do not have a list, but a string which has comma delimited values. I need to extract each value and convert them to list of values, so that then i could then loop over them.

I tried a few functions in XSLT like oraext:create-nodeset-from-delimited-string but no luck.

I have the XSD of the List into which i would like to copy the extracted values.

<?xml version="1.0" encoding="UTF-8"?>

<schema attributeFormDefault="unqualified" elementFormDefault="qualified"

        targetNamespace="http://xmlns.oracle.com/A_OS46TCO_01/Project4/BPELProcess1"

        xmlns="http://www.w3.org/2001/XMLSchema">

  <element name="ApproverList">

    <complexType>

      <sequence>

        <element name="approver" type="string" maxOccurs="unbounded"/>

   

      </sequence>

    </complexType>

  </element>

</schema>

I then tried to have a XSLT like

<xsl:variable name="approvers" select="/ns0:iprocess/ns0:inputList"/>

      <xsl:variable name="pos" select='oraext:create-nodeset-from-delimited-string(tns:approver,$approvers,",")'></xsl:variable>

      <xsl:for-each select="$pos">

        <xsl:variable name="counter" select="position()"/>

        <tns:approver>

          <xsl:value-of select="$pos[$counter]"/>

        </tns:approver>

      </xsl:for-each>

This function oraext:create-nodeset-from-delimited-string seems to work on SOA - BPEL with Copylist - copy rule in the Assign Operation . Any idea on how to acheive the same is highly appreciated.

Thanks in Advance

Martien van den Akker

Oh, but then you have switched your source and target samples in your original question! That's how I interpretted it.

In that case, you need to understand that XSLT is actually a functional programming language, which means that variables in XSLT are immutable.

You can solve this by using recursion. See for intance https://blog.darwin-it.nl/2010/08/index-of-replace-and-key-value-parsing.html especially the replace template. I think you need a template like:

<xsl:template name="parseDelimitedString">

  <xsl:param "delimitedStr"/>

  <!-- https://www.w3schools.com/xml/xsl_functions.asp

  <xsl:variable name="firstItem" select="substring-before($delimitedStr, ',')" />

  <xsl:variable name="restDelimitedStr" select="substring-after($delimitedStr, ',')" />

  <tns:approver>

    <xsl:value-of select="$firstItem"/>

  </tns:approver>

  <xsl:call-template name="parseDelimitedString">

    <xsl:with-param name="delimitedStr" select="$restDelimitedStr"/>

  </xsl:call-template>

</xsl:template>

That you can call with:

  <xsl:call-template name="parseDelimitedString">

    <xsl:with-param name="delimitedStr" select="select="/ns0:iprocess/ns0:inputList"/>

  </xsl:call-template>

(Typed by heart, not tested)

Regards,

Martien

Robinson J

Hi,

Thanks a lot for the help, I just had to add the exit condition for the recursion and then could achieve my requirement.

  <xsl:template name="parseDelimitedString">

        <xsl:param name="delimitedStr"/>

        <!-- https://www.w3schools.com/xml/xsl_functions.asp -->

        <xsl:variable name="firstItem" select="substring-before($delimitedStr, ',')"/>

        <xsl:variable name="restDelimitedStr" select="substring-after($delimitedStr, ',')"/>

        <tns:approvers>

            <xsl:value-of select="$firstItem"/>

        </tns:approvers>

        <xsl:choose>

        <xsl:when test="contains($restDelimitedStr, ',')">

            <xsl:call-template name="parseDelimitedString">

                <xsl:with-param name="delimitedStr" select="$restDelimitedStr"/>

            </xsl:call-template>

        </xsl:when>         

          <xsl:otherwise>

            <tns:approvers>

              <xsl:value-of select="$restDelimitedStr"/>

            </tns:approvers>

          </xsl:otherwise>

        </xsl:choose>

       

    </xsl:template>

Martien van den Akker

Yes indeed: forgot that: Recursion => always add an end condition!


Nice that it works.

Regards,
Martien

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2011
Added on Jul 17 2011
0 comments
767 views