193 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
IBM WebSphere Liberty App Accelerator
Mon, Mar 27th 2017 47
IBM BPM Advanced 8.5.7 - "Unable to establish a connection to the server" seen when attempting to access Health Management
Sun, Mar 26th 2017 46
IBM BPM 8.5.7 - ADMN0022E seen when attempting to manage Deployment Environment
Sun, Mar 26th 2017 51
SoapUI hanging on macOS - Not any longer
Sun, Mar 26th 2017 75
JVMCFRE003 bad major version; class=org/apache/derby/jdbc/EmbeddedConnectionPoolDataSource40, offset=6
Wed, Mar 15th 2017 34
WebSphere Application Server - DNS, you can't fool it - or can you ?
Mon, Mar 13th 2017 8
Weirdness - The database is not consistent with the BPM Product version
Sun, Mar 12th 2017 11
Top 10
SoapUI hanging on macOS - Not any longer
Sun, Mar 26th 2017 75
IBM BPM 8.5.7 - ADMN0022E seen when attempting to manage Deployment Environment
Sun, Mar 26th 2017 51
IBM WebSphere Liberty App Accelerator
Mon, Mar 27th 2017 47
IBM BPM Advanced 8.5.7 - "Unable to establish a connection to the server" seen when attempting to access Health Management
Sun, Mar 26th 2017 46
JVMCFRE003 bad major version; class=org/apache/derby/jdbc/EmbeddedConnectionPoolDataSource40, offset=6
Wed, Mar 15th 2017 34
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 33
Hmmmm, HTTP404 and SRVE0190E seen with IBM HTTP Server and WebSphere Application Server
Fri, Nov 14th 2014 32
Securing the Database - IBM DB2 10.5 and Transport Layer Security 1.2
Wed, Jun 3rd 2015 29
IBM HTTP Server / IBM WebSphere Plugin - Using Transport Layer (TLS) 1.2
Tue, Nov 10th 2015 29
WebSphere Application Server 8.5.54 and IBM BPM Advanced 8.5.5.0 - Available commands
Sat, Jan 24th 2015 27


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
47
IBM WebSphere Liberty App Accelerator
Mon, Mar 27th 2017 9:14p   Dave Hay
I heard about this at InterConnect last week: -Liberty app acceleratorEasily start building apps for WebSphereLiberty, a Java EE application serverConfigure WebSphere Liberty with a set of selected technologies. Then download the project as a zip file.https://liberty-app-accelerator.wasdev.developer.ibm.com/start/
46
IBM BPM Advanced 8.5.7 - "Unable to establish a connection to the server" seen when attempting to access Health Management
Sun, Mar 26th 2017 11:33p   Dave Hay
I saw this: -within the BPM Advanced 8.5.7 Process Admin console.What was interesting was that nothing obvious was popping up within the WAS logs ( for the Node Agent, SupCluster, AppCluster etc. ).This was the URL that I was using to access Process Admin: -https://bpm857.uk.ibm.com:8443/ProcessAdmin/ProcessAdmin/com.lombardisoftware.processadmin.ProcessAdmin/ProcessAdmin.jspI'm not sure what made me think this, but I then realised that the hostname - bpm857.uk.ibm.com - was actually an alias t
51
IBM BPM 8.5.7 - ADMN0022E seen when attempting to manage Deployment Environment
Sun, Mar 26th 2017 11:26p   Dave Hay
I saw this: -Caused by: javax.management.JMRuntimeException: ADMN0022E: Access isdenied for the resolve operation on ConfigService MBean because of insufficient or empty credentials.when attempting to stop a Deployment Environment using IBM BPM Advanced 8.5.7.Specifically, I was logged into the WebSphere Application Server (WAS) Integrated Solutions Console, as an administrator with FULL WAS authority ( access to ALL roles ), and clicked Stop against a running Deployment Environment: -This start
75
SoapUI hanging on macOS - Not any longer
Sun, Mar 26th 2017 11:17p   Dave Hay
I saw an issue with SoapUI 5.3.0 hanging on my Mac this morning.The hang would occur as soon as I'd chosen NOT to send feedback to SmartBear and to allow Eclipse to access the internet …..It wasn't immediately obvious why … so I jumped onto Google, and found this: -SoapUI Pro 5.1.2 hangs on Mac OS X 10.8.5which talked me through updating: -/Applications/SoapUI-5.3.0.app/Contents/java/app/bin/soapui.shand: -/Applications/SoapUI-5.3.0.app/Contents/vmoptions.txteffectively moving: --Dsoapui.b
34
JVMCFRE003 bad major version; class=org/apache/derby/jdbc/EmbeddedConnectionPoolDataSource40, offset=6
Wed, Mar 15th 2017 9:37p   Dave Hay
I saw this today: -[ERROR ] An error has occurred in trying to access data source 'jdbc/ilogDataSource': Could not lookup datasource named 'jdbc/ilogDataSource'. Check that the data source exists on the application server or contact your administrator.An error has occurred in trying to access data source 'jdbc/ilogDataSource': Could not lookup datasource named 'jdbc/ilogDataSource'. Check that the data source exists on the application server or contact your administrator.[E
8
WebSphere Application Server - DNS, you can't fool it - or can you ?
Mon, Mar 13th 2017 7:12a   Dave Hay
I saw this: -[3/12/17 19:55:21:158 UTC] 00000001 LogAdapter E DCSV9403E: Received an illegal configuration argument. Parameter MulticastInterface, value: 9.20.65.171. Exception is java.lang.Exception: Network Interface 9.20.65.171 was not found in local machine network interface list. Make sure that the NetworkInterface property is properly configured! at com.ibm.rmm.mtl.transmitter.Config.(Config.java:238)while attempting to start a WebSphere Application Serve (WAS) Deployment Manager ( as
11
Weirdness - The database is not consistent with the BPM Product version
Sun, Mar 12th 2017 7:52p   Dave Hay
So we saw this issue last week: -[3/9/17 7:06:35:804 UTC] 00000001 WsServerImpl E WSVR0009E: Error occurred during startupcom.ibm.ws.exception.RuntimeError: The database [jndi = jdbc/PerformanceDB] version [8.5.7.201612] is not consistent with the BPM Product version [8.5.7.0], please ensure the database is updated successfully before starting server.during the build of a new IBM Business Process Manager (BPM) Advanced 8.5.7 Deployment Environment with an Oracle 12c database.The problem appea
8
Scripting in Python and Jython with added OS commands
Sat, Mar 11th 2017 7:42p   Dave Hay
I was writing a generic ( use anywhere ) script to add a BPM URL to my IBM BPM Advanced 8.5.7 environment.For me, all of the components ( IBM HTTP Server, WebSphere Plugin and WebSphere Application Server / BPM ) are on the same VM.For the record, I'm running the VM on OpenStack.Therefore, I wanted a script that would get the hostname of the VM on which IHS/WAS is running.This served as source: -How can I use Python to get the system hostname?and this was my test script: - foo.jy import socketh
11
CTGSK3046W - IBM HTTP Server - Certificates and Permissions
Fri, Mar 10th 2017 7:44p   Dave Hay
I saw this: -CTGSK3046W The key file "/tmp/ad2012.cer" could not be imported.whilst trying to add a CA Signer certificate to a keystore using IBM HTTP Server: -/opt/ibm/HTTPServer/bin/gskcapicmd -cert -add -file /tmp/ad2012.cer -db /opt/ibm/HTTPServer/BPM/ssl/keystore.kdb -stashedHaving checked and double-checked my command, I then tried to use openSSL to validate the certificate: -openssl x509 -inform der -in /tmp/ad2012.cer -text -nooutError opening Certificate /tmp/ad2012.cer140581419276192
9
CloudFoundry Enablement
Fri, Mar 10th 2017 12:05p   Dave Hay
Shared by one of my team: -Overview: Cloud Foundry BasicsJoin us for a hands-on training workshop to learn about deploying and managing applications on Cloud Foundry. We will give an overview of Cloud Foundry and how it works, including specifics relating to services, buildpacks, and architecture. We will also look at how to effectively work with Cloud Foundry in your organization.This training is targeted at people with little or no Cloud Foundry experience but some experience delivering web-ba




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