This article provides information about SQL error when repairing project.

Environment

All versions.
 

Situation

When upgrading project, the Repair process fails with error related to SQL like below:

java.sql.SQLException
Messages:
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. Failed SQL: /* ~~QC */ SELECT RN_RUN_ID,RN_TEST_ID,RN_PATH,CY_PINNED_BASELINE FROM RUN INNER JOIN CYCLE ON CY_CYCLE_ID = RN_CYCLE_ID WHERE ((RN_RUN_ID IN 
...

Cause

The issue may be caused by the long SQL query, it consumes too much Database resource.

Read full article