OAS 5.9 Installation Fails While Running RCU with Error: Migration V3_0_0_0_0__createtrigger.sql
(Doc ID 2902564.1)
Last updated on OCTOBER 19, 2022
Applies to:
Oracle Analytics Server - Version 5.9.0 to 5.9.0 [Release 5]Information in this document applies to any platform.
Symptoms
The issue occurs in a fresh installation of Oracle Analytics Server 5.9.0 in a windows environment (Windows OS 2016) with Microsoft SQL DB 2014 as a metadata repository. While running the RCU getting warnings such as Migration V3_0_0_0_0_createtrigger.sql failed and Business intelligence platform schema creation getting failed.
Migration V3_0_0_0_0__createtrigger.sql failed
----------------------------------------------
SQL State : HY000
Error Code : 111
Message : [FMWGEN][SQLServer JDBC Driver][SQLServer]'ALTER TRIGGER' must be the first statement in a query batch.
Location : com/oracle/bi/security/bisqlgroup/schema/sqlserver/V3_0_0_0_0__createtrigger.sql (D:\Middleware\oracle_common\bin\file:\D:\Middleware\bi\plugins\patch\bisecurity-sqlgrpprovider-schema-plugin.jar!\com\oracle\bi\security\bisqlgroup\schema\sqlserver\V3_0_0_0_0__createtrigger.sql)
Line : 1
Statement : CREATE OR ALTER TRIGGER REMOVE_G_NAME_GROUPMEMBERS
ON GROUPS
FOR DELETE
AS
BEGIN
DELETE FROM GROUPMEMBERS WHERE G_NAME IN (SELECT G_NAME FROM DELETED) ;
END;
Wed Oct 12 05:30:29.921 EDT 2022 NOTIFICATION bi.schema.plugin.impl.SchemaPluginsProcessor: com.oracle.bi.security.plugins.schema.DBGroupProviderSchemaPlugin::update: Repairing failed database migration...
Wed Oct 12 05:30:29.984 EDT 2022 NOTIFICATION bi.schema.plugin.impl.SchemaPluginsProcessor: com.oracle.bi.security.plugins.schema.DBGroupProviderSchemaPlugin::update: Successfully repaired database. Retrying migration.
Wed Oct 12 05:30:30.055 EDT 2022 ERROR core.internal.command.DbMigrate: org.flywaydb.core.internal.command.DbMigrate::applyMigration: Migration of schema [PRODOAP_BIPLATFORM] to version 3.0.0.0.0 - createtrigger failed! Changes successfully rolled back.
Changes
NA
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |