My Oracle Support Banner

Import of Mime Type Xlsm File Returns Error "Unknown File Extension. No Mime Type Is Defined For File" (Doc ID 2775940.1)

Last updated on MAY 19, 2021

Applies to:

Hyperion Planning - Version 11.2.0.0.000 to 11.2.5.0.000 [Release 11.2]
Hyperion BI+ - Version 11.2.0.0.000 to 11.2.5.0.000 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 When attempting to import a MIME TYPE file with a ".xlsm" extension into Workspace Explore directory, the following error occurs.

ERROR
-----------------------
Unknown file extension. No MIME type is defined for file <file_name.xlsm>

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From Workspace menu, select File->Import->File.
2. Click on Choose File button.
3. Select a file with .xlsm extension and click Open

In previous releases, one can add a MIME type extension first by performing below steps. 

  1. Select Navigate->Administer-Reporting Settings->Mime Types
  2. At the bottom of page, click the Go button for "Add MIME Type"
  3. Enter below information

Name

Description

File extension

4. Click on Change Icon button (Optional)

5. Click on Finish button

After performing above steps, one is able to import MIME TYPE file with a ".xlsm" extension, for example, into Workspace Explore directory.  However, in 11.2.x release, Navigate->Administer menu is without Reporting Settings option.

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.