Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWM 19(18,12.2). Unable to create object from Template file

User_I6AH2Dec 24 2019

Hi!

Analitic Workspace Manager 19.1 (or 12.2.0.1)

Database 18.7

Save any analytic workspace(for example - GLOBAL.GLOBAL) to template.

During recovery ("Create  Analytic Workspace from Template") error

Errors during xml parsing

<Row 2, Column 59>: Unexpected attribute XML "Version" = "2.1" for tag "Metadata"

at oracle.olapi.xml.TagHandler.createRootException(Unknown Source)

at oracle.olapi.xml.TagHandler.getRootException(Unknown Source)

at oracle.olapi.xml.TagHandler.reportException(Unknown Source)

at oracle.olapi.xml.TagHandler.reportException(Unknown Source)

at oracle.olapi.xml.TagHandler.reportError(Unknown Source)

at oracle.olapi.xml.TagHandler.reportError(Unknown Source)

at oracle.olapi.metadata.MetadataXMLReaderMetadataInitialState.enter(Unknown Source)

at oracle.olapi.xml.TagHandler.startElement(Unknown Source)

at org.xml.sax.helpers.ParserAdapter.startElement(ParserAdapter.java:622)

at oracle.xml.parser.v2.XMLContentHandler.startElement(XMLContentHandler.java:182)

at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1653)

at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:473)

at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:419)

at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:248)

at org.xml.sax.helpers.ParserAdapter.parse(ParserAdapter.java:430)

at oracle.olapi.xml.XMLProcessor.parse(Unknown Source)

at oracle.olapi.xml.XMLProcessor.parse(Unknown Source)

at oracle.olapi.metadata.mdm.MdmMetadataProvider.importXML(Unknown Source)

at oracle.olap.olapitemplate.OLAPXMLImpl.importXml(OLAPXMLImpl.java:57)

at oracle.olap.cubetemplate.CubeTemplateManager.createTemplateOjects(CubeTemplateManager.java:369)

at oracle.olap.cubetemplate.CubeTemplateManager.processXMLTemplate(CubeTemplateManager.java:303)

at oracle.olap.cubetemplate.CubeTemplateManager$1.construct(CubeTemplateManager.java:225)

at oracle.olap.awm.ui.SwingWorker$2.run(SwingWorker.java:109)

at java.lang.Thread.run(Thread.java:748)

Thanks,

Serg

Comments

Deepak Patil
Well this looks like that one of your columns or tables are not in the respective database.

Please review the query (step) on which the process has failed , and check if the column EMPLOYE_STATUS_NK is available in the target or source.

Thanks
Dk
759013
Deepak,

Thanks for qucik reply. First column is only present in targer so executing it in target as it's a reference to an Oracle Sequence. Third column employee_description is mapped to a table in stagin.


I confirmed ; column EMPLOYE_STATUS_NK is present in target database and mapped with primary key of source table. I am executing on Source. This column is also marked as key in target datastore. It still give same error.




Any suggestions ?
Deepak Patil
quicker way to resolve this will be if you can share the SQL in this step where you are getting this error.

Some points to check -

if it's a seq number make sure it runs on "target" , it should be "check not null" and of course the Sequence is present in the database (here in target).

Thanks
Dk
759013
Deepak,

I closely followed the sql as you mentioned and figured out why I was getting this error. I had renamed a column in the target database. I added an "_" in column name. ODI had intially created a error table for this table, however ot again tried to create a new table but with a warning that table ALREADY EXISTS.
This table still had old table defination and would give an error "invalid and name of column.

Thanks.
Greenwich
Deepak Patil
Good stuff... mark the post as resolve if possible :)...
1 - 5

Post Details

Added on Dec 24 2019
0 comments
300 views