Path too long – Hyperion Reporting and Analysis error


I know you must have seen the error while using LCM for Reporting and Analysis objects.
If the pass is too long it’ll throw an error message complaining about path more than 256 characters.
pathlong error
I was working on a client where I got the same issue. (The users had a long way to go to view the reports 😉 )
If you are not aware of Reporting structure here is what it does. (or I think what it does ;))
When you create a report, it adds an entry (more entries, we’ll stick with one for now) in V8_CONTAINER table and then stores the report in a physical location. (this is the data folder location you select while configuring BI+)
Data folder
This is the entry for a report called “Sample”
id path 11.1.2.2
Relational Table
This is the how it gets stored in Relational
11.1.2.2 sample rel
When you change fileSystem.friendlyNames to “false”, it forces LCM to extract the reports based on their IDs (not names).
With that in mid I did follows the steps mentioned under Editing Migration Properties
exp for edit
prop edit
Import the properties file, restarted Shared Services and LCM’ed the report again.
To my surprise it didn’t work. (I got got the names and path too long error). A little bit of research took me to the Readme of 11.1.2.2 where it is listed as Know Issues under
LCM
13862629 – Artifact export, by default, uses friendly artifact names instead of artifact IDs even if the friendly name setting is set to false.
Financial Reporting
13367741 – Some new artifacts are not identified using their friendly names.
I raised an SR to check the status and got the reply as follows
friendlynames false is not supported from 11.1.2.1 onwards. 7-zip has been the recommended approach to overcome the windows path limitation issues.
So by default BI+ artifacts are saved with name and id which is the behavior as when freindlynames is set to true. The reason for disabling the false property was, during our further testing we realized in BI+ each artifact has more than one file with the same name and hence the files cannot be stored by names uniquely on the file
The response made me look at an older version (11.1.1.3) and see what were those changes and to my surprise it didn’t work there too. I do remember it was working on an earlier version. (Can’t remember which one though Sad smile)
I don’t see a change in how RnA stores files in the filesystem, so not sure why the property is not working.

It is great that 7zip can handle this. You can use 7zip to compress the contents and move them across servers.

I think it is high time for Oracle to clean up the documentation. (LCM guide still says friendlynames can be used)
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Path too long – Hyperion Reporting and Analysis error