My Oracle Support Banner

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

Last updated on MAY 23, 2019

Applies to:

Oracle Utilities Framework - Version 2.2.0.0.0 to 2.2.0.0.0 [Release 2.2]
Oracle Financial Services Revenue Management and Billing - Version DNU2.2.1 to DNU2.2.2
Oracle Public Sector Revenue Management - Version 2.2.0 and later
Oracle Utilities Business Intelligence - Version 2.2.0.0.0 to 2.2.0.0.0 [Release 2.2]
Oracle Utilities Customer Care and Billing - Version 2.2.0.0.0 to 2.3.0.0.0 [Release 2.2 to 2.3]
Information in this document applies to any platform.

Goal

Application of Oracle Utilities Framework (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

To view full details, 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 a vibrant support community of peers and Oracle experts.