Moving IBM BPM Document Store into a separate DB schema

The task – move IBM BPM Document Store into a separate DB schema. This problem has two solutions:

1.    You can create properties file for the command BPMConfig and use it. But, if the environment has already been created, we cannot use BPMConfig because it does not permit to change all the parameters of Deployment Environment. We need to delete our Deployment Environment before.

2.     If you have already installed a new Deployment Environment, you can use this solution.

The disclaimer:
The solution is not recommended by IBM, it is hack and any actions you make on own risk!
The solution does not move the content of IBM BPM Document Store, it only creates a new one in the separate schema.

I prepared this solution for Oracle DB, but, I think, it can be used with some changes for other RDBMS.

Red Hat 6. I get the error during the installation of Installation Manager: _cairo_operator_bounded_by_source

I get the error during the installation of Installation Manager (I installed IBM BPM 8.5.6):

root@server /ibm/IM64 # ./install
java: cairo-misc.c:380: _cairo_operator_bounded_by_source: Assertion `NOT_REACHED' failed.
JVMDUMP039I Processing dump event "abort", detail "" at 2015/10/30 21:03:07 - please wait.
JVMDUMP032I JVM requested System dump using '/ibm/IM64/core.20151030.210307.33634.0001.dmp' in response to an event
JVMPORT030W /proc/sys/kernel/core_pattern setting "|/usr/libexec/abrt-hook-ccpp %s %c %p %u %g %t e" specifies that the core dump is to be piped to an external program.  Attempting to rename either core or core.33694.

JVMDUMP010I System dump written to /ibm/IM64/core.20151030.210307.33634.0001.dmp
JVMDUMP032I JVM requested Java dump using '/ibm/IM64/javacore.20151030.210307.33634.0002.txt' in response to an event
JVMDUMP010I Java dump written to /ibm/IM64/javacore.20151030.210307.33634.0002.txt
JVMDUMP032I JVM requested Snap dump using '/ibm/IM64/Snap.20151030.210307.33634.0003.trc' in response to an event
JVMDUMP010I Snap dump written to /ibm/IM64/Snap.20151030.210307.33634.0003.trc
JVMDUMP013I Processed dump event "abort", detail "".

During update of IBM BPM environment to 8.5.6 I get the error: CWPKI0663E: Key store file ${CONFIG_ROOT}/cells/CellName/bwl-trust.p12 did not verify. The update process is interrupted. What to do?

During update of IBM BPM environment to 8.5.6 I get the error

runConfigActions script execution failed. Exit code: Exception caught while waiting for runConfigActions script to complete: /opt/bpm855/profiles/Dmgr01/bin/runConfigActions.sh


In BPMConfig.log I see the error:

2015-03-15 10:48.23.990 com.ibm.bpm.config.BPMConfig.main(): CWMCB0046E: The 'createKeyStore' command failed: CWPKI0663E: Key store file ${CONFIG_ROOT}/cells/BPMCell01/bwl-trust.p12 did not verify, make sure the file or keyring exists, check key store type and password.

The update process is interrupted. What to do?

I've installed ODM 8.7 using multiplatform distributive and there is not DS Events profile in PMT. What to do?

If you installed ODM 8.7 using multiplatform distributive you can discover after its installation the absence of Decision Server Events profile in Profile Management Tool. What to do?

How to extract ODM 8.7 Multiplatform files?

I've downloaded ODM 8.7 Advanced files. Every part (DC, Rules etc) contains several files which look like DS_RULES_MPF__N_OF_5__IMR_V8.7_ML.0N How to use them?

IBM BPM: java.lang.OutOfMemoryError: PermGen space during bootstrapProcessServerData

During bootstrapProcessServerData step in IBM BPM installation you can get the message:

java.lang.OutOfMemoryError: PermGen space

I got it on Solaris SPARC.

SSL does not work in a BPM 8.5.5 configuration with on-demand router

I created BPM 8.5.5 environment, transformed it into a dynamic cluster, created on demand router (ODR), and published its plugin-cfg.xml on my web server as it is written in IBM Knowledge Center.
I can open BPM portals, ODR works, but only through http protocol. https does not work. What to do?

How can I change the hostname in an already configured Business Process Manager environment? The way of real geek.

Have You Tried Turning It Off And On Again?

"The IT Crowd"

 
Undoubtedly, IBM support are good guys but they have not enough a fantasy, a flight of mind, an imagination. They are limited by official guides and reglaments.
Not so long ago they created a new portal named dwAnswers, and now they are inventing questions and answering themself on them.
Yesterday I saw a good question and the typical answer of IBM support. Let's look at it:

How to install a stand-alone installation in IBM BPM 8.5/8.5.5 (Part 2)

I have already forgotten about this subject but I needed to install UTE for BPM 8.5.5
The standard installation Integration Designer was not suitable for me because it uses DB2.
I need Oracle.

Connections 5 Metrics. UDA-SQL-0432 Unable to locate the gateway "cogudaor" and others

At last I've installed Metrics for Connections 5. It was a real Kamasutra. Cognos is an awful product for installation. I remember my attempts of installing BAM. But it was only easy walk.
IBM created a new feature named Cognos Wizard for Connections. In my mind (or their may be) it must facilitate a process of installation. In fact I spent a lot of time for hopeless attempts.
But now I can give several advices for future brave hearts :)

It's impossible to map some group to role in Connections 5

Now I'm dealing with new Connections version 5.

During its installation I had a issue with mapping the necessary group to role using ISC.
Granting access to global metrics
But I had a trouble. When I press the link Save in ISC for storing the configuration - I get white frame and the configuration does not change.

WebSphere Portal 8. EJPFD0050W: An exception occurred while checking installation history, no information about interim fixes and fix packs is available!

After installing WebSphere Portal 8 I've got the message: 

[7/28/14 13:30:00:488 MSK] 00000019 ProductServic W com.ibm.wps.services.product.ProductServiceImpl init EJPFD0050W: An exception occurred while checking installation history, no information about interim fixes and fix packs is available!

"syntax error at line 6: `binDir=$' unexpected" during creating of ODM clustered environment

I've created ODM 8 clustered environment using this command (on Solaris OS):

-bash-3.2$ /ibm/odm80/profiles/DManagerODM/bin/configureDSCluster.sh -dmgrAdminUsername wasadmin -dmgrAdminPassword password-clusterPropertiesFile /ibm/odm80/profiles/DManagerODM/bin/rules/configureDSCluster.properties -dmgrHostName dmanager -dmgrPort 8882 -targetNodeName ODMCellNode01

and get this error:

/ibm/odm80/profiles/DManagerODM/bin/configureDSCluster.sh: syntax error at line 6: `binDir=#39; unexpected

DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506 during bootstrapProcesServerData in IBM IBM 8.5

During an installation of IBM BPM 8.5 on the step of bootstrapProcesServerData you can get roughly the message:

How to use SMF for creating a service for start and stop Oracle DB on Solaris 10

So I often became use Solaris for our environments, I was interested in controlling of our services, particularly Oracle DB. I know well how to do this in Linux but there my experience was weak.

I've found the good article by Max Lam (Thanks!) here
But i have some troubles during this way so I want to share my experience.

How to change WAS profile name

I don't know where it can be used :) but for any case.

I have (for example) an WAS instance and some profiles in it and I want to change ProcCtr01 profile name to PCenter.

How to look at the settings of Process Center in 8.5 Express Process Server standalone

There is some information about looking and changing these settings here.
But it is for clustered environment. 

http://pic.dhe.ibm.com/infocenter/dmndhelp/v8r5m0/index.jsp?topic=%2Fcom.ibm.wbpm.imuc.doc%2Ftopics%2Ftconnect_to_pctr.html

How to install a stand-alone installation in IBM BPM 8.5 (Part 2 - Process Server).

We will go the same way. All the steps are identically.

http://bpmadmin.blogspot.com/2013/12/how-to-install-stand-alone-installation.html

The difference in properties file only. We only added the settings of our Process Center and changed settings of DB, hosts etc.

How to install a stand-alone installation in IBM BPM 8.5 (Part 1)

I use the environment Linux - Oracle in the main, but, I think, the same way in others environments.

Response file for deploying standalone ESB 7.5 on Solaris

It is possible to use this file for any supported OS but Solaris does not support PMT GUI.