Connections 6 migration observations

I am sure that lots of you have installed or started migrations to Connections 6 by now .. but I have found a couple of gotchas across the installs and updates that I have managed so far.

I am listing them here for sanities sake as I know when we google an error – this blog will show up πŸ™‚

 

Connections 6 itself

 

Generally this was a nice smooth install and all worked as it should in a clean 6 environment

On testing a migration though I found issues when trying to migrate some of the DBs.

After dropping and restoring the DBs some were not updating to the latest DB2 version – this is resolved by running the update DB command

db2 upgrade db <DBNAME>

this upgrades the DB to the latest DB2 version – I run this after each restore command now to ensure the DB does update

for example

db2 restore db BLOGS from E:\install\V55_Backup\db2_backup taken at 20170718123342 ON E:\ into BLOGS
db2 upgrade db BLOGS

 

The metrics DB would not restore as it was complaining about heap size – after a quick google on the error I found a page suggesting just to change the application heap size using the following command

db2 UPDATE DB CFG FOR METRICS USING APPLHEAPSZ 4000

This resolved the problem and the metrics DB could be restored

 

I have also seen issues with the Connections DB update wizard when the databases have a lot of data. In a mature environment I generally run through the wizard and save the update commands to a text file. Then execute them manually from the db2 command window – for example

Activities
 1. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\activities\db2\upgrade-55CR2-60.sql
 2. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\activities\db2\appGrants.sql
 3. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\activities\db2\reorg.sql
 4. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\activities\db2\runstats.sql

Blogs
 1. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\blogs\db2\upgrade-55-60.sql
 2. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\blogs\db2\appGrants.sql
 3. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\blogs\db2\reorg.sql
 4. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\blogs\db2\runstats.sql

Bookmarks
 1. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\dogear\db2\upgrade-55-60.sql
 2. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\dogear\db2\appGrants.sql
 3. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\dogear\db2\reorg.sql
 4. E:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -td@ -vf connections.sql\dogear\db2\runstats.sql

.................. ETC.

For some reason if you have large DBs the wizard struggles massively. Running the commands manually from the command window also allows you to dump each commands logs out into a text file if you need to. Great for debugging and used a LOT when I ran through the AIX Oracle to Windows DB2 migration last year.

 

Once the DBs were restored and updated run the reorg and runstats against each of the DBs before you start it up and if you can also run theΒ clearScheduler.sql for each DB.

That should sort out the majority of DB issues you may see during the update.

 

Connections TouchPoint

 

Again a fairly easy process once you work out what the documentation is talking about – things of note

The document speaks of copying the touchpoint folder contents to the htdocs directory –

 

 

 

 

 

 

you have to copy the entire folder – for example

Copy files from E:\install\Connections\Touchpoint\touchpoint to E:\IBM\HTTPServer\htdocs\touchpoint the wording in the documentation doesn’t really make that clear.

All of the paths etc in the documenation are case sensitive.

Another thing of note which has tripped me up twice now so I have to blog it (thank you Ben for the extra eyes on this one) is the contents of the touchpoint.deploy.properties

The touchpoint.deploy.properties which is included in the install files is different from the example the documentation gives, we basically mix the two and have the contents of the file looking like this

# when install to a clustered environment, provide clusterName.
# when install to a standalone server, provide node and server name.
clusterName=apps
#nodeName=icbvtDB2Node01
#serverName=server1

# setting required REE custom properties
ree.prop.image.upload.path=E:/IBM/CnxData/shared/touchpoint/upload_pic
ree.prop.profiles.app.entrypoint.host=connections.url.com
ree.prop.profiles.app.entrypoint.scheme=https
ree.prop.profiles.app.entrypoint.port=443

NOTE:Β  If using windows the image upload path must have / the linux way not \ the windows way. It will fail if you don’t even if you have it in “E:\IBM\etc…” it appears to be a java / python thing and the error will complain that it can not pass the properties file if the slashes are not /

 

IBM Docs CR2

 

To use IBM Docs with Connections 6 you must update to CR2 for Docs – that is fine (and see previous blog posts about issues with applying the CR2 fix).

There is an awesome gotcha that my good friend Roberto pointed me in the direction of the fix for – this one was a good one (thank you Marti for writing the blog)

The symptoms are Docs editing works fine, but when attempting to view a file the error : CLFAF400W: Can’t access the document repository appears

Its a super quick fix – edit the viewer-config.json which can be found in the (i.e \IBM\WebSphere\AppServer\profiles\Dmgr01\config\cells\<cell name>\IBMDocs-config)

Under the section

"components": [
 {
 "config": {
 "uploadRepository": "lcfiles",

find the line

 "class" : "com.ibm.concord.viewer.lc3.repository.LCFilesEJBRepository",

and replace it with

 "class": "com.ibm.concord.viewer.lc3.repository.LCFilesCMISRepository"

Just above that you can see the files_path

 "files_path": "E://IBM//CnxData//shared/files/upload"

Add the additional info to that section

 "j2c_alias": "connectionsAdmin", 
 "s2s_method": "j2c_alias", 
 "server_url": "https://connections.url.com/files",
 "files_path": "E://IBM//CnxData//shared/files/upload"

So the full section will now look like this:

 "components": [
 {
 "config": {
 "uploadRepository": "lcfiles", 
 "adapters": [
 {
 "config": {
 "j2c_alias": "connectionsAdmin", 
 "s2s_method": "j2c_alias", 
 "server_url": "https://connections.url.com/files",
 "files_path": "E://IBM//CnxData//shared/files/upload"
 }, 
 "id": "lcfiles", 
 "class": "com.ibm.concord.viewer.lc3.repository.LCFilesCMISRepository"
 },

 

Save the file and do a full sync once a restart of the viewer app is done the viewer will now work.

 

One other thing of note when it comes to migrating the Docs data and DBs is that almost every time you do a migration the wasadmin user will be out of sync and you will see duplicate user issues in the log.

easily resolved by running the syncMember command from the DMGR\bin directory

wsadmin.bat -lang jython

execfile("filesAdmin.py")

FilesMemberService.syncMemberExtIdByLogin("wasadmin")

 

Other things you should do once the docs data has been migrated is to run the generate thumbnails command (also from wsadmin in the filesAdmin section)

wsadmin.bat -lang jython

execfile("filesAdmin.py")

FilesThumbnailService.generateForAllFiles()

 

Also to migrate any drafts from the docs installer directory i.e

wsadmin.bat -lang jython -f E:/IBM/ConnectionsDocs/Docs/installer/docs/tasks/start_migration_tool.py

 

Hopefully you won’t come across any or more than one of these issues, but if you do hopefully there will be a quick resolution.

If I find anything else I will be sure to blog them.

IBM Cloud migration and management Webinar

I have the pleasure of giving another webinar on Wednesday at 4pm UK / 11 am EST – with my friend and IBMer Luis Guirigay

We will be talking about migrating to the cloud and user management once you are there ….

Join this webinar to learn more. Register here.

[blockquote align=center]

Are you interested in running some or all of your messaging platform in the Cloud? Interested in IBM Verse? Worried about how to manage the user-lifecycle in a hybrid or cloud environment? Not sure about how or where to start?

If you ever had any of these questions join IBM’s Luis Guirigay and BCC’s Sharon James for a quick but thorough review of how to deploy a SmartCloud Notes infrastructure, how to start your user migration project in no time and how to manage a hybrid or cloud environment with ease using BCC’s AdminTool for Connections Cloud.

AdminTool for Connections cloud offers centralized user management and administration, customizable user interface, security and logging features whether on-premises, hybrid or cloud only

[/blockquote]

 

Want to go to IBM Connect .. be nice to a Champion for a discount

Being an IBM Champion is great and it does come with some benefits.

Today all IBM Champions are happy to announce that we can offer YOU a discount of $100 for IBM’s upcoming ICS event – IBM Connect in San Francisco

So what do you need to do – just reach out to an IBM Champion tell us why you want to go to Connect and what your expectations are and as if by magic we will give you the dscont code.

Now is a great time to register .. and I wish I was going to be there with you all (but I will be in Orlando – on a very long awaited family holiday) – so ping a champ and get the code πŸ™‚

What’s New In ICS Computing Webinar

A brand new webcast hosted by ICONUK is starting this month on the 14th July at 3pm (BST)

 

This month we will introduce the webinars and also have speakers from the world of IBM Collaborative Services, The Champion Community and the wider user community.
These are going to be regular monthly webinars, so get in quick for the first one, as they are bound to be popular.

 

What’s New in the World of IBM Collaboration: Chris Moore & Leon Becket from IBM will talk about the latest enhancements and updates to IBM’s collaboration solutions. In this session, they will present what the updates have been to Verse, Connections Cloud and more. What these mean to you and demonstrate some of these key updates.

 

Also this month: The Internet of Things talking to IBM Connections Cloud – by our very own Steve McDonaugh

 

You can register for this event here: http://iconuk.org/iconuk.nsf/events.html

And find out more and register for ICONUK here: http://iconuk.org

IBM Connections 5.5 and Docs 2.0 announced

At last what we have been waiting for the latest versions of IBM Connections and IBM Docs are available this Friday the 18th of December.

 

There are over 100 new features included nested folders, there is a new cleaner look continuing the trend that we have seen over the last two releases.

 

 

  • Organize your documents, presentations and more into your own nested folder hierarchy in Personal and Community Files
  • Brand new file viewer experience which allows you to find the content that you need faster and review it quickly without having to download
  • Build powerful team sites specific for your team needs (e.g. HR, Sales, Marketing, etc) with new configuration capabilities such as:

 

  • New community layouts
  • Responsive apps so you can just drag-n-drop between columns in one motion
  • Rename apps based on your audience
  • A brand new Rich Content app which you can use for announcements or embedding content from the web
  • and much more.. !

 

  • Smart type-ahead search to find what you need instantly
  • Enhancements to the rich text editor such as permanent pen, sort table data, and more
  • Real-time alerts on your desktop (for HTML5 browsers) to notify you when content needs your attention

 

 

I am really looking forward to getting the latest releases downloaded and tested over the Christmas break .. great work from the product management team …

Read the full post on Luis blog here

Issue with Connections media widget timing out

Whilst building a new Connections environment for a customer we noticed a strange issue when uploading large files to the media gallery.

Initially I thought it was related to the size of the file, but the same file will upload to the Connections files application without issue. There is very little errors in the SystemOut.log for the Connections server, so I was baffled.

A PMR was opened and the very helpful Mr Dave McCarthy was the PMR owner and we then started on our investigation. During the testing I noticed that the uploads appeared to timeout after 20 mins, exactly 20 mins. After some experimenting on 4 different Connections systems, it was confirmed that it was a timeout, reguardless of the file policy or file library size. So not many people are on a intenet connection that may take 20 mins to upload a video, but we know it is an issue as the customer I was building the system for confirmed this.

After much digging through existing PMRs Dave was stummped, so the PMR was passed up the chain to the development team. Who confirmed very quickly that their is a setting in the config.js which is burried in the news ear file which has a time out set to 1200 sec (20 minutes)!! Change this setting and as if by magic the timeout issue is resolved.

To change the time out setting do the following :

/installedApps//News.ear/qkr.lw.war/WEB-INF/pages/js/config.js

Find this section, (Line 450), that specifies some timeout values,
including one for upload that is set to 1200 sec (20 minutes):

timeout: {
request: 60,
update: 200,
upload: 1200,
retrieveFiles: 100,
userSearch: 200,
userTypeahead: 10
},

Raise the upload value from 1200 to what is needed to complete the large file upload on your connection speed and save the file. Then restart the News application to make the change effective. This file should be changed on the primary Connections node if you have more than one and sync the changes around the other nodes.

Wow – Lotusphere really is as cool as they say

Well I am into my 3rd day of being in Orlando and Lotusphere has really kicked off.

I arrived late Friday night – pulled a 25 hours day – so just ate then slept
Saturday was a great day .. after breakfast my friend (who isn’t a geek and has come for *the ride*) hit the Magic Kingdom – after 6 hoursof fun I headed back to arrive late for the BALD meet.

I have met up with some great people – old friends πŸ˜‰ and finally got to meet some of the fabulous community guys that put up with my ranting via twitter. I have checked out Kimonos and the jury is still out on saki – def not warm that is just SO wrong !! the ESPN bar is very cool and very busy but the burgers are great ..

I am currently sat in the Dolphin lobby in a hugely oversized chair (i feel about 12 as my feet don’t even come close to the floor) and the Lotusphere back pack makes a great footstool πŸ™‚ my *normal* size laptop wont fit in the LS bag so I will have to fall back on the old IBM common rucksack .. there are geeks everywhere – its only missing Dave Hay to be an ΓΊbber geek fest πŸ™‚

the only bummer on the day so far is they are playing James bloody Blunt on the PA system

Wow .. This looks awsome

today thanks to the lovely Mr Stuart McIntyre for the tip off .. but Mr David Hay IBM consultant and general technical guru and geek has posted a guide to Portal 6.1.5 (with screen shots) .. WOW IBM, you have made the portal interface look as cool as the connection one does πŸ™‚

I am downloading it now and looking forward to a play