Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrading to 8.00.01: Could not find stored procedure 'dbo.UpdateDatabaseVersionIncrement'Upgrading to 8.00.01: Could not find stored procedure 'dbo.UpdateDatabaseVersionIncrement'
Previous
 
Next
New Post
4/26/2016 9:06 AM
 
If you tell us what the errors are we may be able to help. Saying (for example) "I get IIS Application errors that prevents me from continuing." means we have to guess.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
4/26/2016 1:32 PM
 

The error I get from the Upgrade Wizard is: Could not find stored procedure 'dbo.UpdateDatabaseVersionIncrement

I have finally located the File Leo suggested,and rerun 08.00.01.01.SqlDataProvider 

I tried to run as a query in SQL and I get the following error:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near 'Increment'.

This error message continues for each line that contains: a }.

The last block in the log.resources file is the following:

2016-04-26 13:19:38,342 [d0iisintranet1][Thread:7][ERROR] DotNetNuke.Data.SqlDataProvider - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Journal_Get' in the database.

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)

ClientConnectionId:58a370ba-1496-48c0-a878-bcdc6ba4490d

Error Number:2714,State:3,Class:16

 

Hope this helps, let me know if you would like to look at anything else.

 

 
New Post
4/27/2016 4:40 AM
 
This won't be your underlying problem. You need to edit out the tokens. https://www.dynamisys.co.uk/ArticlesD...

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
4/28/2016 9:24 AM
 

Thank you Richard, I will give it a go and find\replace all instances of {databaseOwner}{objectQualifier}  with dbo.

Any chance there is a release out there without the tokens? 

 
New Post
4/28/2016 9:31 AM
 
I'd say no chance whatsoever.

If there were a release without the tokens then by definition it's buggy. Maybe no-one wants to create a new install with the prefixes, but there are loads of existing installs already out there and they need to be supported.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrading to 8.00.01: Could not find stored procedure 'dbo.UpdateDatabaseVersionIncrement'Upgrading to 8.00.01: Could not find stored procedure 'dbo.UpdateDatabaseVersionIncrement'


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out