199 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 16
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 11
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 9
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 11
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 10
Top 10
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 74
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 59
Transport Layer Security (TLS) 1.2 and SoapUI
Fri, Jun 12th 2015 47
Hmmm, macOS Sierra and XQuartz and X11
Thu, Oct 27th 2016 37
IBM HTTP Server / IBM WebSphere Plugin - Using Transport Layer (TLS) 1.2
Tue, Nov 10th 2015 36
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 33
java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version; class=com/davehay/EmployeeServlet, offset=6
Sat, Nov 8th 2014 31
WebSphere Application Server - Transaction Logs - getting it wrong
Sun, Jul 16th 2017 26
WAS - How to clear the WebSphere class caches
Mon, Feb 10th 2014 25
"SECJ0371W: Validation of the LTPA token failed because the token expired with the following info..." - much more useful with WAS 8.5
Wed, Feb 12th 2014 25


ilog.rules.teamserver.model.IlrConnectException Caused by: java.lang.NullPointerException
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

As one of my many spinning threads, I've been tinkering with the migration of an IBM Operational Decision Manager (ODM) environment from version 8.0 ( circa 2012 ) to version 8.9 ( circa 2017 ).

In part, this involves running some SQL scripts to migrate the old data to the new environment.

This is especially relevant for the Decision Center, which is the Rules authoring environment, aka the Source Code Management (SCM) system-of-record.

The Decision Center, also known as the Team Server ( reflecting the product's heritage as iLog JRules ) or Rule Team Server or RTS, is based upon a database.

Therefore, the first step is to BACKUP the existing database ( RTSDB, in my case ) from the old/source system.

One benefit of the migration is that it's effectively side-by-side, meaning that you leave the old source system alone, and build a new, parallel environment into which the data ( Rules etc. ) is restored.

In my case, I'm using IBM DB2, but other databases are available.

The process is documented here: -


and here: -


and involves running a pair of Ant scripts against the existing database schema ( in my case, that's db2user1 ) resulting in a pair of SQL scripts that can then be executed against a new database schema ( in my case, that's db2user2 ) to migrate the roles AND data from one to t'other.

I was quite obviously doing something wrong, as I kept seeing exceptions such as: -

ilog.rules.teamserver.model.IlrConnectException
Caused by: java.lang.NullPointerException


in the Decision Center logs post migration.

It was, however, a PEBKAC - I was obviously doing it wrong.

Once I changed my approach: -

Restore backup of RTSDB - as db2inst1

db2 restore database RTSDB from /tmp

Connect as the instance owner - as db2inst1

db2 connect to RTSDB user db2inst1 using passw0rd

Grant the new schema - db2user2 - rights to the database - as db2inst1

db2 grant dbadm on database to user db2user2

Terminate the DB2 session - as db2inst1

db2 terminate

Connect as the new schema - as db2inst1

db2 connect to RTSDB user db2user2 using passw0rd

Run the provided script to create the necessary ODM tables, indices etc. - as db2inst1

db2 -tvf ~/rule-team-server.sql

- For the record, this SQL script is generated when one first logs into the Decision Center, so I just kept a copy :-)

Terminate the DB2 session - as db2inst1

db2 terminate

Start the Decision Centre cluster - as wasadmin

AdminControl.invoke('WebSphere:name=DecisionCenterCluster,process=dmgr,platform=common,node=Dmgr,version=8.5.5.11,type=Cluster,mbeanIdentifier=DecisionCenterCluster,cell=odmCell01,spec=1.0', 'start')

Log into the Decision Centre - as wasadmin


Follow the prompts to complete basic setup - extensions, locale ( I'm using en_GB as I'm a Brit ) etc. *BUT* avoid executing the generated SQL ( this has already been done ), as per this: -


At this stage, we've got a clean Decision Center database, ready to receive BUT with no roles or data migrated from the old environment: -


Set variables - as wasadmin

export ANT_HOME=/opt/ibm/ODM89/shared/tools/ant
export PATH=$PATH:/opt/ibm/ODM89/shared/tools/ant/bin
export JAVA_HOME=/opt/ibm/ODM89/jdk/jre


Run the Ant scripts to extract the roles and data for the old db2user1 schema - as wasadmin

cd /opt/ibm/ODM89/teamserver/bin

ant -DoldDatabaseSchemaName=db2user1 -Dserver.url=https://odm.uk.ibm.com:9443/teamserver -DrtsAdmin.login=wasadmin -DrtsAdmin.password=passw0rd -DoutputFile=/tmp/migrate_roles.sql gen-migration80-role

ant -DoldDatabaseSchemaName=db2user1 -Dserver.url=https://odm.uk.ibm.com:9443/teamserver -DdatasourceName=jdbc/ilogDataSource -DrtsAdmin.login=wasadmin -DrtsAdmin.password=passw0rd -DoutputFile=/tmp/migrate_data.sql gen-migration80-script

This results in a pair of SQL scripts: -

-rw-r--r-- 1 wasadmin wasadmins 79746 Jul 16 16:25 /tmp/migrate_data.sql
-rw-r--r-- 1 wasadmin wasadmins  9552 Jul 16 16:24 /tmp/migrate_roles.sql


Connect as the new schema - as db2inst1

db2 connect to RTSDB user db2user2 using passw0rd

Execute migration scripts - as db2inst1

db2 -tvf /tmp/migrate_roles.sql
db2 -tvf /tmp/migrate_data.sql


Terminate the DB2 session - as db2inst1

db2 terminate

Log into the Decision Centre - as wasadmin


C'est voila, we have a NEW ODM 8.9 Decision Centre with the project that was previously created on the OLD ODM 8.0 Decision Centre: -





---------------------
http://portal2portal.blogspot.com/2017/07/ilogrulesteamservermodelilrconnectexcep.html
Jul 16, 2017
19 hits



Recent Blog Posts
16
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 1:45p   Dave Hay
I'm creating a set of scripts to automate a number of common tasks, including setting up Web SSO: - /mnt/Scripts/enableSSO.jy AdminTask.configureSingleSignon(['-enable', 'true', '-requiresSSL', 'true', '-domainName', 'uk.ibm.com']) # Save and Sync AdminConfig.save() AdminNodeManagement.syncActiveNodes() /mnt/Scripts/exportLTPAkeys.jyAdminTask.exportLTPAKeys('[-ltpaKeyFile file:/mnt/Misc/bpm855.uk.ibm.com.ltpa -password passw0rd ]') /mnt/Scripts/importLTPAkeys.jy AdminTask.config
11
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 12:58p   Dave Hay
As per my previous posts, I'm setting up an IBM BPM Process Federation Server (PFS), which runs on WebSphere Liberty Profile (WLP).I'm now going back through the setup from scratch, to see (a) what I learned and (b) whether I can repeat my success :-)Looking at the WLP configuration file - server.xml - I'd noticed reference to a pair of variables: -… …and was trying to work out what, if anything, the difference is, given that they actually point to a the same darn file.This helped:
11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 10:32a   Dave Hay
I'm working through this process: -Migrating IBM BPM to the same version on new hardwarespecifically testing the process of "lifting and shifting" an IBM BPM Deployment Environment from one VM to another.This is, in part, to help a client move a running environment from Red Hat Enterprise Linux v5 to v7.So I've got a working environment on a VM, and I've exported the BPM Deployment Environment thus: -/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -de De1 -profile Dmgr01 -outputDir /t
9
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 6:34a   Dave Hay
So I started seeing this: -Unable to Connect to BoxBox Sync is unable to connect to Box.Verify that you are connected to the Internet and restart Box Sync.If you continue to see this message, contact your administrator to verify if it is a network issue.If it is not a network issue, visit the Box Support website to submit a ticket.yesterday, on my Mac.No matter how many times I tried stopping/starting the Box Sync app, it flatly refused to connect.This whilst I was working away on Box via my bro
11
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 4:07p   Dave Hay
So, following these two posts: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1IBM BPM and the Process Federation Server - A Voyage of Discovery #2once I'd got PFS set up and (mostly) working, I did some testing.However, I kept seeing errors such as this: -when I logged into the BPM 8.5.7 Process Portal ( if you remember, this is the new go-to Portal for everything, including the 8.5.5 instances ) via this URL: -https://bpm857.uk.ibm.com:8443/ProcessPortalTalking to some of
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 3:55p   Dave Hay
So, following on from my earlier post: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1it took me a while to realise that PFS is NOT a UI in its own right; it merely aggregates processes from other BPMs into one single Process Portal.However, YOU need to provide that Process Portal :-)So, in my limited test rig here, I have four VMs: -BPM 8.5.5 This is my source environment, from which I am migrating, which has running instances which I need to drain down over timeBPM 8.5.7
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 3:40p   Dave Hay
So I've spent the past week getting to grips with Process Federation Server (PFS), and I think I'm pretty close now. In essence, PFS is a capability that's been around for a few years, and allows a business to provide an aggregation layer across multiple different Process Server environments.Whilst this is often pertinent in the context of a migration or upgrade, perhaps where an older version of BPM is being maintained, to allow existing process instances to drain down, whilst new work is be
11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
Tue, Jul 25th 2017 2:39p   Dave Hay
I missed this on Friday: -8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12Fix list for IBM WebSphere Application Server V8.5Time to get downloading ….
74
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 3:56p   Dave Hay
I saw this: -The test connection operation failed for data source BPM Business Process Choreographer data source on server nodeagent at node Node1 with the following exception: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002. View JVM logs for further details.whilst testing JDBC data sources configured to connect to a newly-minted Oracle 12c database.I checked the Oracle box to ensure that the listener was
59
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 2:58p   Dave Hay
Having installed Oracle 12c ( 12.2.0.1.0 ) today, I was somewhat concerned when I tried to start my database: -sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:04:56 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/initorcl.ora'SQL> quitDisconnectedI checked the offen




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