Monday, 28 July 2014

More fun with BPM 8.5.5.0 and DB Bootstrapping

If you see this: -

[28/07/14 15:13:24:354 BST] 00000072 wle           E   CWLLG2229E: An exception occurred in an EJB call.  Error: null
                                 java.lang.NullPointerException
        at com.lombardisoftware.server.ejb.persistence.dao.TWAclEntryDAO.findByFilter(TWAclEntryDAO.java:73)


[28/07/14 15:13:24:382 BST] 00000072 wle_servlet   E   CWLLG0011E: Caches did not initialize because of an unexpected exception.  Error: com.lombardisoftware.client.delegate.BusinessDelegateException: java.lang.NullPointerException

Caused by: com.lombardisoftware.core.TeamWorksException: java.lang.NullPointerException


when attempting to log into Process Center on a newly-minted BPM 8.5.5 environment, then you've probably forgotten to run the bootstrap process: -

/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/bootstrapProcessServerData.sh -clusterName AppCluster

Can you say "Doh" ? I did ...

Problems with DBMS_LOCK on Oracle with IBM BPM Advanced 8.5.5.0

If you see this: -

[28/07/14 15:10:54:461 BST] 00000097 XmlBeanDefini I org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[28/07/14 15:10:54:703 BST] 00000097 SQLErrorCodes I org.springframework.jdbc.support.SQLErrorCodesFactory <init> SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
[28/07/14 15:10:54:731 BST] 00000097 wle_perf_load I   Error locking system table: ConnectionCallback; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_LOCK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

                                 org.springframework.jdbc.BadSqlGrammarException: ConnectionCallback; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_LOCK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


during the startup of an IBM BPM 8.5.5.0 environment, when using Oracle, then you'll need to add an additional DB grant

GRANT execute ON DBMS_LOCK TO pdwuser;

as per this IBM Technote: -


which was written for BPM 7.5 and 8.0, but still appears to be relevant.

<Caveat>
Of course, for all DB-related issues, check check check this with your DBA and, if needed, raise a PMR with IBM Support to validate that this is the RIGHT approach for your environment.
</Caveat>

Thursday, 24 July 2014

How to run IBM Integration Bus v9 on SoftLayer Servers

This from my IBM Hursley colleague, Simon Holdsworth: -


In this article I will describe the steps I took to get IBM Integration Bus Version 9 installed and running on SoftLayer servers.  You might want to do this as part of establishing an off-premise cloud environment that includes integration capability, or for managing a pool of integration servers for development and testing.

This article shows how to set up a SoftLayer-hosted server and install and run software on it - in this case IBM Integration Bus - either through a traditional product install, or by using a Hypervisor Edition.  You can get everything working without leaving your desk, plugging in a cable or hitting a switch.

How to automate IBM Integration Bus deployments using IBM UrbanCode Deploy and Chef

 How to automate IBM Integration Bus deployments using IBM UrbanCode Deploy and Chef 

IBM UrbanCode Deploy orchestrates and automates the deployment of applications, middleware configurations, and database changes into development, test, and production environments. You can use IBM UrbanCode Deploy with IBM Integration Bus to automate the deployment of integration applications and configure the resources they depend on. You can also use IBM UrbanCode Deploy to automate the installation and configuration of the IBM Integration Bus runtime.

IBM UrbanCode Deploy - automating application deployments through your environments

IBM UrbanCode Deploy

IBM UrbanCode Deploy is a tool for automating application deployments through your environments. It is designed to facilitate rapid feedback and continuous delivery in agile development while providing the audit trails, versioning and approvals needed in production.

UrbanCode Deploy provides

• Automated, consistent deployments and rollbacks of applications
• Orchestration of changes across servers, tiers and components
• Configuration and security differences across environments
• Clear visibility: what is deployed where and who changed what
• Integrated with middleware, provisioning and service virtualization

https://developer.ibm.com/urbancode/wp-content/themes/projectnext-urbancode/images/products/deploy/deploy-infographic.png

IBM PureApplication System - Using IPAS to Isolate Virtualized Environments

Demonstrating workload isolation in IBM PureApplication System

Learn how to create two or more application runtime environments in IBM® PureApplication™ System that are highly isolated from each other so that the workloads in one environment cannot interfere with those in another. This article shows how to create them and demonstrates that they are indeed isolated.

Source: http://www.ibm.com/developerworks/cloud/library/cl-ps-aim1302-workisolation/index.html

Managing application runtime environments in IBM PureApplication System

In IBM® PureApplication™ System, deployers install applications into runtime environments that administrators define by using cloud groups and environment profiles. As an administrator setting up a PureApplication System, what are the cloud groups and environment profiles that you will need to consider and create?



Wednesday, 23 July 2014

Faster disaster recovery in IBM Business Process Manager

Faster disaster recovery in IBM Business Process Manager

Implementing a multiple data center approach to improve recovery time

This article describes an infrastructure topology for IBM® Business Process Manager that includes elements that reside in distinct data centers that may be geographically separated from each other. Such a topology can be useful in achieving disaster recovery objectives in certain circumstances, especially when recovery times faster those offered by traditional approaches are desired. Additionally, the strategy described in this paper uses Oracle®'s Data Base File System (DBFS) to enable the database manager to control replication of the WebSphere® transaction and compensation logs, as well as traditional IBM BPM database content. This content is part of the IBM Business Process Management Journal.