197 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 9
Connections 6 migration observations
Tue, Jul 25th 2017 11
It’s that time of year again ..
Fri, Jun 16th 2017 3
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 11
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 9
Who knew my love for StarWars would win me a prize
Sat, May 27th 2017 6
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 8
Top 10
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 11
Connections 6 migration observations
Tue, Jul 25th 2017 11
Can you spare an item to help raise money for two amazing causes?
Wed, Jan 13th 2016 10
Been kinda busy .. BUT
Thu, Mar 3rd 2016 9
A new challenge …
Tue, Jul 5th 2016 9
Migrating Connections DB from Oracle to DB2 part 1
Wed, Nov 23rd 2016 9
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 9
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 9
So Docs 2 CR1 and iFix 1 is not playing ball
Mon, Nov 28th 2016 8
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 8


Connections 6 migration observations
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
Sharon    

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:installV55_Backupdb2_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:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlactivitiesdb2upgrade-55CR2-60.sql
 2. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlactivitiesdb2appGrants.sql
 3. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlactivitiesdb2reorg.sql
 4. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlactivitiesdb2runstats.sql

Blogs
 1. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlblogsdb2upgrade-55-60.sql
 2. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlblogsdb2appGrants.sql
 3. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlblogsdb2reorg.sql
 4. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqlblogsdb2runstats.sql

Bookmarks
 1. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqldogeardb2upgrade-55-60.sql
 2. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqldogeardb2appGrants.sql
 3. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqldogeardb2reorg.sql
 4. E:IBMSQLLIBbindb2cmd -c -w -i db2 -td@ -vf connections.sqldogeardb2runstats.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:installConnectionsTouchpointtouchpoint to E:IBMHTTPServerhtdocstouchpoint 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:IBMetc…” 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 IBMWebSphereAppServerprofilesDmgr01configcells<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 DMGRbin 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.

The post Connections 6 migration observations appeared first on Social Shazza.



---------------------
http://feedproxy.google.com/~r/socialshazza/~3/ZRLj_xIQtLA/
Jul 25, 2017
12 hits



Recent Blog Posts
9
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 9:58a   Sharon Bellamy
There is a known issue with Connections 5 CR4 and all versions of Connections 5.5 when using Chrome version 60. It affects events not being displayed and errors relating to events in the UI. It has also been reported that comments can be affected also. After multiple BP’s and Customers reported this IBM Support have come up with a fix very quickly. The fix you need is IFLO92844 – currently it is only available from IBM support – not sure how long it will be until it is availabl
12
Connections 6 migration observations
Tue, Jul 25th 2017 4:00p   Sharon Bellamy
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. A
3
It’s that time of year again ..
Fri, Jun 16th 2017 5:38p   Sharon Bellamy
I am Running for Feel the Force Day …. My partner in crime Sam will be joining me again this year, along with Jonathan and Mandy will make up the #TeamRun4FTFD to raise funds. Jonathan has cerebal palsy and he doesn’t let that slow him down. Mad on trucks, cars and any kind of awesome vehicle (just see Shaw on Tour for details), he has recently done a bunch of exciting stuff including running (in a race chair), ice skating and trampolining. Mandy is the biscuit queen Famous for her
11
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 2:41p   Sharon Bellamy
So after building the kit and testing that it worked .. It was time to get creative .. there are some examples on what to do code wise on the AIY kit voice site First I had to go through the billing set up and processes. Even though the code is free, and the kit is free and they give you $300 worth of credit – you still have to set up billing. It was a pain as I already had a cloud dev account for some of the APIs I use on bit of my sites, but eventually I worked it out – I may have
9
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 11:55p   Sharon Bellamy
Before I could attempt to get creative with the code examples – we first had to build the kit and make sure it worked with the things and code that was provided. I have used the images from the aiyprojects.withgoogle.com/voice page. They are great pictures and show step by step how to put things together, I may have forgotten to take step by step pics as we built it too. Prep the SD Card With the voice SD image we downloaded in pt1 – use etcher to flash the SD card and get it ready f
6
Who knew my love for StarWars would win me a prize
Sat, May 27th 2017 10:29p   Sharon Bellamy
On May the 4th (also known as StarWars day – you work it out) one of my good friends and former co worker (not sure how he put up sitting opposite me for 2 and a half years ) Mr Dave Sheryn pinged me with an interesting link to a starwars costume competition .. “That’ll be fun”, I thought, “will give it ago .. have a snowballs chance in hell of winning” – so I posted this pic of me With the message O well if we are showing off star wars costumes .. thi
8
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 9:45p   Sharon Bellamy
What’s all this #talkie stuff about then? So I have been posting stuff on facebook twitter and instragram with the #projecttalkie or #talkie hash tag .. Most of you know that I costume .. and as well as my love for star wars (and my mandalorian costume), I also LOVE to costume as Stitch … You can see me here as my favourite fluffy blue alien experiment (626) with my good pal and all around lovely Captain America friend Mr James Budd. Again most of you know that i am a HUGE supporte
5
Migrating Connections DB from Oracle to DB2 part 3
Sat, May 27th 2017 8:48p   Sharon Bellamy
In part 3 of the series we will actually attempt to migrate the data. Migrating Connections DB from Oracle to DB2 In my experience the database migration is always most time consuming, so I always do the database first Use the text file of Commands that we created in part 2. Back up the exisitng Connections databases Drop database, create database, app grants (for homepage also initdata, and re org and run stats) CR update scripts Pre DB fixer script Run the DBT command Application specific s
0
Docs 2.0 CR2 – here we go again
Sat, May 27th 2017 8:05p   Sharon Bellamy
I am blogging this mainly so I remember how to solve this Big thanks to fellow ICS community member and all round great guy Robert Farstad for blogging this Again you can see a problem when patching Docs 2 to CR2 as it can’t find the FQDN of the hosts. The code has changed so it’s not possible to use the work around that we had previously. There is a slight twist to getting it to work which Rob has explained fabulously so thank you mate .. you saved me a lot of grief .. and even IBM
1
Connections 6 system requirements are available
Wed, Mar 29th 2017 2:21p   Sharon Bellamy
thanks to my friend and co-speaker Roberto Boccadoro for sharing these .. you can find the system requirements for Connections 6 here The basic info is: WAS 8.5.5.10 IBM install manager 1.8.5 DB2 11.1.0 / Oracle 12.1.0.2.0 (enterprise) / MS SQL 2016 TDI 7.1.1 fix pack 6 Connections 6 is going to be released on Friday 31st of March – happy downloading and installing The post Connections 6 system requirements are available appeared first on Social Shazza.




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