My Oracle Support Banner

Projects Endeca: PRJ-PJT Incremental Load Fails (Doc ID 2218589.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle Project Planning and Control - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Incremental Load
the following error occurs.

2016-11-24 10:24:51,297 ERROR 255247 [WatchDog_255247] Component [Expenditure Items:EXPENDITURE_ITEMS] finished with status ERROR.
ORA-01427: single-row subquery returns more than one row
2016-11-24 10:24:51,298 ERROR 255247 [WatchDog_255247] Error details:
org.jetel.exception.JetelRuntimeException: Component [Expenditure Items:EXPENDITURE_ITEMS] finished with status ERROR.
at org.jetel.graph.Node.createNodeException(Node.java:543)
at org.jetel.graph.Node.run(Node.java:522)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row


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