My Oracle Support Banner

Error: "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression" When Logging Into Visualizer (Doc ID 2430437.1)

Last updated on AUGUST 15, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.0.0 and later
Primavera P6 Professional Project Management - Version 17.12.0.0 and later
All Platforms

Symptoms

When attempting to login to Visualizer, the following errors occurs:

ERROR
-------
Type : System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
ClientConnectionId : 8c6c30c1-9ecc-4fff-af29-604b77722c5d
Class : 16
LineNumber : 17
Number : 512
Procedure : POPULATE_UACCESS

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!


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