Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SEVERE: MESSAGE:::<Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 's

Received Response

22

Views

3

Comments

Mohd Iqbal Wani

Mohd Iqbal Wani Rank 2 - Community Beginner

Sep 24, 2020 6:19PM in Oracle Business Intelligence Applications

Does anyone know or has any solution while assembling a Subject area or building an execution plan getting following error?

Sep 24, 2020 2:15:55 PM com.siebel.etl.engine.core.ETLUtils logException

SEVERE: MESSAGE:::<Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 'sqlStatement'.EXCEPTION CLASS::: com.siebel.etl.gui.core.MetaDataIllegalStateException

com.siebel.etl.engine.custom.SQLFileReader.getFromXmlFile(SQLFileReader.java:223)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:187)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:171)

com.siebel.analytics.etl.execution.TemplatizedAction.setBody(TemplatizedAction.java:52)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.populateNonObjectActions(TemplatizedActionsManager.java:81)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.init(TemplatizedActionsManager.java:46)

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:881)

com.siebel.analytics.etl.execution.Application.init(Application.java:218)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:152)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:41)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

Sep 24, 2020 2:15:55 PM com.siebel.etl.engine.core.ETLUtils logException

SEVERE: MESSAGE:::Error while loading templatized actions.

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:884)

com.siebel.analytics.etl.execution.Application.init(Application.java:218)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:152)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:41)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

::: CAUSE :::

MESSAGE :::com.siebel.etl.gui.core.MetaDataIllegalStateException: <Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 'sqlStatement'.

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.exceptions.TemplateInitializationException

com.siebel.analytics.etl.execution.TemplatizedActionsManager.populateNonObjectActions(TemplatizedActionsManager.java:90)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.init(TemplatizedActionsManager.java:46)

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:881)

com.siebel.analytics.etl.execution.Application.init(Application.java:218)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:152)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:41)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

::: CAUSE :::

MESSAGE :::<Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 'sqlStatement'.

EXCEPTION CLASS::: com.siebel.etl.gui.core.MetaDataIllegalStateException

com.siebel.etl.engine.custom.SQLFileReader.getFromXmlFile(SQLFileReader.java:223)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:187)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:171)

com.siebel.analytics.etl.execution.TemplatizedAction.setBody(TemplatizedAction.java:52)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.populateNonObjectActions(TemplatizedActionsManager.java:81)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.init(TemplatizedActionsManager.java:46)

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:881)

com.siebel.analytics.etl.execution.Application.init(Application.java:218)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:152)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:41)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

0

Answers

Veda Rank 1 - Community Starter

Oct 2, 2020 12:10PM

Hi

What is the version of OBIEE you are using? Were there any recent changes or upgrade of your environment?

Also is it a new installation or have you been using it for a while. My intention was to know if you were able to create subject area or build an execution plan in this environment earlier without any issues and you suddenly started seeing this errors? Or is it that its a fresh installation and you are trying to do for the first time?

Thanks

Veda Santosh

0
Mohd Iqbal Wani Rank 2 - Community Beginner

Oct 2, 2020 5:04PM

Hi - Below is the DAC version. This is not a new installation. Everything was working fine up until we started getting this error.

Oracle BI Data Warehouse Administration Console

Dac Build AN 11.1.1.6.4.20170330.0204, Build date: March 30 2017

Management console to setup, configure, load and administer the Oracle Business Analytics Warehouse

Schema version - 47, Index version - 36, Repository version - 6, Seed data version - 16

Copyright 2003, 2012, Oracle and/or its affiliates. All rights reserved.

0
User_6MEBY Rank 1 - Community Starter

Jul 14, 2021 9:44AM

Hi Mohd Iqbal Wani.

Did you manage to fix this issue?

I have simillar errors during building Subject Area:

MESSAGE:::Error while loading templatized actions.

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:846)

com.siebel.analytics.etl.execution.Application.init(Application.java:197)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:146)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

::: CAUSE :::

MESSAGE :::com.siebel.etl.gui.core.MetaDataIllegalStateException: <Line 93, Column 26>: XML-20122: (Fatal Error) '=' missing in attribute.

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.exceptions.TemplateInitializationException

com.siebel.analytics.etl.execution.TemplatizedActionsManager.populateNonObjectActions(TemplatizedActionsManager.java:90)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.init(TemplatizedActionsManager.java:46)

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:843)

com.siebel.analytics.etl.execution.Application.init(Application.java:197)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:146)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

::: CAUSE :::

MESSAGE :::<Line 93, Column 26>: XML-20122: (Fatal Error) '=' missing in attribute.

EXCEPTION CLASS::: com.siebel.etl.gui.core.MetaDataIllegalStateException

com.siebel.etl.engine.custom.SQLFileReader.getFromXmlFile(SQLFileReader.java:223)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:187)

com.siebel.etl.engine.custom.SQLFileReader.getFromString(SQLFileReader.java:171)

com.siebel.analytics.etl.execution.TemplatizedAction.setBody(TemplatizedAction.java:52)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.populateNonObjectActions(TemplatizedActionsManager.java:81)

com.siebel.analytics.etl.execution.TemplatizedActionsManager.init(TemplatizedActionsManager.java:46)

com.siebel.analytics.etl.execution.Application.populateTemplatizedActions(Application.java:843)

com.siebel.analytics.etl.execution.Application.init(Application.java:197)

com.siebel.analytics.etl.execution.Application.<init>(Application.java:146)

com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)

com.siebel.analytics.etl.execution.SubjectArea.init(SubjectArea.java:153)

com.siebel.analytics.etl.execution.SubjectArea.<init>(SubjectArea.java:130)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.getSubjectAreasForEP(ExecutionPlanDesigner.java:644)

com.siebel.analytics.etl.execution.ExecutionParameters.<init>(ExecutionParameters.java:109)

com.siebel.analytics.etl.execution.ExecutionParameterHelper.<init>(ExecutionParameterHelper.java:42)

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.<init>(ExecutionPlanDesigner.java:183)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:226)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:132)

com.siebel.analytics.etl.client.view.table.EtlDefnTable$BuildHelper.doOperation(EtlDefnTable.java:854)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:54)

com.siebel.etl.gui.view.dialogs.WaitDialog$WaitDialogRunnableHelper.run(WaitDialog.java:86)

java.lang.Thread.run(Unknown Source)

0