My Oracle Support Banner

PSA Upgrade Failed With An Error While Upgrading OBIEE To 11.1.1.9 (Doc ID 2404819.1)

Last updated on JUNE 02, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

While upgrade obiee from 11.1.1.7 to OBIEE 11.1.1.9, it failed at the step of upgrade RCU.
MDS schema updated successfully, but BIPlatform Schema upgrade failed with an error.

Below is the error for reference. Attached the log file with this ticket.

[2018-05-24T13:00:17.947+10:00] [RCU] [NOTIFICATION] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] ParseNexecute Script: E:\Middleware\oracle_common\upgrade\temp\upgradebiplatform.sql
[2018-05-24T13:00:17.947+10:00] [RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] Retrieving fileName from: E:\Middleware\Oracle_BI1\bifoundation\update\11.1.1.9.0\11.1.1.7.0\mssql\bi\upgradebi.sql -v v1=null v2=STAGE_BIPLATFORM
[2018-05-24T13:00:17.947+10:00] [RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] FileName: E:\Middleware\Oracle_BI1\bifoundation\update\11.1.1.9.0\11.1.1.7.0\mssql\bi\upgradebi.sql -v v1=null v2=STAGE_BIPLATFORM
[2018-05-24T13:00:17.963+10:00] [RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] Error to check : 156
[2018-05-24T13:00:17.963+10:00] [RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] Error array to retry: 17410
[2018-05-24T13:00:17.963+10:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'null'.
[2018-05-24T13:00:17.963+10:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 35] [ecid: 0000MEG5kKi9LeOqygMaMG1R1Ydz000004,0] [[
java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'null'.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)

Changes

 

Cause

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.