By Shawn Lafferty on Feb 06, 2013
With a default installation of Oracle Business Intelligence and P6 Analytics 3.1, some object in the P6 Analytics 3.1 default catalog create errors because the path length is too long. Please consult the following Oracle Business Intelligence document, section 220.127.116.11 for Object Name Guidelines (http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/prescatadmin.htm).
If you selected to take the default paths when installing Oracle Business Intelligence, then by default your catalog path with be /home/oracle/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog
This path may cause errors when copying the P6Analytics catalog.
To workaround this issue, create a new folder in a shorter path location (e.g. \home\oracle\Middleware\catalog), copy the P6Analytics folder from the P6 Analytics 3.1 release media to the new folder, and change the path location in Enterprise Manager for your install of Oracle Business Intelligence to use the shorter path.
Additionally, if you installed Oracle Business Intelligence on Linux/UNIX, you can alternatively create a symbolic link, then reference the symbolic link in Oracle Business Intelligence for the catalog path. In Windows, map a drive to the catalog location, then reference the mapped drive in Oracle Business Intelligence for the catalog path.