upgraded from DNN 3.1 to 3.2.2. Upgrade was successful but first time to portal, I got this:

Server Error in '/' Application.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.]
System.Data.SqlClient.SqlDataReader.Read() +176
DotNetNuke.Common.Utilities.CBO.FillObject(IDataReader dr, Type objType, Boolean ManageDataReader) +57
DotNetNuke.Entities.Portals.PortalController.GetPortal(Int32 PortalId) +38
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +243
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +93
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3717
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87


Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

no changes to the web.config file other than the recommended keys & SQL location.  Also added key for install date.
Any suggestions?

I have the identical error after upgrading from 3.2.0 to 3.2.2. (A new installation of 3.2.2 works without error on the same machine/database so it seems really to be an only an error on upgrades.)

• You mention to look at the PortalID in the table Portals. But this field is a primary key so it is forced to be unique.
• Simply resetting the server does not help.

Does anyone has an idea of what is going wrong?

Thank you, Franz

There are about 200 (only a few are populated) parent portals and 30 child portals. My testing on a new, one portal installation is error free.

Thank You for reply, Franz