I need some help, my ISP pulled a whammie and upgraded themselves to ASP2.0 without notice so now Im stuck with a 3.2.2 site thats DOA.  In my attempt to upgrade to 4.5.3 I now get the following error after the DB configuration:

Installing Database - Version 4.4.0...Upgrading Database to Version ERROR: See E:\kunden\homepages\42\d146728167\DotNetNuke\Providers\DataProviders\SqlDataProvider\04.04.00.log for more information...FAILURE 400 - Conversion from string "ERROR: See E:kundenhomepages"d14" to type 'Integer' is not valid.

Any help or thoughts at all, the log file it refers to does not exist on my site, I'm afraid to close out of the install for really screwing myself up (yeah I have backups but who wants o do that)

Thanks,

Chris

At the time of the message the 4.4.0 error log was not created.  DotNetNuke.Data.Log had dozens of PK violations trying to insert records into eventlogs, modules, moduledefinitions,lists,searchcommonwords.

When I closed out the browser and got back in, it magically finished processing, giving me a slue of error logs for 4.4.1,4.5.0,4.5.1,4.5.2

The 4.4.0 error log contained:
System.Data.SqlClient.SqlException: Ambiguous column name 'PortalID'.
Ambiguous column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE procedure dbo146769239.[GetPortalRoles]

 @PortalId     int

AS
 SELECT R.RoleId,
     R.PortalId,
     R.RoleGroupId,
     R.RoleName,
     R.Description,
     'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
     'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
     'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
     'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
     'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
     'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
     'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
     'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
     RSVPCode,
     IconFile
 FROM dbo146769239.Roles R
 LEFT OUTER JOIN dbo146769239.Lists L1 ON R.BillingFrequency = L1.Value
 LEFT OUTER JOIN dbo146769239.Lists L2 ON R.TrialFrequency = L2.Value
 WHERE  ( PortalId = @PortalId OR PortalId is null )
  AND L1.ListName='Frequency'
  AND L2.ListName='Frequency'
 ORDER BY R.RoleName

The part that bothers me about this isn't so much that it is an ambig column, but that its a CREATE, when the proc already existed from 3.2.2.  Maybe I'm just missing something but I just dont see how any of the DotNetNuke.Schema.SqlDataProvider actually accomplished anything since there isn't an ALTER in the entire file.  I DID run the upgrade package, not a clean install. 

As it stands now I'm just dead in the water.

any help would be appreciated, thanks :)

Chris

ct_klein:

if there are errors with 4.4.0 upgrade script due to data inconsistencies, it is more likely that following script will also show errors. you need roll back to 3.2.2, eliminate the inconsistencies and restart upgrade.