199 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
IBM Business Process Manager 8.5.7 Cumulative Fix 2017-06 Released
Fri, Jun 23rd 2017 27
IBM Redbook - Governing Operational Decisions in an Enterprise Scalable Way
Wed, Jun 21st 2017 44
NullPointerException seen when using BPMConfig.sh to create a second IBM BPM Deployment Environment
Mon, Jun 19th 2017 50
IBM BPM and DB2 and Permissions and Users and So On and So Forth :-)
Mon, Jun 19th 2017 39
WebSphere Liberty - Single Sign-On
Sat, Jun 17th 2017 112
WebSphere Liberty Collectives - Deploying Node.JS using REST
Fri, Jun 16th 2017 48
Node.JS - Unknown SSL protocol error
Fri, Jun 16th 2017 45
Top 10
WebSphere Liberty - Single Sign-On
Sat, Jun 17th 2017 112
Transport Layer Security (TLS) 1.2 and SoapUI
Fri, Jun 12th 2015 53
IBM Rational Software Architect Designer on macOS - java.lang.RuntimeException: No application id has been found.
Fri, Jun 16th 2017 50
NullPointerException seen when using BPMConfig.sh to create a second IBM BPM Deployment Environment
Mon, Jun 19th 2017 50
WebSphere Liberty Collectives - Deploying Node.JS using REST
Fri, Jun 16th 2017 48
Node.JS - Unknown SSL protocol error
Fri, Jun 16th 2017 45
IBM HTTP Server / IBM WebSphere Plugin - Using Transport Layer (TLS) 1.2
Tue, Nov 10th 2015 44
IBM Redbook - Governing Operational Decisions in an Enterprise Scalable Way
Wed, Jun 21st 2017 44
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 43
IBM BPM and DB2 and Permissions and Users and So On and So Forth :-)
Mon, Jun 19th 2017 39


IBM BPM - Tinkering with Process Instance Cleanup - aka BPMProcessInstancesPurge
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

Following my previous post: -


I've had a play with the BPMProcessInstancesPurge command.

It's WAY more powerful, and definitely a case of Caveat Emptor, Your Mileage May Vary and Here Be Dragons.

This command allows one to remove *ALL* instances from a Process Server, regardless of status.

But it does require one to Use The Force.

Now read on ….

Validate status of instances - active, completed, terminated, suspended

db2 "select inst.EXECUTION_STATUS, count(*) as total from LSW_BPD_INSTANCE inst, LSW_TASK task where task.BPD_INSTANCE_ID = inst.BPD_INSTANCE_ID group by inst.EXECUTION_STATUS"

EXECUTION_STATUS TOTAL      

              1.           1
              2.           1
              4.           1
              6.           1

Clear ALL Terminated instances

print AdminTask.BPMProcessInstancesPurge('[-instanceStatus TERMINATED]')

The BPMProcessInstancesPurge command passed.

Check results in AppCluster logs

tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log

[04/01/17 17:04:25:612 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesPurge Entering
[04/01/17 17:04:25:616 GMT] 000001eb Log           I   PAL: About to delete the process instances matching the filter criteria: 
Statuses: [4]
Maximum duration: 0
Transaction slice: 10

[04/01/17 17:04:25:616 GMT] 000001eb Log           I   PAL: Number of qualifying instances before deletion: 1
[04/01/17 17:04:25:687 GMT] 000001eb Log           I   PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 17:04:25:687 GMT] 000001eb Log           I   PAL: Every instance has been deleted. The deletion job finished.
[04/01/17 17:04:25:691 GMT] 000001eb Log           I   PAL: Successfully deleted the process instances matching the filter criteria: 
Statuses: [4]
Maximum duration: 0
Transaction slice: 10

[04/01/17 17:04:25:692 GMT] 000001eb Log           I   PAL: Number of qualifying instances before deletion: 1
[04/01/17 17:04:25:695 GMT] 000001eb Log           I   PAL: Number of qualifying instances after deletion: 0
[04/01/17 17:04:25:698 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesPurge Exiting
[04/01/17 17:04:34:110 GMT] 00000124 ProcessIndexB I   CWLLG0757I: The purge process was completed successfully. 1 tasks and 1 instances were successfully removed from the search index.

Validate that there are no longer any Terminated instances ( status code 4 )

db2 "select inst.EXECUTION_STATUS, count(*) as total from LSW_BPD_INSTANCE inst, LSW_TASK task where task.BPD_INSTANCE_ID = inst.BPD_INSTANCE_ID group by inst.EXECUTION_STATUS"

EXECUTION_STATUS TOTAL      

              1.           1
              2.           1
              6.           1

Attempt to clear ALL instances

print AdminTask.BPMProcessInstancesPurge('[-instanceStatus ALL]')

The BPMProcessInstancesPurge command passed.
wsadmin>print AdminTask.BPMProcessInstancesPurge('[-instanceStatus ALL]')
WASX7015E: Exception running command: "AdminTask.BPMProcessInstancesPurge('[-instanceStatus ALL]')"; exception information:
java.lang.Exception: java.lang.Exception: The instance status 'ALL' is a non end state. The '-force' flag is mandatory to delete instances in this state.

Attempt to clear ALL instances - use the force

print AdminTask.BPMProcessInstancesPurge('[-instanceStatus ALL -force]')

The BPMProcessInstancesPurge command passed.

Check results in AppCluster logs

tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log

[04/01/17 17:08:42:748 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesPurge Entering
[04/01/17 17:08:42:753 GMT] 000001ec Log           I   PAL: About to delete the process instances matching the filter criteria: 
Statuses: [2, 4, 3, 1, 5, 6]
Maximum duration: 0
Transaction slice: 10

[04/01/17 17:08:42:754 GMT] 000001ec Log           I   PAL: Number of qualifying instances before deletion: 3
[04/01/17 17:08:42:963 GMT] 000001ec Log           I   PAL: A deletion job is running. Progress: Deleted 3 instance(s).
[04/01/17 17:08:42:963 GMT] 000001ec Log           I   PAL: Every instance has been deleted. The deletion job finished.
[04/01/17 17:08:42:970 GMT] 000001ec Log           I   PAL: Successfully deleted the process instances matching the filter criteria: 
Statuses: [2, 4, 3, 1, 5, 6]
Maximum duration: 0
Transaction slice: 10

[04/01/17 17:08:42:970 GMT] 000001ec Log           I   PAL: Number of qualifying instances before deletion: 3
[04/01/17 17:08:42:975 GMT] 000001ec Log           I   PAL: Number of qualifying instances after deletion: 0
[04/01/17 17:08:42:978 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesPurge Exiting
[04/01/17 17:08:49:143 GMT] 00000124 ProcessIndexB I   CWLLG0757I: The purge process was completed successfully. 3 tasks and 3 instances were successfully removed from the search index.

Validate the database

db2 "select inst.EXECUTION_STATUS, count(*) as total from LSW_BPD_INSTANCE inst, LSW_TASK task where task.BPD_INSTANCE_ID = inst.BPD_INSTANCE_ID group by inst.EXECUTION_STATUS"

EXECUTION_STATUS TOTAL      

  0 record(s) selected.

It goes without saying that the force should be used with caution - with great power, comes great responsibility ( just because you can, doesn't mean you should )


---------------------
http://portal2portal.blogspot.com/2017/01/ibm-bpm-tinkering-with-process-instance_4.html
Jan 04, 2017
7 hits



Recent Blog Posts
27
IBM Business Process Manager 8.5.7 Cumulative Fix 2017-06 Released
Fri, Jun 23rd 2017 6:28p   Dave Hay
What's New in IBM Business Process Manager V8.5.7 Cumulative Fix 2017.06Update to IBM BPM V8.5.7 Cumulative Fix 2017.06 to experience all of the highlights, such as these added abilities and improvements:IBM BPM on Cloud • Reduce overhead and downtime for client applications by using the new service accounts for password administrationIBM BPM • Develop user interfaces more easily • Get usage metrics by using IBM Cloud Product Insights • Determine artifact usage in the web IBM Process De
44
IBM Redbook - Governing Operational Decisions in an Enterprise Scalable Way
Wed, Jun 21st 2017 9:25a   Dave Hay
Penned, in part, by two of my immediate colleagues in the IBM Professional Cloud Services here in the UK :-) This IBM® Redbooks® publication introduces operational decision governance and describes in details how to implement it using the IBM Operational Decision Manager (ODM) platform. ODM allows businesses to automate and manage day to day operational decisions. It provides an integrated repository and management components for line-of-business, subject-matter experts to directly participate
50
NullPointerException seen when using BPMConfig.sh to create a second IBM BPM Deployment Environment
Mon, Jun 19th 2017 3:02p   Dave Hay
I saw this earlier whilst attempting to create a second Deployment Environment, of type Process Server, within an existing BPM Advanced 8.5.7 cell, which already had a Process Centre Deployment Environment therein: -/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -create -de /mnt/ResponseFiles/Advanced-PS-ThreeClusters-DB2.propertiesLogging to file /opt/ibm/WebSphere/AppServer/logs/config/BPMConfig_20170619-153221.log.The 'BPMConfig.sh -create -de /mnt/ResponseFiles/Advanced-PS-ThreeClusters-DB2.
39
IBM BPM and DB2 and Permissions and Users and So On and So Forth :-)
Mon, Jun 19th 2017 2:57p   Dave Hay
I've seen this exception: -com.ibm.db2.jcc.am.SqlSyntaxErrorException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2USER1.LSW_SYSTEM_SCHEMA, DRIVER=4.18.60before, as per these posts: -IBM BPM to DB2 - You WILL respect my authorityIBM BPM 8.5.0.1 - Booting the BootstrapHowever, this time it's subtly different.gives us an SQL exception code, which DB2 can debug for us: -db2 ? SQL0204which returns: -SQL0204N "" is an undefined name.Note t
112
WebSphere Liberty - Single Sign-On
Sat, Jun 17th 2017 5:31a   Dave Hay
This is on my reading list: -Cross-domain single sign-on using SAML 2.0 with WebSphere Liberty, Part 1 - Configure a service provider-initiated SSO with identity propagationCross-domain single sign-on using SAML 2.0 with WebSphere Liberty, Part 2 - Set up a secure hybrid cloud environment with IBM BluemixCross-domain single sign-on using SAML 2.0 with WebSphere Liberty, Part 3 - Integrate Microsoft Windows authentication by using SPNEGOMust get around to it Source: https://en.wiktionary.org/wiki
48
WebSphere Liberty Collectives - Deploying Node.JS using REST
Fri, Jun 16th 2017 8:19p   Dave Hay
This is definitely a Work-In-Progress …..Using this as input: -Deploying Node.js servers using deployment REST APIsI started by using a REST client within Chrome ( called Restlet ): -with this JSON as input: -{ "rule":"Node.js Server Rule", "hosts":["wlpn.uk.ibm.com"], "variables": [ { "name":"applicationPackage","value":"helloworld-1.0.0.tgz" }, { "name":"serverName", "value":"Server1" }, { "name":"clusterName", "value":"Cluster1" }, { "name"
45
Node.JS - Unknown SSL protocol error
Fri, Jun 16th 2017 3:34p   Dave Hay
So I've been tinkering with HTTPS servers in Node.JS, and was following this thread: -How to create an https server?which has one create a public/private key pair, and then generate a self-signed certificate.Having done this, I created a simple server: -server.js var http = require('https');var fs = require('fs'); var options = { key: fs.readFileSync('key.pem'), cert: fs.readFileSync('cert.pem')};var server = http.createServer(options, function(req, res) { res.writeHead(200); re
50
IBM Rational Software Architect Designer on macOS - java.lang.RuntimeException: No application id has been found.
Fri, Jun 16th 2017 2:46p   Dave Hay
I hit this today: -having installed IBM Rational Software Architect Designer 9.6 on my Mac.Looking at the log: -cat /Users/davidhay/.eclipse/org.eclipse.platform_4.6.1_443275834_macosx_cocoa_x86_64/configuration/1497623600763.log.!SESSION Fri Jun 16 15:33:20 BST 2017 ------------------------------------------!ENTRY org.eclipse.equinox.launcher 4 0 2017-06-16 15:33:20.767!MESSAGE Could not find extension: com.ibm.cds!SESSION 2017-06-16 15:33:20.690 -----------------------------------------------e
37
WebSphere Liberty Profile - 17.0.0.2 is out ....
Wed, Jun 14th 2017 5:47a   Dave Hay
From this: -Recommended updates for WebSphere Application Serverwe have this: -17.0.0.2: WebSphere Application Server Liberty 17.0.0.2Readme for IBM WebSphere Application Server Liberty 17.0.0.2Fix list for IBM WebSphere Application Server Liberty - Continous DeliveryDownloaded it, installed it, using it ( for a Collective Controller to manage NodeJS runtimes !! )So #LifeIsGood
14
After Atom on Centos, Atom on Ubuntu is soooo much easier
Thu, Jun 8th 2017 9:45a   Dave Hay
After yesterday's post: - Using Atom Text Editor on CentOS Linux doing it on Ubuntu is SOO much easier: - Download it wget https://atom.io/download/deb Install it sudo dpkg --install /home/hayd/Downloads/atom-amd64.deb Fix up the dependencies ( including Git ) sudo apt-get -f install Use it atom Job's a good 'un




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition