|Latest 7 Posts
| Domino 10 – to be continued!|
Mon, Nov 6th 2017 5
| IBM Connections 6 – Following and Followers blank|
Wed, Oct 25th 2017 5
| Exchange integration into WebSphere Portal (SSO – Kerberos)|
Tue, Sep 26th 2017 6
| User provisioning for IBM Connections Cloud – You have the choice|
Mon, Aug 28th 2017 4
| SAML & IBM Connections 5.5 – not a dream team|
Fri, Aug 18th 2017 8
| IBM Docs – Migration from DB2 –> ORACLE|
Fri, Jul 7th 2017 2
| IBM Connections – trouble adding additional nodes|
Wed, May 31st 2017 4
| DB2 Instance autostart does not work on SLES 12 / RHEL 7|
Tue, Jul 12th 2016 17
| Configuration of secret key storage in WebSphere Application Server|
Thu, Mar 12th 2015 15
| SAML – Enterprise SSO in the WebSphere world|
Mon, Jul 20th 2015 15
| Security Bulletin: HTTP Response Splitting in WebSphere Application Server (CVE-2016-0359)|
Tue, Sep 13th 2016 10
| IBM Connections: Create external Users / Community using rest API|
Wed, Mar 25th 2015 9
| HTTP Outbound authentication via SAML|
Tue, Oct 6th 2015 9
| WebSphere custom TAI – Doing SSO the right way|
Tue, Sep 6th 2016 9
| IBM Connections Docs – file preview not possible for some CCM pdf files|
Thu, Nov 17th 2016 9
| Security Bulletin: Vulnerabilities in Apache Struts affects IBM WebSphere Application Server (CVE-2016-1181 and CVE-2016-1182) (2016.06.28)|
Tue, Sep 13th 2016 8
| SAML & IBM Connections 5.5 – not a dream team|
Fri, Aug 18th 2017 8
||Trouble transferring Oracle –> DB2 database IC4.5 – IC5.0
Trouble transferring Oracle –> DB2 database IC4.5 – IC5.0
Last week I had trouble transferring an IBM Connections 4.5 oracle database to DB2. The customer decided to “move away” from Oracle and to DB2… But this seems to be a little bit a problem for at least three of the IBM Connections databases (Files, Wikis and Blogs).
As you may know, you can migrate IBM Connections databases using the dbt.jar between all supported DB vendors (DB2, oracle, MSSql).
The procedure how dbt.jar transfer works is the same as WebSphere Portal also transfers databases from derby to DB2 (initial database transfer):
- Create the target database
- Remove the constraints (foreign keys of the table)
- Transfer the data from “old” to “new” database (table by table)
- Re add the constraints
- That`s it
In case of the three “bad” databases, I got the following error message when transferring the data:
Explanation: SQLSTATE 23502: An insert or update value is null,
but the column cannot contain null values."
hmm… I compared both “createDb.sql” scripts and there I found the problem:
The createDb.sql script for ORACLE
The createDb.sql script for DB2
Here an example out of the files createDb.sql scripts. Can you see the difference of attribute definition for SUMMARY?
This means, that the transfer task tries to insert null values from Oracle into DB2. But per definition, DB2 permits those inserts of null values.
IBM also identified the problem and provides scripts you can use to “remove” the non-equal NOT NULL definitions from the DB2 createDb.sql script. After migration there is a script to re add those definitions to match the DB2 rules.
You need to create the databases “files, wikis and blogs” with the following createDb.sql files:
After migration you need to apply the “Files-, Wikis-, BlogsFixup.sql” file to readd the NOT NULL definitions:
Still there is a big question mark how to transfer the Filenet databases from oracle to DB2. Let`s see what a solution we can find here
Aug 26, 2015
| Recent Blog Posts
Domino 10 – to be continued!|
Mon, Nov 6th 2017 8:48a GIS Techblog
Welcome to the first post about IBM Domino on our GIS AG Techblog!
Here at GIS AG, we have a dedicated IBM Domino team made up of certified specialists for everything from development, to administration, support and beyond. On this blog we will be sharing the latest news and technical information about IBM Domino.
If you have any questions or comments, please, feel free to write an Email to: email@example.com
Visit our About Us page!
Domino 10 – This year Notes and Domino 9.0
IBM Connections 6 – Following and Followers blank|
Wed, Oct 25th 2017 8:42a GIS Techblog
IBM Connections 6 – Following and Followers blank
during the last weeks we had to deal with a strange problem in an IBM Connections 6 environment.
The system was migrated from IC 5.5 to IC 6 and live for about 4 weeks when suddenly the following problem occurred:
Neither users that I follow nor followers were shown in the UI. Despite installing the latest Fixes no bigger changes have been performed on the system.
I was able to follow a user:
Then opening “Following
Exchange integration into WebSphere Portal (SSO – Kerberos)|
Tue, Sep 26th 2017 12:03p GIS Techblog
Exchange integration into WebSphere Portal (SSO – Kerberos)
During the last years working with Portal I had several challenges with WebSphere Portals HTTP Outbound Proxy (aka. Ajax Proxy) in terms of authenticating backend calls to various other systems.
What we`ve done so far in terms of SSO / backend authentication:
– Authenticating using LTPAToken
– Authenticating using SAML
– Authenticating using SPNEGO / Kerberos (this was a new one for me)
The challenge this time
User provisioning for IBM Connections Cloud – You have the choice|
Mon, Aug 28th 2017 1:42p GIS Techblog
User provisioning for IBM Connections Cloud – You have the choice
Customers who use IBM Cloud for Connections, Sametime or other applications face the problem to manage their cloud accounts. For some single users you can use the Web frontend to add or change user accounts or to assign subscriptions and licenses to users. But in real world scenarios it is not possible to manage thousands of users manually or to keep them synchronized with an on-prem user repository or LDAP.
This can be handled
SAML & IBM Connections 5.5 – not a dream team|
Fri, Aug 18th 2017 7:45a GIS Techblog
last week we had to fight with an activation of SAML on a IC 5.5 CR3 environment.
The setup was:
IBM Connections 5.5 CR3 as test instance
ADFS Server 3.0 (I know… it is only tested with ADFS 2.0 – but works with 3.0 too)
We followed the instructions from the IBM Connections Knowledge Center. Smooth setup everything standard procedure. When testing this setup, the redirect to the IdP was initiated. After logging into the IdP the browser was redirected to IBM Connections ACS
IBM Docs – Migration from DB2 –> ORACLE|
Fri, Jul 7th 2017 9:52a GIS Techblog
IBM Docs – Migration from DB2 –> ORACLE
within our last big project, we had the challenge to transfer the IBM Docs database from DB2 to ORACLE. Within this database comments and other document related data is stored.
Officially there is no script available to perform this move using DBT (remove constraints / transfer / reapply constraints). We looked into the database and figured out how to perform this task using DBT – so we are not dependent on any other products. We m
IBM Connections – trouble adding additional nodes|
Wed, May 31st 2017 2:52p GIS Techblog
IBM Connections – trouble adding additional nodes
we are currently involved in a project where we installed a 1 node IBM Connections 6 Cluster and later added a second node to the cell.
So far so good… Everything that needs to be done after adding the second node is described here … Everything? Yes, mainly… but not in the mandatory details as I think! Missing custom properties and other settings might result in non-functional nodes. Especially not setting httpSess
SNOUG 2017 Presentation – SikaConnect goes External|
Thu, Mar 23rd 2017 1:06p GIS Techblog
SNOUG 2017 Presentation – SikaConnect goes External
yesterday I was at SNouG in Zurich. I had a great time there – good speakers and a overall perfectly organized event (would we expect sth. else from Switzerland? )
Raymond Weber from SIKA Informationssysteme AG and I did a session about the SIKA Extranet Feature:
Whiteboard in IBM Sametime Meeting 9.0.1 removed|
Fri, Mar 17th 2017 10:43a GIS Techblog
Whiteboard in IBM Sametime Meeting 9.0.1 removed
IBM implemented in Sametime Meeting 9.0.1 a whiteboard function as technical preview. Ben described in his articel how to enable this feature:
With the current cumulative Fix 901-ST-General-FP-SMOL-AK4G43 for the Meeting Server IBM has removed this function.
The response on my PMR was:
“I can confirm The Meetings Whiteboard feature release is being put on hold indefinitely.
Wikis content not accessible…|
Thu, Jan 26th 2017 10:54a GIS Techblog
Wikis content not accessible…
it`s been quite a long time; many projects at the moment so that blogging needs to wait
Last week we had a very interesting problem at one customer’s environment. When accessing a Wiki, the page was displayed blank – no content was available. Browsing to older versions of this wikis worked.
The error in the log:
Parsing error… Wikis content (the body) gets store in the filesystem as xml files. If you access a Wiki there is a XML parser