Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Forums > Document Exchange > Installation and Activation Issues
SQL Server 2008
Last Post 03/31/2010 4:22 PM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Gary Miller
New Member
New Member
Posts:6


--
03/29/2010 7:35 PM

I just ran the upgrade to 5.02.04 and it is failing.   This is my first upgrade after migrating from MS SQL2000 to SQL2008.   Should SQL 2008 be a problem?  or do I have something else going on?  DNN 04.09.05

Thanks

StartJob Start Sql execution: 05.01.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbo.DNN4_DMX_LongTexts'. 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) -- clean up Remarks that were filled with

 

by the HTML editor DELETE FROM dbo.DNN4_DMX_LongTexts WHERE [Text]='

 

'
EndJob End Sql execution: 05.01.02.SqlDataProvider file

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
03/31/2010 4:22 PM
Hi Gary,

The error tells me it is trying to upgrade an older version of DMX and that it has not found something that was supposed ot be there (DNN4_DMX_LongTexts). That could be because:

1. The connectionstrings are not in both places in the web.config where they should be.
2. Some elements did not migrate from SQL 2000 to 2008 (I doubt it and the object mentioned was introduced later)
3. There was a failure earlier on in installing/upgrading DMX.

DMX is known to run on SQL 2008 so that is not the error. But it looks like the data migration has had a hiccup along the way.

Peter
You are not authorized to post a reply.
Forums > Document Exchange > Installation and Activation Issues
© 2024 Bring2mind Terms Of UsePrivacy Statement