SQL Server FW V2.2.0 Service Pack 1 Install Failed (Doc ID 1250626.1)

Last updated on OCTOBER 26, 2010

Applies to:

Oracle Utilities Framework - Version: 2.2.0 to 2.2.0 - Release: 2.2 to 2.2
Oracle Revenue Management and Billing for Financial Services - Version: 2.2.1 to 2.2.2]
Oracle Enterprise Taxation Management - Version: 2.2.0 to 2.2.0]
Oracle Utilities Business Intelligence - Version: 2.2.0 to 2.2.0   [Release: 2.2 to 2.2]
Oracle Utilities Customer Care and Billing - Version: 2.2.0 to 2.3.0   [Release: 2.2 to 2.3]
Information in this document applies to any platform.

Goal

Application of FW V2.2.0 SP1 failed. We received the following error messages when executing \FW\FW22_SP1\Install-Upgrade\SPDBA.exe:


Loading CI_TD_TYPE from the blueprint
Loading CI_TD_TYPE from the target database
ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'APP_SVC_ID'. (SQL-42S22)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'PRIORITY'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000) occured while executing select TD_TYPE_CD,CRE_BATCH_CD,MESSAGE_CAT_NBR,APP_SVC_ID,MESSAGE_NBR,RTE_BATCH_CD,PRIORITY,OWNER_FLG,TD_USAGE_TYPE_FLG,
TD_PRIORITY_FLG,NAV_OPT_CD from CI_TD_TYPE where OWNER_FLG='F1'
Error Occured, Process being aborted

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms