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.
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+)
This is the entry for a report called “Sample”
When you change fileSystem.friendlyNames to “false”, it forces LCM to extract the reports based on their IDs (not names).
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 220.127.116.11 where it is listed as Know Issues under
13862629 – Artifact export, by default, uses friendly artifact names instead of artifact IDs even if the friendly name setting is set to false.
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 18.104.22.168 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 (22.214.171.124) 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 )
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)