Unable To Refresh Partition Dimension After Creating From EIF XOQ-01600 OLAP DML error while executing DML

(Doc ID 1941803.1)

Last updated on NOVEMBER 05, 2014

Applies to:

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


On : version,

When attempting to refresh dimensions in OLAP cube
the following error occurs.

INI : error creating a definition manager Generic at TxsOqConnection generic ORA 37106:invalid partition name
XOQ-01600 OLAP DML error while executing DML
SYS.AWXML!R_11_COMPLILE_PARTITIONS Generic atTxsOqstdfromcommand:execute


Partition "P0" is a default partition that was created automatically when refresh partitioned dimension. Below are the steps you followed

1) Limited all  dimensions to null in OLAP worksheet

limit dim1 to null
limit dim2 to null

2) EXPORT command is used to copy everything to an EIF file


export all to eif file [eif filename]

3) Later used IMPORT command to copy everything from same EIF file into empty workspace


import all from eif file [eif filename]

4) You are able to refresh all dimensions except partition dimension


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