Troubleshooting for Star

Previous TopicNext TopicContents

P6 Reporting Database writes detailed process information to the “log” directory under the P6 Reporting Database home folder. The log directory contains information about the installation, as well as about each run of the staretl process. If an error occurs, depending on the nature of the error, the files of the log directory may include diagnostic information. Analyzing these files can help lead you to the resolution or to the file or process that caused the error.

Oracle Database Gateway 11.2 Reporting Incorrect Column Size

If the Oracle Database Gateway 11.2 reports incorrect column size, and the extract fails, ensure that the following are set in the initdg4msql.ora file:

The configuration utility does not launch during the P6 Reporting Database installation process

If you are installing P6 Reporting Database and the Configuration utility never launches, the location of the JRE may be incorrect. To correct this issue, run the following:

Ensure that you specify the correct location for your systems Java Runtime Environment (JRE). The installer will show you an example of the correct path.

ETL and OBI query performance

P6 Reporting Database has default hints that are added based on data samples. The hints aim to improve performance across all data sets. To further improve performance, you can add non-default hints to P6 Reporting Database. You should investigate adding non-default hints if you see bottlenecks in the OBI query performance or when you run the ETL process on your data set.

Contacting Customer Support

See Where to Get Support for detailed information about contacting Customer Support.

If you have a question about using P6 Reporting Database that you or your network administrator cannot resolve with information in the documentation, please contact Customer Support.



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014