Unable to create instance of Java Virtual Machine: Jdeveloper

Issue:

 

 Solution:
 The below2 files  must be modified
           C:\Oracle\Middleware\jdeveloper\ide\bin\ide.conf
           C:\Oracle\Middleware\jdeveloper\jdev\bin\jdev.conf

  ide.conf : Add the following lines
                        AddVMOption  -Xmx940M
                       AddVMOption  -Xms128M

jdev.conf :
                    AddVMOption  -XX:MaxPermSize=356M

Sum of the resultant nodes of the apply template in XSLT

No Explanation, just a example with sample xml's and screen shots.

Request XML:



<?xml version="1.0" encoding="UTF-8" ?>
<process xmlns:ns0="http://xmlns.oracle.com/Application3/SampleProject/BPELProcess1">
   <mulWeight>
      <weight>800</weight>
      <UoMCodeWei>grm</UoMCodeWei>
   </mulWeight>
   <mulWeight>
      <weight>9000</weight>
      <UoMCodeWei>grm</UoMCodeWei>
   </mulWeight>
   <mulWeight>
      <weight>1000000</weight>
      <UoMCodeWei>mrm</UoMCodeWei>
   </mulWeight>
</process>





XSLT File:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                xmlns="http://xmlns.oracle.com/Application3/SampleProject/BPELProcess1"
                exclude-result-prefixes="msxsl">
  <xsl:template match="/process">
    <xsl:variable name="resultGroup">
      <xsl:apply-templates select="mulWeight"/>
    </xsl:variable>
    <processResponse>
      <result>
        <xsl:value-of select="sum(msxsl:node-set($resultGroup)/*)"/>
      </result>
    </processResponse>
  </xsl:template>
  <xsl:template match="mulWeight">
    <xsl:if test="UoMCodeWei='grm'">
      <result>
        <xsl:value-of select="weight div 1000"/>
      </result>
    </xsl:if>
    <xsl:if test="UoMCodeWei='mrm'">
      <result>
        <xsl:value-of select="weight div 1000000"/>
      </result>
    </xsl:if>
  </xsl:template>
</xsl:stylesheet>

Result XML :

<?xml version = '1.0' encoding = 'UTF-8'?>
<processResponse xmlns="http://xmlns.oracle.com/Application3/SampleProject/BPELProcess1">
   <result>10.8</result>
</processResponse>

Requested audit trail size is larger than threshold

Unable to open audit trial on EM Exception:Requested audit trail size is larger than threshold 1048576 chars
Error: Exception occured while retrieving the Flowtrace XML for the Composite Instancejava.lang.RuntimeException: oracle.soa.management.facade.DataSetTooLargeException: Requested audit trail size is larger than threshold 1048576 chars

To change instanceTrackingAuditTrailThreshold -
1. Right click on SOA-Infra and navigate till Audit Config
SOA_Infra ->Administration -> System Mbean Browser ->Application Defined MBeans ->oracl.as.soinfa.config ->Select server ->SoaInfraConfig -> soa-infra -> Audit Config

2. Change instanceTrackingAuditTrailThreshold value(In my case we have to raise it till 4 MB) and click Apply.

DB Adapter Wizard Issue After Exporting The SAR

When there is scenario like we have exported the BPEL SAR file from EM Console and then trying to open the DB adapter wizard from JDeveloper, it doesn't open the wizard. We need to do the following work around to solve this,

Open the DB adapter wsdl file and add the .jca file name as mentioned below.

<?xml version='1.0' encoding='UTF-8'?>
<?binding.jca PL_INSERT_Data_db.jca?>

Steps to apply the patch in webLogic Server

Steps to apply the patch in webLogic Server

1)      Copy the below attached patch file local to your system.

2)      Extract the contents from the zip file. We will have a jar file and patch-catalog_xxx.xml.

Copy the files (AYBZ.jar and patch-catalog_22669.xml) to the appropriate cache_dir directory for the target system i.e, $MIDDLEWARE_HOME/utils/bsu/cache_dir.

Ex: /opt/fmw11g/utils/bsu/cache_dir

Note: The directory MW_HOME\utils\bsu\cache_diris created as the default patch download directory when you install Smart Update 3.3.0.

3)      Log in to the putty using target system credentials and run the below command to navigate to bsu folder.

cd /opt/fmw11g/utils/bsu

4)      Command to view the downloaded patches as below:[optional]

./bsu.sh -prod_dir=/opt/fmw11g/wlserver_10.3 -patch_download_dir=/opt/fmw11g/utils/bsu/cache_dir -status=downloaded -view -verbose

5)      Below is the command to install a patch

./bsu.sh -prod_dir=/opt/fmw11g/wlserver_10.3 -patchlist=AYBZ -verbose –install

6)      Command to check if the patch is installed:

./bsu.sh -prod_dir=/opt/fmw11g/wlserver_10.3 -status=applied -verbose –view

NOTE: We need to apply the Patches for WLS installation and not per domain. If we have a managed server in another machine in a domain (that is, set up with its own WLS installation), we need to install this patch on that other machine as well.

References:

1.       Patch Download Location: https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=1903457.1&patchId=20523619

2.       Reference doc to apply the patch:

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1903457.1&id=876004.1

Xquery to find duplciate data in the xml elements

Sample XML :
 <?xml version="1.0" encoding="UTF-8" ?>
<VehicleStatusData>
   <VehicleStatus>
      <position>
         <latitude>90.73</latitude>
         <longitude>100.73</longitude>
      </position>
      <status>
         <VehicleStatusEntry name="DOOR_POSITION_FRONT_LEFT" value="value12"/>
         <VehicleStatusEntry name="DOOR_POSITION_FRONT_LEFT" value="value14"/>
         <VehicleStatusEntry name="DOOR_POSITION_REAR_LEFT" value="value16"/>
      </status>
   </VehicleStatus>
</VehicleStatusData>

 Xquery to return duplicate data :
(:: pragma bea:global-element-parameter parameter="$vehicleStatusData1" element="VehicleStatusData" location="TeleWCDDIVHS.xsd" ::)

declare namespace xf = "http://tempuri.org/HelloWorld/sss/";

declare function xf:sss($vehicleStatusData1 as element(VehicleStatusData))
    {
        <DuplicateNames>
            {
             
                for $id in distinct-values($vehicleStatusData1/VehicleStatus/status/VehicleStatusEntry/@name)
                        where count($vehicleStatusData1/VehicleStatus/status/VehicleStatusEntry[@name eq $id]) gt 1
                        return $id
               
                 
            }
        </DuplicateNames>
};

declare variable $vehicleStatusData1 as element(VehicleStatusData) external;

xf:sss($vehicleStatusData1)