This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Change this variable for your purge date value. In this case the Bpel purge purge all instance older than &purgeDays days | |
DECLARE purgeDays number := 72; | |
--TroubleShooting BPEL Purge | |
--Not purged instances | |
SELECT | |
ci.ecid AS ecid, | |
decode(ci.state,0, 'STATE_INITIATED(NOK)',1,'STATE_OPEN_RUNNING(OK)',2,'STATE_OPEN_SUSPENDED(OK)',3,'STATE_OPEN_FAULTED(OK)',4,'STATE_CLOSED_PENDING_CANCEL(OK)',5,'STATE_CLOSED_COMPLETED(NOK)',6,'STATE_CLOSED_FAULTED(NOK)', 7, 'STATE_CLOSED_CANCELLED(NOK)', 8, 'STATE_CLOSED_ABORTED(NOK)', 9, 'STATE_CLOSED_STALE(NOK)', 10, 'STATE_CLOSED_ROLLED_BACK(NOK)') AS state, | |
ci.composite_name AS composite_name, | |
ci.composite_revision AS composite_revision, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------- | |
-- MIT License | |
-- Author Cedric Leruth | |
-- | |
--Permission is hereby granted, free of charge, to any person obtaining a copy | |
--of this software and associated documentation files (the "Software"), to deal | |
--in the Software without restriction, including without limitation the rights | |
--to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
--copies of the Software, and to permit persons to whom the Software is | |
--furnished to do so, subject to the following conditions: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Key BPEL Indicator (usefull to build a monitoring system with EM or Kibana, etc) | |
-- Replace soa_user with your own Oracle SOA Database Schema user | |
--Indentify bpel errors in the last 10 minutes | |
select ci.title, ci.ecid, cui.composite_name, cui.composite_revision, ci.created_time, | |
(SELECT count(1) FROM soa_user.REFERENCE_INSTANCE ri WHERE ri.ecid = ci.ecid and error_message is not null) + | |
(select count(1) from soa_user.bpel_faults_vw bf where bf.ecid = ci.ecid) as nbfaults | |
from soa_user.composite_instance ci | |
inner join soa_user.cube_instance cui on cui.ecid = ci.ecid | |
where (select count(1) from soa_user.bpel_faults_vw bf where bf.ecid = ci.ecid) !=0 | |
and ci.created_time >= sysdate - 10/(24*60); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--fault-bindings.xml--> | |
<?xml version="1.0" encoding="UTF-8"?> | |
<faultPolicyBindings version="2.0.2" | |
xmlns="http://schemas.oracle.com/bpel/faultpolicy" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> | |
<composite faultPolicy="Faults_Policy"/> | |
</faultPolicyBindings> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Maven package Java | |
# Build your Java project | |
# Add steps that analyze code, save build artifacts, deploy, and more: | |
# https://docs.microsoft.com/azure/devops/pipelines/languages/java | |
trigger: | |
- master | |
variables: | |
# Agent VM image name |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Your First need to install wordpress cli as describe : https://wp-cli.org/ | |
#Try running | |
wp help | |
#and if you get an error run the following : | |
curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar | |
php wp-cli.phar --info | |
#Should display system informations | |
#If there is no errors make it executable and move it to path : | |
chmod +x wp-cli.phar |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Include AWS php sdk that you can download here : https://docs.aws.amazon.com/sdk-for-php/v3/developer-guide/getting-started_installation.html | |
require 'aws/aws-autoloader.php'; | |
use Aws\S3\S3Client; | |
use Aws\S3\Exception\S3Exception; | |
// Initialize your S3 connection. | |
// To generate your YOUR_IAM_USER_KEY and YOUR_IAM_USER_SECRET create and Aws IAM user with the S3FullAccess Role | |
// to do so follow : https://docs.aws.amazon.com/IAM/latest/UserGuide/id_users_create.html |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//There is multiple way to programmatically set a value of a view attribute in Oracle ADF : | |
// 1. The JSF way using the highly recommended JSFUtils.java library function : | |
/** | |
* Method for setting a new object into a JSF managed bean | |
* Note: will fail silently if the supplied object does | |
* not match the type of the managed bean. | |
* @param expression EL expression | |
* @param newValue new value to set |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public static ViewObjectImpl getViewObjectFromIterator(String nomIterator) { | |
ViewObjectImpl returnVO = null; | |
DCBindingContainer dcb = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry(); | |
if (dcb != null) { | |
DCIteratorBinding iter = dcb.findIteratorBinding(nomIterator); | |
if (iter != null) { | |
returnVO = (ViewObjectImpl)iter.getViewObject(); | |
} | |
} | |
return returnVO; |