Thursday, 27 October 2011

CLFRQ0415E when accessing the Homepage feature of IBM Connections 3.0.1

One of my colleagues saw this exception: -

CLFRQ0415E: An error occurred while executing the action. See nested exception for more details.
java.lang.NullPointerException

earlier when trying to access the Homepage application in a newly minted IBM Connections 3.0.1 installation.

I asked him to check whether the databases had been correctly created and configured.

He checked with the DBA, who'd set the databases up manually, and found that the script initData.sql had not been executed.

Once this was run, the Homepage application burst into life.

The Wiki documents this manual database setup for each feature, as per this example ( for Homepage )

C:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -tvf connections.sql\homepage\db2\createDb.sql
C:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -tvf connections.sql\homepage\db2\appGrants.sql
C:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -tvf connections.sql\homepage\db2\initData.sql
C:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -tvf connections.sql\homepage\db2\reorg.sql
C:\IBM\SQLLIB\bin\db2cmd -c -w -i db2 -tvf connections.sql\homepage\db2\updateStats.sql  

Hope this helps.

No comments: