My Oracle Support Banner

Error: "The Query Processor Ran Out of Internal Resources and Could Not Produce a Query Plan" When Importing Large P6 Projects via Web Services (Doc ID 2412833.1)

Last updated on MARCH 26, 2019

Applies to:

Primavera Risk Analysis - Version 8.7.0070 and later
Information in this document applies to any platform.


Cannot import large P6 projects into PRA via Web Services

Caused by: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information

The issue can be reproduced at will with the following steps:

  1. Connect PRA to P6 via Webservices
  2. Try to open a large P6 Project
  3. Notice the error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.