198 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
More on Elasticsearch, Logstash and Kibana (ELK)
Fri, Oct 20th 2017 41
Zipping and Tarring on macOS - with added funkiness
Thu, Oct 19th 2017 35
IBM BPM and Elasticsearch - with added TLS
Thu, Oct 19th 2017 40
Apple Watch - go, no go, go
Mon, Oct 16th 2017 135
IBM Cloud Private - My first foray
Mon, Oct 16th 2017 111
Ubuntu - Software Updater and the Insufficient Disk Space
Mon, Oct 16th 2017 71
Git and Jenkins - Learning Resources
Fri, Oct 13th 2017 35
Top 10
Apple Watch - go, no go, go
Mon, Oct 16th 2017 135
IBM Cloud Private - My first foray
Mon, Oct 16th 2017 111
Ubuntu - Software Updater and the Insufficient Disk Space
Mon, Oct 16th 2017 71
Transport Layer Security (TLS) 1.2 and SoapUI
Fri, Jun 12th 2015 48
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 43
More on Elasticsearch, Logstash and Kibana (ELK)
Fri, Oct 20th 2017 41
IBM BPM and Elasticsearch - with added TLS
Thu, Oct 19th 2017 40
Hmmm, macOS Sierra and XQuartz and X11
Thu, Oct 27th 2016 38
Jenkins to Git - SSH says "No"
Fri, Oct 13th 2017 35
Git and Jenkins - Learning Resources
Fri, Oct 13th 2017 35


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
6 hits



Recent Blog Posts
41
More on Elasticsearch, Logstash and Kibana (ELK)
Fri, Oct 20th 2017 10:28a   Dave Hay
Following earlier posts: -Tinkering with Elasticsearch and Kibana - on Docker, of courseFurther stories of a tinkerer - this time it's IBM BPM, Apache Kibana and ElasticsearchIBM BPM and Elasticsearch - with added TLSI've had a brief play with a new ( to me ) Docker image, ELK: -sebp/elkCollect, search and visualise log data with Elasticsearch, Logstash, and Kibana.using this documentation: -Elasticsearch, Logstash, Kibana (ELK) Docker image documentationThis time around, I built it using Dock
35
Zipping and Tarring on macOS - with added funkiness
Thu, Oct 19th 2017 5:41p   Dave Hay
So I had a specific requirement yesterday - I wanted to extract three specific files from a ZIP file.This is what I had: -unzip -l certificate-bundle.zipArchive: certificate-bundle.zip Length Date Time Name--------- ---------- ----- ---- 0 10-19-2017 16:58 ca/ 1310 10-19-2017 16:58 ca/ca.crt 1679 10-19-2017 16:58 ca/ca.key 0 10-19-2017 16:58 node1/ 1379 10-19-2017 16:58 node1/node1.crt 1679 10-19-2017 16:58 node1/node1.key---------
40
IBM BPM and Elasticsearch - with added TLS
Thu, Oct 19th 2017 5:29p   Dave Hay
Following this: -Tinkering with Elasticsearch and Kibana - on Docker, of courseFurther stories of a tinkerer - this time it's IBM BPM, Apache Kibana and ElasticsearchI've been tinkering further with Elasticsearch on Docker, establishing a TLS connection between it and IBM BPM.Here's my notes: -Pull Imagedocker pull docker.elastic.co/elasticsearch/elasticsearch:5.6.3Start containeres=`docker run -d -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node" docker.elastic.co/elasticsearch/elas
135
Apple Watch - go, no go, go
Mon, Oct 16th 2017 3:29p   Dave Hay
So I had a weird experience last evening, and not in a good way.For no apparent reason, this was my Apple Watch: -and this: -I have no earthly idea what happened.So, being a true nerd, and a big fan of The IT Crowd, I decided to ( all together now ) TURN IT OFF AND ON AGAIN ….Obviously I couldn't read the display, what with it being all garbled n' all, so I just hit the big button on the right-hand side, below the digital crown and chose the appropriate gibberish - it was the one in red, so
111
IBM Cloud Private - My first foray
Mon, Oct 16th 2017 10:37a   Dave Hay
So this week, along with many other things, I'm starting to get to grips with the newly announced IBM Cloud Private: - IBM brings the power of cloud behind the enterprise firewall I'm running on Ubuntu Linux: - lsb_release -a No LSB modules are available. Distributor ID:    Ubuntu Description:    Ubuntu 16.04.3 LTS Release:    16.04 Codename:    xenial so started by installing the pre-requisites of VirtualBox and Vagrant: - sudo apt-get install virtualbox su
71
Ubuntu - Software Updater and the Insufficient Disk Space
Mon, Oct 16th 2017 8:13a   Dave Hay
So I'm trying to update Ubuntu 16.0.4.3 LTS using Software Updater, but couldn't get past this: -      Now I have LOADS of disk space: - df -kmh Filesystem                   Size  Used Avail Use% Mounted on udev                          16G     0   16G   0% /dev tmpfs                        3.2G  9.4M  3.2G   1% /run /dev/mapper/ubuntu--vg-root  2.7T  346G  2.2T  14% / tmpfs               
35
Git and Jenkins - Learning Resources
Fri, Oct 13th 2017 10:35a   Dave Hay
This is what I've been reading and using over the past few days: -git-server-dockerHow to Setup Git Repository and Credentials for Jenkins Jobs.ssh/id_rsa failed: permission deniedMy simply Git Cheatsheet4.2 Git on the Server - Getting Git on a Server2.5 Git Basics - Working with Remotes'Your branch is ahead of 'origin/master' by 1 commit' on explicit push [duplicate]Unable to push to repositorycannot push into git repositoryJenkins TutorialIBM WebSphere Liberty ConfigurationDeploying with
35
Jenkins to Git - SSH says "No"
Fri, Oct 13th 2017 10:28a   Dave Hay
As per my earlier post: -Learning Times - Or Git being a bit of a GitI'm on a voyage of discovery with Jenkins and Git.Whilst trying to plumb onto into t'other, I was hitting a blocker.To recap, I have Jenkins installed on my MacBook, running locally, and I have Git running on a Docker container on a remote Mac.Therefore, I'm connecting to the remote Git repository using SSH rather than, say, HTTPS or a local file-system.This works OK for me using Git commands such as: -git clone ssh://git@19
34
Learning Times - Or Git being a bit of a Git
Fri, Oct 13th 2017 9:56a   Dave Hay
I'm on a bit of a voyage of discovery this week, having previously been tinkering with Elasticsearch and Kibana a few days back: -Further stories of a tinkerer - this time it's IBM BPM, Apache Kibana and ElasticsearchNow I'm playing with Jenkins and Git, the latter of which is running on Docker, with the intention of automating the push of Java code to WebSphere Liberty Profile, also running in Docker.I also intend to get to grips with Maven at the same time, what's not to like ?Anyway, back
30
IBM HTTP Server - Checking Personal Certificates
Wed, Oct 11th 2017 3:54p   Dave Hay
Whilst on the subject of IBM HTTP Server (IHS), as per an earlier post: -IBM HTTP Server - Tinkering with CMS Keystore PasswordsI was "auditing" the SSL certificate that I'm using for IHS, specifically the signature algorithm.So I have a single certificate in the key store: -/opt/IBM/HTTPServer/bin/gskcapicmd -cert -list -db /opt/IBM/HTTPServer/APIC/ssl/keystore.kdb -pw passw0rdCertificates found* default, - personal, ! trusted, # secret key*- wlpn.uk.ibm.comwhich I validated as follows: -/op




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