ORA-00902: Invalid Datatype With Analytic Workspace Manager (Doc ID 2209124.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle OLAP - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms


You are  getting the following error when  trying to create a cube in Analytic Workspace Manager.

The transaction is not committable: "An error has occurred on the server
Error class: Express Failure
Server error descriptions:
DPR: cannot create server cursor, Generic at TxsOqDefinitionManager::generic<CommitRoot>
INI: XOQ-00289: error executing DDL "(CREATE OR REPLACE VIEW "CUBE"."FSBP3_TABLE1_BALANCES_VIEW" AS
SELECT
"AMOUNT",
"CURRENCY",
"CYCLE",
"INSTRUMENT",
"MATURITY_1",
"SECTOR"
FROM TABLE(CUBE_TABLE('"CUBE"."FSBP3_TABLE1_BALANCES"') )
)" for metadata object "(CUBE.FSBP3_TABLE1_BALANCES)", Generic at TxsOqPersistentMetadataContext::executeDDL
INI: XOQ-00106: SQL query failed: "(ORA-00902: invalid datatype
)", Generic at TxsRdbSQLStatement::execute()
"
at oracle.olapi.transaction.BaseTransaction.commit(Unknown Source)
at oracle.olapi.transaction.BaseTransactionProvider.commitCurrentTransaction(Unknown Source)
at oracle.olap.awm.dataobject.DatabaseDO.commitOLAPI(DatabaseDO.java:629)
at oracle.olap.olapitemplate.OLAPPersistenceImpl.commit(OLAPPersistenceImpl.java:29)
at oracle.olap.cubetemplate.CubeTemplateManager.processXMLTemplate(CubeTemplateManager.java:297)
at oracle.olap.cubetemplate.CubeTemplateManager$1.construct(CubeTemplateManager.java:220)
at oracle.olap.awm.ui.SwingWorker$2.run(SwingWorker.java:109)
at java.lang.Thread.run(Unknown Source)

Cause

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 hundreds of Community platforms