Oracle SOA DB Poller Error-Caused by BINDING.JCA-11608 Connection Already Closed Exception.

Error :
 BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [pollALPSelect], Descriptor name: [pollALP.IfAlpOwner]. Polling the database for events failed on this iteration.
Caused by BINDING.JCA-11608
Connection Already Closed Exception.
This [javax.resource.cci.Connection] is already closed.
This should not happen when running within a packaged application like BPEL or ESB but may occur when the adapter is used standalone.

Reason :
 Made changes to the weblogic server data source / Connection factory leads to a DB adaptor redeploy and that DB adaptor incidences will fail with the same error.


Solution :
Retire all DB Pollers which have encountered this error.
Activate all DB  Pollers.

The issue will be fixed.

ADRS_DOMAIN_PASSWORD environment variable not set in SOA Suite 12.2.1

 I have installed the JDeveloper on Windows10 but hitting an issue while I try to start the server (Integrated Web logic Server). The below is the error message:

Process started
wlst > 
wlst > Initializing WebLogic Scripting Tool (WLST) ...
wlst > 
wlst > Welcome to WebLogic Server Administration Scripting Shell
wlst > 
wlst > Type help() for help on available commands
wlst > 
wlst > Failed to get environment, environ will be empty: (0, 'Failed to execute command ([\'sh\', \'-c\', \'env\']): java.io.IOException: Cannot run program "sh": CreateProcess error=2, The system cannot find the file specified')
wlst > Error:  ADRS_DOMAIN_PASSWORD environment variable not set.
wlst > 
wlst > 
wlst > Exiting WebLogic Scripting Tool.
wlst > 
wlst > Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=384m; support was removed in 8.0
Elapsed time:  12308 ms

Cause

Weblogic jython libraries do not recognize the operating system.

Solution

Oracle generated the patch 22138883. This patch fixes the problem ...

You could follow the steps as below (Added all the steps since I have seen may of the post reference links are missing or removed from corresponding sites), Steps to follow: Copy jython-modules.jar file from "\WL_Home\wlserver\common\wlst\modules*" as a backup. Unzip it (Use Winrar, 7-zip., etc) Open javashell.py file in editor from unzipped folder "Eg:\WL_Home\wlserver\common\wlst\modules\jython-modules\Lib" Search for the following text "_osTypeMap". _osTypeMap = ( ( "nt", ( 'nt', 'Windows NT', 'Windows NT 4.0', 'WindowsNT', 'Windows 2000', 'Windows 2003', 'Windows XP', 'Windows CE', 'Windows Vista', 'Windows Server 2008', 'Windows 7', 'Windows 8', 'Windows Server 2012')), ( "dos", ( 'dos', 'Windows 95', 'Windows 98', 'Windows ME' )), ( "mac", ( 'mac', 'MacOS', 'Darwin' )), ( "None", ( 'None', )), ) Add 'Windows 10' next to the 'Windows Server 2012' as mentioned below, _osTypeMap = ( ( "nt", ( 'nt', 'Windows NT', 'Windows NT 4.0', 'WindowsNT', 'Windows 2000', 'Windows 2003', 'Windows XP', 'Windows CE', 'Windows Vista', 'Windows Server 2008', 'Windows 7', 'Windows 8', 'Windows Server 2012','Windows 10')), ( "dos", ( 'dos', 'Windows 95', 'Windows 98', 'Windows ME' )), ( "mac", ( 'mac', 'MacOS', 'Darwin' )), ( "None", ( 'None', )), ) Open the command prompt mostly in admin mode, then execute the command jar –cvf jython-modules.jar * as show in image below (Make sure your jdk path shouldn't have any space, I have faced issue so just copied complete jdk fodler into C-Drive),  Copy the latest jar file which is generated in "WL_HOME\wlserver\common\wlst\modules\jython-modules" into "WL_HOME\wlserver\common\wlst\modules". Now start the IntegratedWebLogicServer from yout JDeveloper. It will create based on new domain credentials and you could able to access the server console after successful creation of domain.

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