55-CR1-homepage-db2.sql – 705 vs. 704

If you were one of the early birds deploying Connections 5.5 and you used the
Connections SQL files from the initial supplied Wizard tools then applying CR1 will fail.

The 55-CR1-homepage-db2 SQL script checks on DBSCHEMAVER 705. This is the version used within the Connections SQL files from the Day1Fix Wizard tools.
The “old” scripts use version 704 for the DBSCHEMAVER column.

UPDATE  HOMEPAGE.HOMEPAGE_SCHEMA SET DBSCHEMAVER = 706, RELEASEVER = '5.5.0.0 CR1'
WHERE   DBSCHEMAVER = 705@

Change the 55-CR1-homepage-db2 SQL script upfront befor applying or make the change after in the HOMEPAGE.HOMEPAGE_SCHEMA table.

.Wizards\connections.sql\homepage\db2\createDb.sql

--------------------------------------
-- INSERT THE SCHEMA VERSION
--------------------------------------
INSERT INTO HOMEPAGE.HOMEPAGE_SCHEMA (COMPKEY, DBSCHEMAVER, RELEASEVER) 
VALUES ('HOMEPAGE', 704, '5.5.0.0')@

.\Wizards_IC55day1fix\connections.sql\homepage\db2\createDb.sql

--------------------------------------
-- INSERT THE SCHEMA VERSION
--------------------------------------
INSERT INTO HOMEPAGE.HOMEPAGE_SCHEMA (COMPKEY, DBSCHEMAVER, RELEASEVER) 
VALUES ('HOMEPAGE', 705, '5.5.0.0')@

 

 

This entry was posted in ibm connections and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please leave these two fields as-is:

Protected by Invisible Defender. Showed 403 to 807,336 bad guys.