This chapter describes known Primavera Analytics issues with suggested workarounds as resolutions.
Analysis with Activity NoteBook Text Causes Excessive Temp Tablespace
Scenario: When building an analysis that includes the project name, activity name, active notebook topic name, and activity notebook topic text, the query causes excessive growth of the temp tablespace, and will likely never return data. With filtering though, data may be returned, but can take a long time to run when the activity notebook topic text is included.
Resolution: when accessing notebook topics, it is recommended to filter to the specific level, such as activity, or project. Notebook topics must not be added in an analysis that returns large sets of data. Instead, it should be included in a sub-analysis for more fine-grained smaller returned sets of data. This is a limitation of OBIEE rendering this data type. Using smaller notebook topics or switching from a blob\clob could help with performance.