sort access_log file and find out the no of requests to each service

sort access_log file and find out the no of requests to each service

Use the command to

C:\cygwin64\bin\gawk '{print $7}'  E:\tars-download\osb_server2_access.log | C:\cygwin64\bin\sort.exe | C:\cygwin64\bin\uniq.exe -c | C:\cygwin64\bin\sort.exe -nr  | head -20

These are the top 20 Proxy services that are called multiple times

20618 /xxx

  20533 /xxx1

  15022 /xxx3

 ..

..

Tags: Publish
September 18, 2018 at 11:55AM
Open in Evernote

coherence adapter to work with external remote cache

coherence adapter to work with external remote cache

I have followed the exact steps given in the URL below to make the coherence adapter to work with external remote cache

https://docs.oracle.com/cd/E15357_01/coh.360/e15726/gs_example.htm

1. create a file

example-config.xml

++

<?xml version="1.0"?>

<!DOCTYPE cache-config SYSTEM "cache-config.dtd">

<cache-config>

  <caching-scheme-mapping>

     <cache-mapping>

        <cache-name>dist-extend</cache-name>

        <scheme-name>extend</scheme-name>

     </cache-mapping>

  </caching-scheme-mapping>

  <caching-schemes>

     <distributed-scheme>

        <scheme-name>extend</scheme-name>

        <lease-granularity>member</lease-granularity>

        <backing-map-scheme>

           <local-scheme/>

        </backing-map-scheme>

        <autostart>true</autostart>

     </distributed-scheme>

     <proxy-scheme>

        <service-name>ExtendTcpProxyService</service-name>

        <thread-count>5</thread-count>

        <acceptor-config>

           <tcp-acceptor>

              <local-address>

                 <address>localhost</address>

                 <port>9099</port>

              </local-address>

           </tcp-acceptor>

        </acceptor-config>

        <autostart>true</autostart>

     </proxy-scheme>

  </caching-schemes>

</cache-config>

++

2. Create a file

extend-config.xml

++

<?xml version="1.0"?>

<!DOCTYPE cache-config SYSTEM "cache-config.dtd">

<cache-config>

 <caching-scheme-mapping>

   <cache-mapping>

     <cache-name>dist-extend</cache-name>

     <scheme-name>remote</scheme-name>

   </cache-mapping>

 </caching-scheme-mapping>

 <caching-schemes>

   <remote-cache-scheme>

     <scheme-name>remote</scheme-name>

     <service-name>ExtendTcpCacheService</service-name>

     <initiator-config>

       <tcp-initiator>

         <remote-addresses>

           <socket-address>

             <address>localhost</address>

             <port>9099</port>

           </socket-address>

         </remote-addresses>

         <connect-timeout>10s</connect-timeout>

       </tcp-initiator>

       <outgoing-message-handler>

         <request-timeout>5s</request-timeout>

       </outgoing-message-handler>

     </initiator-config>

   </remote-cache-scheme>

   <remote-invocation-scheme>

     <scheme-name>extend-invocation</scheme-name>

     <service-name>ExtendTcpInvocationService</service-name>

     <initiator-config>

       <tcp-initiator>

         <remote-addresses>

           <socket-address>

             <address>localhost</address>

             <port>9099</port>

           </socket-address>

         </remote-addresses>

         <connect-timeout>10s</connect-timeout>

       </tcp-initiator>

       <outgoing-message-handler>

         <request-timeout>5s</request-timeout>

       </outgoing-message-handler>

     </initiator-config>

   </remote-invocation-scheme>

 </caching-schemes>

</cache-config>

++

3. Run the external coherence server using the command

java -cp /fmw11g/soa12212/coherence/lib/coherence.jar:. -Dtangosol.coherence.cacheconfig=example-config.xml com.tangosol.net.DefaultCacheServer

4. Modify the Outbound Connection Pool Configuration Table for

eis/Coherence/Remote

with the following

CacheConfigLocation java.lang.String /home/oracle/extend-config.xml

ClassLoaderMode java.lang.String CUSTOM

ConnectionFactoryLocation java.lang.String <blank>

PojoJarFile java.lang.String <blank>

ServiceName java.lang.String  <blank>

WLSExtendProxy java.lang.Boolean false

Here blank means no value.

5. Deploy the SOA Project ,

extract the project Cohe1.zip and deploy the coherence soa project.

Refer to the uploaded file Cohe1.zip

6. Run the BPELProcess1 with the input as say TEST1234567890 ,

on successful execution this creates a cache entry with the key as test1 and value as "TEST1234567890".

Check the flow trace , if everything goes well this you should see no error's.

Now run BPELProcess2 , give input as any random value , this reads coherence with the key name as "test1" and get's the value for the key "test1".

Successful execution should give the result as "TEST1234567890"

Tags: Publish
September 17, 2018 at 04:09PM
Open in Evernote

How to set weblogic Server Debug flags using WLST Scripts

How to set weblogic Server Debug flags using WLST Scripts

How to set weblogic Server Debug flags using WLST Scripts

-- Get List of Debug Flags available with Weblogic Server

connect('weblogic','Welcome1','t3://localhost:7001')

cd('/Servers/AdminServer/ServerDebug/AdminServer')

ls()

exit()

To set the Debug Flags for example DebugJDBCSQL , DebugJTAXA abd DebugJTAJDBC

connect('weblogic','Welcome1','t3://localhost:7001')

edit()

startEdit()

cd('/Servers/AdminServer/ServerDebug/AdminServer')

cmo.setDebugJDBCSQL(true)

cmo.setDebugJTAXA(true)

cmo.setDebugJTAJDBC(true)

save()

activate()

exit()

To unset the Debug Flags for example DebugJDBCSQL , DebugJTAXA abd DebugJTAJDBC

connect('weblogic','Welcome1','t3://localhost:7001')

edit()

startEdit()

cd('/Servers/AdminServer/ServerDebug/AdminServer')

cmo.unSet('DebugJDBCSQL')

cmo.unSet('DebugJTAXA')

cmo.unSet('DebugJTAJDBC')

save()

activate()

exit()

Lif of WLS Server Debug Flags

wls:/soa_domain/serverConfig> cd('/Servers/AdminServer/ServerDebug/AdminServer')

wls:/soa_domain/serverConfig/Servers/AdminServer/ServerDebug/AdminServer> ls()

dr--   Server

-r--   ApplicationContainer                         false

-r--   ClassChangeNotifier                          false

-r--   ClassFinder                                  false

-r--   ClassLoader                                  false

-r--   ClassLoaderVerbose                           false

-r--   ClassloaderWebApp                            false

-r--   ClasspathServlet                             false

-r--   DebugAbbreviation                            false

-r--   DebugAppContainer                            false

-r--   DebugAsyncQueue                              false

-r--   DebugBootstrapServlet                        false

-r--   DebugCertRevocCheck                          false

-r--   DebugClassRedef                              false

-r--   DebugClassSize                               false

-r--   DebugCluster                                 false

-r--   DebugClusterAnnouncements                    false

-r--   DebugClusterFragments                        false

-r--   DebugClusterHeartbeats                       false

-r--   DebugConfigurationEdit                       false

-r--   DebugConfigurationRuntime                    false

-r--   DebugConnection                              false

-r--   DebugConnectorService                        false

-r--   DebugConsensusLeasing                        false

-r--   DebugDGCEnrollment                           false

-r--   DebugDRSCalls                                false

-r--   DebugDRSHeartbeats                           false

-r--   DebugDRSMessages                             false

-r--   DebugDRSQueues                               false

-r--   DebugDRSStateTransitions                     false

-r--   DebugDRSUpdateStatus                         false

-r--   DebugDeploy                                  false

-r--   DebugDeployment                              false

-r--   DebugDeploymentPlan                          false

-r--   DebugDeploymentService                       false

-r--   DebugDeploymentServiceInternal               false

-r--   DebugDeploymentServiceStatusUpdates          false

-r--   DebugDeploymentServiceTransport              false

-r--   DebugDeploymentServiceTransportHttp          false

-r--   DebugDescriptor                              false

-r--   DebugDiagnosticAccessor                      false

-r--   DebugDiagnosticArchive                       false

-r--   DebugDiagnosticArchiveRetirement             false

-r--   DebugDiagnosticCollections                   false

-r--   DebugDiagnosticContext                       false

-r--   DebugDiagnosticDataGathering                 false

-r--   DebugDiagnosticFileArchive                   false

-r--   DebugDiagnosticImage                         false

-r--   DebugDiagnosticInstrumentation               false

-r--   DebugDiagnosticInstrumentationActions        false

-r--   DebugDiagnosticInstrumentationConfig         false

-r--   DebugDiagnosticInstrumentationEvents         false

-r--   DebugDiagnosticInstrumentationWeaving        false

-r--   DebugDiagnosticInstrumentationWeavingMatches false

-r--   DebugDiagnosticJdbcArchive                   false

-r--   DebugDiagnosticLifecycleHandlers             false

-r--   DebugDiagnosticQuery                         false

-r--   DebugDiagnosticWatch                         false

-r--   DebugDiagnosticWlstoreArchive                false

-r--   DebugDiagnosticsHarvester                    false

-r--   DebugDiagnosticsHarvesterData                false

-r--   DebugDiagnosticsHarvesterMBeanPlugin         false

-r--   DebugDiagnosticsHarvesterTreeBeanPlugin      false

-r--   DebugDiagnosticsModule                       false

-r--   DebugDomainLogHandler                        false

-r--   DebugEjbCaching                              false

-r--   DebugEjbCmpDeployment                        false

-r--   DebugEjbCmpRuntime                           false

-r--   DebugEjbCompilation                          false

-r--   DebugEjbDeployment                           false

-r--   DebugEjbInvoke                               false

-r--   DebugEjbLocking                              false

-r--   DebugEjbMdbConnection                        false

-r--   DebugEjbPooling                              false

-r--   DebugEjbSecurity                             false

-r--   DebugEjbSwapping                             false

-r--   DebugEjbTimers                               false

-r--   DebugEmbeddedLDAP                            false

-r--   DebugEmbeddedLDAPLogLevel                    0

-r--   DebugEmbeddedLDAPLogToConsole                false

-r--   DebugEmbeddedLDAPWriteOverrideProps          false

-r--   DebugEventManager                            false

-r--   DebugFailOver                                false

-r--   DebugFileDistributionServlet                 false

-r--   DebugHttp                                    false

-r--   DebugHttpLogging                             false

-r--   DebugHttpSessions                            false

-r--   DebugIIOP                                    false

-r--   DebugIIOPConnection                          false

-r--   DebugIIOPMarshal                             false

-r--   DebugIIOPNaming                              false

-r--   DebugIIOPOTS                                 false

-r--   DebugIIOPReplacer                            false

-r--   DebugIIOPSecurity                            false

-r--   DebugIIOPStartup                             false

-r--   DebugIIOPTransport                           false

-r--   DebugIIOPTunneling                           false

-r--   DebugJ2EEManagement                          false

-r--   DebugJAXPDebugLevel                          0

-r--   DebugJAXPDebugName                           null

-r--   DebugJAXPIncludeClass                        false

-r--   DebugJAXPIncludeLocation                     false

-r--   DebugJAXPIncludeName                         false

-r--   DebugJAXPIncludeTime                         false

-r--   DebugJAXPOutputStream                        null

-r--   DebugJAXPUseShortClass                       false

-r--   DebugJDBCConn                                false

-r--   DebugJDBCDriverLogging                       false

-r--   DebugJDBCInternal                            false

-r--   DebugJDBCONS                                 false

-r--   DebugJDBCRAC                                 false

-r--   DebugJDBCREPLAY                              false

-r--   DebugJDBCRMI                                 false

-r--   DebugJDBCSQL                                 true

-r--   DebugJDBCUCP                                 false

-r--   DebugJMSAME                                  false

-r--   DebugJMSBackEnd                              false

-r--   DebugJMSBoot                                 false

-r--   DebugJMSCDS                                  false

-r--   DebugJMSCommon                               false

-r--   DebugJMSConfig                               false

-r--   DebugJMSDispatcher                           false

-r--   DebugJMSDistTopic                            false

-r--   DebugJMSDurableSubscribers                   false

-r--   DebugJMSFrontEnd                             false

-r--   DebugJMSJDBCScavengeOnFlush                  false

-r--   DebugJMSLocking                              false

-r--   DebugJMSMessagePath                          false

-r--   DebugJMSModule                               false

-r--   DebugJMSPauseResume                          false

-r--   DebugJMSSAF                                  false

-r--   DebugJMSStore                                false

-r--   DebugJMST3Server                             false

-r--   DebugJMSWrappers                             false

-r--   DebugJMSXA                                   false

-r--   DebugJMX                                     false

-r--   DebugJMXCompatibility                        false

-r--   DebugJMXCore                                 false

-r--   DebugJMXDomain                               false

-r--   DebugJMXEdit                                 false

-r--   DebugJMXRuntime                              false

-r--   DebugJNDI                                    false

-r--   DebugJNDIFactories                           false

-r--   DebugJNDIResolution                          false

-r--   DebugJTA2PC                                  false

-r--   DebugJTA2PCStackTrace                        false

-r--   DebugJTAAPI                                  false

-r--   DebugJTAGateway                              false

-r--   DebugJTAGatewayStackTrace                    false

-r--   DebugJTAHealth                               false

-r--   DebugJTAJDBC                                 false

-r--   DebugJTALLR                                  false

-r--   DebugJTALifecycle                            false

-r--   DebugJTAMigration                            false

-r--   DebugJTANaming                               false

-r--   DebugJTANamingStackTrace                     false

-r--   DebugJTANonXA                                false

-r--   DebugJTAPropagate                            false

-r--   DebugJTARMI                                  false

-r--   DebugJTARecovery                             false

-r--   DebugJTARecoveryStackTrace                   false

-r--   DebugJTAResourceHealth                       false

-r--   DebugJTAResourceName                         null

-r--   DebugJTATLOG                                 false

-r--   DebugJTATransactionName                      null

-r--   DebugJTAXA                                   true

-r--   DebugJTAXAStackTrace                         false

-r--   DebugJpaDataCache                            false

-r--   DebugJpaEnhance                              false

-r--   DebugJpaJdbcJdbc                             false

-r--   DebugJpaJdbcSchema                           false

-r--   DebugJpaJdbcSql                              false

-r--   DebugJpaManage                               false

-r--   DebugJpaMetaData                             false

-r--   DebugJpaProfile                              false

-r--   DebugJpaQuery                                false

-r--   DebugJpaRuntime                              false

-r--   DebugJpaTool                                 false

-r--   DebugLeaderElection                          false

-r--   DebugLibraries                               false

-r--   DebugLoadBalancing                           false

-r--   DebugLoggingConfiguration                    false

-r--   DebugManagementServicesResource              false

-r--   DebugMaskCriterias                           null

-r--   DebugMessaging                               false

-r--   DebugMessagingBridgeRuntime                  false

-r--   DebugMessagingBridgeRuntimeVerbose           false

-r--   DebugMessagingBridgeStartup                  false

-r--   DebugMessagingKernel                         false

-r--   DebugMessagingKernelBoot                     false

-r--   DebugMuxer                                   false

-r--   DebugMuxerConnection                         false

-r--   DebugMuxerDetail                             false

-r--   DebugMuxerException                          false

-r--   DebugMuxerTimeout                            false

-r--   DebugPathSvc                                 false

-r--   DebugPathSvcVerbose                          false

-r--   DebugRA                                      false

-r--   DebugRAClassloader                           false

-r--   DebugRAConnEvents                            false

-r--   DebugRAConnections                           false

-r--   DebugRADeployment                            false

-r--   DebugRALifecycle                             false

-r--   DebugRALocalOut                              false

-r--   DebugRAParsing                               false

-r--   DebugRAPoolVerbose                           false

-r--   DebugRAPooling                               false

-r--   DebugRASecurityCtx                           false

-r--   DebugRAWork                                  false

-r--   DebugRAWorkEvents                            false

-r--   DebugRAXAin                                  false

-r--   DebugRAXAout                                 false

-r--   DebugRAXAwork                                false

-r--   DebugRC4                                     false

-r--   DebugRSA                                     false

-r--   DebugReplication                             false

-r--   DebugReplicationDetails                      false

-r--   DebugRouting                                 false

-r--   DebugSAFAdmin                                false

-r--   DebugSAFLifeCycle                            false

-r--   DebugSAFManager                              false

-r--   DebugSAFMessagePath                          false

-r--   DebugSAFReceivingAgent                       false

-r--   DebugSAFSendingAgent                         false

-r--   DebugSAFStore                                false

-r--   DebugSAFTransport                            false

-r--   DebugSAFVerbose                              false

-r--   DebugSNMPAgent                               false

-r--   DebugSNMPExtensionProvider                   false

-r--   DebugSNMPProtocolTCP                         false

-r--   DebugSNMPToolkit                             false

-r--   DebugSSL                                     false

-r--   DebugScaContainer                            false

-r--   DebugSecurityAdjudicator                     false

-r--   DebugSecurityAtn                             false

-r--   DebugSecurityAtz                             false

-r--   DebugSecurityAuditor                         false

-r--   DebugSecurityCertPath                        false

-r--   DebugSecurityCredMap                         false

-r--   DebugSecurityEEngine                         false

-r--   DebugSecurityEncryptionService               false

-r--   DebugSecurityJACC                            false

-r--   DebugSecurityJACCNonPolicy                   false

-r--   DebugSecurityJACCPolicy                      false

-r--   DebugSecurityKeyStore                        false

-r--   DebugSecurityPasswordPolicy                  false

-r--   DebugSecurityPredicate                       false

-r--   DebugSecurityRealm                           false

-r--   DebugSecurityRoleMap                         false

-r--   DebugSecuritySAML2Atn                        false

-r--   DebugSecuritySAML2CredMap                    false

-r--   DebugSecuritySAML2Lib                        false

-r--   DebugSecuritySAML2Service                    false

-r--   DebugSecuritySAMLAtn                         false

-r--   DebugSecuritySAMLCredMap                     false

-r--   DebugSecuritySAMLLib                         false

-r--   DebugSecuritySAMLService                     false

-r--   DebugSecuritySSL                             false

-r--   DebugSecuritySSLEaten                        false

-r--   DebugSecurityService                         false

-r--   DebugSecurityUserLockout                     false

-r--   DebugSelfTuning                              false

-r--   DebugServerLifeCycle                         false

-r--   DebugServerMigration                         false

-r--   DebugServerStartStatistics                   false

-r--   DebugStoreAdmin                              false

-r--   DebugStoreIOLogical                          false

-r--   DebugStoreIOLogicalBoot                      false

-r--   DebugStoreIOPhysical                         false

-r--   DebugStoreIOPhysicalVerbose                  false

-r--   DebugStoreXA                                 false

-r--   DebugStoreXAVerbose                          false

-r--   DebugTunnelingConnection                     false

-r--   DebugTunnelingConnectionTimeout              false

-r--   DebugURLResolution                           false

-r--   DebugWANReplicationDetails                   false

-r--   DebugWTCConfig                               false

-r--   DebugWTCCorbaEx                              false

-r--   DebugWTCGwtEx                                false

-r--   DebugWTCJatmiEx                              false

-r--   DebugWTCTDomPdu                              false

-r--   DebugWTCUData                                false

-r--   DebugWTCtBridgeEx                            false

-r--   DebugWebAppIdentityAssertion                 false

-r--   DebugWebAppModule                            false

-r--   DebugWebAppSecurity                          false

-r--   DebugWorkContext                             false

-r--   DebugXMLEntityCacheDebugLevel                0

-r--   DebugXMLEntityCacheDebugName                 null

-r--   DebugXMLEntityCacheIncludeClass              false

-r--   DebugXMLEntityCacheIncludeLocation           false

-r--   DebugXMLEntityCacheIncludeName               false

-r--   DebugXMLEntityCacheIncludeTime               false

-r--   DebugXMLEntityCacheOutputStream              null

-r--   DebugXMLEntityCacheUseShortClass             false

-r--   DebugXMLRegistryDebugLevel                   0

-r--   DebugXMLRegistryDebugName                    null

-r--   DebugXMLRegistryIncludeClass                 false

-r--   DebugXMLRegistryIncludeLocation              false

-r--   DebugXMLRegistryIncludeName                  false

-r--   DebugXMLRegistryIncludeTime                  false

-r--   DebugXMLRegistryOutputStream                 null

-r--   DebugXMLRegistryUseShortClass                false

-r--   DefaultStore                                 false

-r--   DiagnosticContextDebugMode                   Off

-r--   ForceGCEachDGCPeriod                         false

-r--   ListenThreadDebug                            false

-r--   LogDGCStatistics                             false

-r--   MasterDeployer                               false

-r--   Name                                         AdminServer

-r--   Notes                                        null

-r--   RedefiningClassLoader                        false

-r--   Server                                       null

-r--   SlaveDeployer                                false

-r--   Type                                         ServerDebug

-r--   WebModule                                    false

-r-x   freezeCurrentValue                           Void : String(attributeName)

-r-x   isSet                                        Boolean : String(propertyName)

-r-x   unSet                                        Void : String(propertyName)

wls:/soa_domain/serverConfig/Servers/AdminServer/ServerDebug/AdminServer>

Tags: Publish
July 07, 2018 at 10:22AM
Open in Evernote

Selecting Tracing for a composite using wlst command's

Selecting Tracing for a composite using wlst command's

Selecting Tracing for a composite using wlst command's

======================================================

From Admin Server do the following

Replace HelloWorld with your composite name i.e "HelloWorld" and traceId "HelloWorld-trace1"

with your values

Start WLST with <MIDDLEWARE_HOME>/oracle_common/common/bin/wlst.cmd

connect('weblogic','Welcome1','t3://localhost:7001')

startTracing(attrName="composite_name",attrValue="HelloWorld",level="TRACE:32",traceId="HelloWorld-trace1")

After testing the composites , stop the tracing , by issuing the command

stopTracing(traceId="HelloWorld-trace1")

Reference :

https://docs.oracle.com/cd/E15586_01/web.1111/e13813/custom_logging.htm#CEGIJECA

How to Use Selective Tracing for SOA (Doc ID 1367174.1)

Tags: Publish
July 04, 2018 at 04:34PM
Open in Evernote

How to recreate the purge scripts in SOA using instantclient sql

How to recreate the purge scripts in SOA using instantclient sql

Purge scripts should be available in the directory ,

$ORACLE_HOME/soa/common/sql/soainfra/sql/oracle/122100/soa_purge12/soa_purge_scripts.sql

Download the folloiwng files

http://download.oracle.com/otn/linux/instantclient/122010/instantclient-basic-linux.x64-12.2.0.1.0.zip

http://download.oracle.com/otn/linux/instantclient/122010/instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

extract them

unzip -d . instantclient-basic-linux.x64-12.2.0.1.0.zip

unzip -d . instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

cd /home/oracle/instantclient_12_2

export PATH=/home/oracle/instantclient_12_2:$PATH

export LD_LIBRARY_PATH=/home/oracle/instantclient_12_2

now test the connectivity , for example

sqlplus DEV_SOAINFRA/Welcome1@host-name:1521/orcl

after this

cd $ORACLE_HOME/soa/common/sql/soainfra/sql/oracle/122100/soa_purge12/soa_purge_scripts.sql

run the script

@soa_purge_scripts.sql

Then try with the following ,

begin

soa.DELETE_INSTANCES_IN_PARALLEL(

MIN_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),

MAX_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),

BATCH_SIZE=>1000,

MAX_RUNTIME=>20,

RETENTION_PERIOD=>to_timestamp('2016-01-01','YYYY-MM-DD'),

DOP=>4,

MAX_COUNT=>1000,

PURGE_PARTITIONED_COMPONENT=>false,

sql_trace=>false);

end;

and also

begin

soa.DELETE_INSTANCES(

MIN_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),

MAX_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),

BATCH_SIZE=>1000,

MAX_RUNTIME=>20,

RETENTION_PERIOD=>to_timestamp('2016-01-01','YYYY-MM-DD'),

PURGE_PARTITIONED_COMPONENT=>false,

sql_trace=>false);

end;

Check the Note 

Steps to compile SOA Purge 12.2.1.1 with an explanation (Doc ID 2171885.1)

Tags: Publish
June 04, 2018 at 04:22PM
Open in Evernote

How to Invoke "Refresh Alarm Table" from a Java Code

How to Invoke "Refresh Alarm Table" from a Java Code

In a BPEL process there are some use cases where a Wait activity or the onAlarm branch of a Pick activity is needed. An example for an onAlarm branch is a timeout mechanism for an asynchronous call. These activities save the instance in the dehydration store for a defined time. To wake up the waiting instances there is a quartz scheduler job running in the weblogic and check the expiration date in the dehydration store. For the case the dehydration store  is not available, the scheduler retry to call the database. The retry settings can be found in the advanced BPEL properties in the System MBean Browser. 

The properties are named ExpirationMaxRetry and ExpirationRetryDelay. When the retry failed the data sets won’t be cleaned from the dehydration store.

The suggestion to clean this is to click on the Button “Refresh Alarm Table” in the Recovery console. But it is unpleasent to click the button periodically, so the wish appear to do this automated. There is a way for an automatically clean.

This Note explains how to achieve this functionality using DB Update stament

https://blogs.oracle.com/soacommunity/start-expired-instances-in-waiting-state-for-oracle-soa-suite-by-reinhold-becker

http://www.esentri.com/blog/2014/10/13/start-expired-instances-waiting-state-soa-suite/

This also can be achieved using the following java code 

++

package hello2;

import java.util.Hashtable;

import java.util.List;

import javax.naming.Context;

import oracle.soa.management.facade.ComponentInstance;

import oracle.soa.management.facade.CompositeInstance;

import oracle.soa.management.facade.Locator;

import oracle.soa.management.facade.LocatorFactory;

import oracle.soa.management.util.ComponentInstanceFilter;

import oracle.soa.management.util.CompositeInstanceFilter;

import org.w3c.dom.Document;

import org.w3c.dom.Node;

public class Class1 {

   public Class1() {

       super();

   }

   //Invoke this method with the composite instance id

      public static void main(String[] args) {

          String compositeName = "GetOpenCompositeInstances";

          Hashtable jndiProps = new Hashtable();

          String inputPayload = "";

          try {

              jndiProps.put(Context.PROVIDER_URL, "t3://xxxxx:7001");

              jndiProps.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");

              jndiProps.put(Context.SECURITY_PRINCIPAL, "weblogic");

              jndiProps.put(Context.SECURITY_CREDENTIALS, "Welcome1");

              jndiProps.put("dedicated.connection", "true");

              Locator locator = LocatorFactory.createLocator(jndiProps);

             

              Object[] params = new Object[] {};

              ((oracle.soa.management.internal.facade.Locator)locator).executeServiceEngineMethod("bpel", "refreshAlarmTable", params);

              System.out.println(" Executed refreshAlarmTable");

          } catch (Exception e) {

              e.printStackTrace();

          }

      }

}

+++

Create a new project from JDev and add the following the libraries 

SOA Designtime

SOA Runtime

BPEL Runtime

Mediator Runtime

MDS Runtime

BC4J Service Runtime

WebLogic 12.1 Remote-Client

JRF Client

to run the java code Use the classpath as ,

c:\jdk1.8.0_152\bin\java.exe -server -classpath C:\myjdevwork\jdev12212\mywork\Application1\.adf;C:\myjdevwork\jdev12212\mywork\Application1\Hello2\SOA\SCA-INF\classes;D:\bpm12212\soa\plugins\jdeveloper\extensions\oracle.sca.modeler.jar;D:\bpm12212\soa\soa\modules\oracle.soa.fabric_11.1.1\fabric-runtime.jar;D:\bpm12212\soa\soa\modules\oracle.soa.fabric_11.1.1\tracking-api.jar;D:\bpm12212\soa\soa\modules\oracle.soa.fabric_11.1.1\tracking-core.jar;D:\bpm12212\soa\soa\modules\oracle.soa.fabric_11.1.1\edn.jar;D:\bpm12212\soa\soa\modules\oracle.soa.mgmt_11.1.1\soa-infra-mgmt.jar;D:\bpm12212\oracle_common\modules\com.oracle.webservices.fabric-common-api.jar;D:\bpm12212\soa\soa\modules\oracle.soa.bpel_11.1.1\orabpel.jar;D:\bpm12212\soa\soa\modules\oracle.soa.mediator_11.1.1\mediator_client.jar;D:\bpm12212\oracle_common\modules\oracle.mds\mdsrt.jar;D:\bpm12212\oracle_common\modules\oracle.adf.model\adfbcsvc.jar;D:\bpm12212\oracle_common\modules\oracle.adf.model\adfbcsvc-share.jar;D:\bpm12212\oracle_common\modules\commonj.sdo.backward.jar;D:\bpm12212\oracle_common\modules\commonj.sdo.jar;D:\bpm12212\oracle_common\modules\oracle.toplink\eclipselink.jar;D:\bpm12212\oracle_common\modules\com.oracle.webservices.fmw.wsclient-impl.jar;D:\bpm12212\oracle_common\modules\com.oracle.webservices.fmw.jrf-ws-api.jar;D:\bpm12212\oracle_common\modules\com.oracle.webservices.fmw.web-common-schemas-impl.jar;D:\bpm12212\wlserver\server\lib\weblogic.jar;D:\bpm12212\oracle_common\modules\clients\com.oracle.webservices.fmw.client.jar hello2.Class1

Executed refreshAlarmTable

To check the log entries enable the following logger , oracle.soa.bpel.engine.agents

Log entries after enabling the oracle.soa.bpel.engine.agents to TRACE:32

[2018-05-14T13:51:27.595+05:30] [AdminServer] [TRACE] [] [oracle.soa.bpel.engine.agents] [tid: [ACTIVE].ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: dfe28b74-fb6c-46fa-95cb-c692ece98681-03646479,0] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: ExpirationAgent] [SRC_METHOD: recover] Attempting to find expirable work items

[2018-05-14T13:51:27.597+05:30] [AdminServer] [TRACE] [] [oracle.soa.bpel.engine.agents] [tid: [ACTIVE].ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: dfe28b74-fb6c-46fa-95cb-c692ece98681-03646479,0] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: ExpirationAgent] [SRC_METHOD: recover] Cluster date time retrieved from DB is 2018-05-14 13:51:27.0

[2018-05-14T13:51:27.597+05:30] [AdminServer] [TRACE] [] [oracle.soa.bpel.engine.agents] [tid: [ACTIVE].ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: dfe28b74-fb6c-46fa-95cb-c692ece98681-03646479,0] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: ExpirationAgent] [SRC_METHOD: recover] Found NO expirable work items for bpel engine.

Tags: Publish
May 16, 2018 at 12:05PM
Open in Evernote

Change the MFT Source and Target Password's using WLST

Change the MFT Source and Target Password's using WLST

Use the WLST command , exportDeployedArtifact

The following example exports a SOURCE artifact called order-file-src with the label soa_mft-2012-12-07 22:24:09.383 to /export/order-file-src.zip.

exportDeployedArtifact('SOURCE', 'order-file-src', 'soa_mft-2012-12-07 22:24:09.383', '/export/order-file-src.zip

To find out the label Go to MFT Console and click on monitoring TAB and select Source and Target check boxes and click on MFT Source

and select the source and click on the button show details 

Make a note of the string soa_mft-2018-04-04 12:11:29.265 and use this to export the source file 

for example , 

cd  $ORACLE_HOME/mft/common/bin

connect('weblogic', 'Welcome1', 't3://localhost:7001')

exportDeployedArtifact('SOURCE', 'source-name', 'soa_mft-2018-04-04 12:11:29.265', '/tmp/test1.zip')

Open the file mft\source\so_e801f00a-a2d8-4ded-a4fa-36c657c2d61b.xml

Locate the password , make a note of it , for example in this case it is 

pw_key_dabf076a-306a-4cb2-85f5-d165df53bd84

Now use the wlst command 

cd  $ORACLE_HOME/oracle_common/common/bin

connect('weblogic', 'Welcome1', 't3://localhost:7001')

updateCred(map="mftapp", key="pw_key_dabf076a-306a-4cb2-85f5-d165df53bd84", user="pw_key_dabf076a-306a-4cb2-85f5-d165df53bd84", password="password-new" , desc="Updated by ...")

Tags: Publish
April 25, 2018 at 02:13PM
Open in Evernote

Rhino Java Script Version in SOA

Rhino Java Script Version in SOA

org.mozilla.javascript.Context.class file 

and look for the method ,

public String getImplementationVersion()

  {

    return "Rhino 1.5 release 2 2001 07 27";

  }

  

For other version run the command 

java -jar d:\bpm12213\osb\lib\external\js.jar

This will give the o/p as 

Rhino 1.7 release 4 2012 06 18

Or open the file d:\bpm12213\osb\lib\external\js.jar

and check the manifest.mf file 

This has the information as 

++

Manifest-Version: 1.0

Ant-Version: Apache Ant 1.8.2

Created-By: 1.7.0_04-b20 (Oracle Corporation)

Main-Class: org.mozilla.javascript.tools.shell.Main

Implementation-Version: 1.7R4

Implementation-Title: Mozilla Rhino 1.7R4

Implementation-Vendor: Mozilla Foundation

Implementation-URL: http://www.mozilla.org/rhino

++

In SOA 12.2.1.3 these are the places where the java script library is being used

--> org/mozilla/javascript/ScriptRuntime.class in d:\bpm12213\osb\lib\external\js.jar

--> org/mozilla/javascript/ScriptRuntime.class in d:\bpm12213\soa\soa\applications\frevvo.ear\APP-INF\lib\hibernate-jpa-2.0-api-1.0.1.Final.jar\frevvo.war\WEB-INF\lib\rhino-1.7R4.jar

--> org/mozilla/javascript/ScriptRuntime.class in d:\bpm12213\soa\soa\connectors\SocketAdapter.rar\js-engine.jar\js.jar

--> org/mozilla/javascript/ScriptRuntime.class  in d:\bpm12213\wlserver\modules\com.bea.javascript.jar

Tags: Publish
April 24, 2018 at 05:05PM
Open in Evernote