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 JUNE 26, 2018

Applies to:

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

Symptoms

DESCRIPTION
-----------------------
Cannot import large P6 projects into PRA via Web Services

ERROR
-----------------------
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 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

STEPS
-----------------------
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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