ORMB 2.2.1 SP1 is released ... some extra install notes

ORMB2.2.1 SP1 has been release via patch #9362920 for Windows (AIX is patch #9362934 an Linux is patch #9363944)

Before I installed this patch, The Base Product is at the following levels : ORMB 2.2.1 with FW 2.2.0 SP3.

Before doing the upgrade, good standard practices should be to backup the application server folder as well as performing a full backup of the database.

In order to upgrade to ORMB V2.2.1.1 (SP1) the following needs to be applied to the Base ORMB Application:
1) FW Pre requisites FW SP6 patch #9322470 (This is a SQL only patch, known as the “V1SP1 patch”)
2) FW SP6 patch #9042811
3) Additional post SP6 FW single fixed patches: patch #9073699 and patch #9114541 in this order.
(For patch #9114541 you will need to install the patch mentioned in my previous blog on installing OUBI 2.2.1 SP1
here are the details:
i) Install FW SF patch #8845615 , as part of this patch a co-req 9032599 has a SQL portion.
ii) Install FW SF patch #9014351
iii) Install FW SF patch #9069631
iv) and finally FW SF patch #8793321.)
4) 3rd Party Upgrade of Hibernate 3.2.5 to 3.2.7 (See Appendix B in the Upgrade Guide)
5) and Finally : ORMB 2.2.1 SP1 patch (patch AIX #9362934,Window #9362920,Linux #9362944)

In Order to Upgrade the Database for ORMB to get to the ORMB V2.2.1.1 (SP1) level the following needs to be applied to the database:
(please note a sample Database dump has been provided at this latest release level for Oracle 11g)
1) FW Pre requisites FW SP6 patch #9322470 (This is a SQL only patch, known as the “V1SP1 patch”)
2) FW SP6 patch #9042811 (SQL portion)
3) Additional FW single fixed patch #9073699 and patch #9114541 in this order (no SQL in these patches other than co-req 9032599 SQL portion.)
4) ORMB 2.2.1 SP1 patch (SQL portion) (patch AIX #9362934,Window #9362920,Linux #9362944)

OUBI 2.2.1 SP1 is released ... some install notes

OUBI 2.2.1 SP1 has been release via patch #9257554.

Before I installed this patch, I had already installed FW 2.2.0 SP6 in the environment. So when putting in the OUBI 2.2.1 service pack, a few FW patches are required that are post FW 2.2.0 SP6.

Here is the list and order that I installed the list of FW Single Fixes :

1) Install FW SF patch #8845615 , as part of this patch a co-req 9032599 has a SQL portion.
2) Install FW SF patch #9014351
3) Install FW SF patch #9069631
4) and finally FW SF patch #8793321.

Then you will be able to install the OUBI 2.2.1 SP1. Please note there are SPLADM and DWADM schema changes in the SQL portion.

If you only have a demo database installed only i.e. no BIREPOWN schema , you may have an issue with th following grant statement in SQL patch 8422565 with sql script file 8422565_RS2.sql. The statement is :

GRANT SELECT ON BIREPOWN.WB_RT_AUDIT TO DWADM

ETM 2.2.0 CR for Single Fixes Up to January 2010 Patch # 9371547

A CR (Consolidated rollup patch #9371547)of ETM related single fixes has been released. To install this you need to have your ETM 2.2.0 environment at the following level : ETM 2.2.0 SP1 (Patch #9002875) with FW 2.2.0 SP6 (Patch #9042811) .

To install the latest and greated Demo Database with the latest ETM 2.2.0 Environment level, I installed the demo dump called Build 11 (Patch # 9219548)
and then in the database ran the FW 2.2.0 SP6 Database portion and the database portion for the CR patch #9371547. The Demo dump was released at ETM 2.2.0 SP1 FW 2.2.0 SP5.

The demo database includes includes additional date entries in the accounting calendar and filing calendars up to the end of 2011.

XAI Client V2.2.0.5 (Schema Editor) released

An updated Schema Editor has been released. This version fixes the following minor bugs:

Update Copyright Info in XAI Client,
XAI Client (Schema Editor) creates duplicate nodes and
XAI Client (Schema Editor) throws an error when trying to create service FreezeonAdjustment (C1ADJFZP)

The XAI Client schema editor is a very robust bit of software and very seldom do I see any errors with it. The last version was 2.2.0.3

FW SDK 2.2.0.10 is released

FW SDK 2.2.0.10 has 4 fixes in this release, related to a way to distribute the
eclipse plugins , context sensitive help, eclipse configuration for 2.3.0 ccb project and sl stylesheets to be included in cm.jar