Skip to main content
Nintex Community Menu Bar

Nintex Forms installer returns "Upgrade-NFService: Invalid object name 'DatabaseVersion'"

  • March 26, 2021
  • 0 replies
  • 252 views
  • Translate

Forum|alt.badge.img+8

Issue

When running a Nintex Installer, or running the Upgrade-NFService command in the SharePoint Management Shell, you receive the following message:

Upgrade-NFService : Invalid object name 'DatabaseVersion'

 

Resolution

To resolve this issue, you have two options:

Recreate the Nintex Forms database.
-Navigate to Central Administration > Nintex Forms Management (later changed to Nintex Administration) > Manage Database (later changed to Database Management) > Edit the Display Name of the database > Click 'Ok'. Your Nintex Forms are now mapped to a newly created database with the DatabaseVersion table.

Note: You may find that the Nintex Forms Database that has been in place is empty. This database is only used for Nintex Live Forms, Nintex Mobile Forms, and other external facing forms. If you do not leverage any external facing Nintex Forms, the above method will have no impact. If you do have data, please consider the next option.

Recreate the DatabaseVersion table.
-In SQL Server Management Studio, navigate to your Nintex Forms Database (called NintexFormsDB by default) > Right-click your Nintex Forms Database and select 'New Query'.
-Recreate the table with the following query:
CREATE TABLE [dbo].[DatabaseVersion] ([Version] [nvarchar](max) NOT NULL,[LastUpdated] [datetime] NOT NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Once the table is created, add an object to the table:
INSERT INTO [dbo].[DatabaseVersion] (Version, LastUpdated)VALUES ('1.0.0.0', 1/1/2019)

Once the above two queries have been executed, please run the Upgrade-NFService command. Once the command is executed, you will see the values in the DatabaseVersion table resemble the following:
Version	  LastUpdated4.1.0.0	  2019-09-18 22:49:17.227

 

Error Code

Upgrade-NFService : Invalid object name 'DatabaseVersion'

 

Additional Information

This message suggests that the DatabaseVersion table in the NintexForms database in your environment is missing. There is currently no known root cause of this table disappearing, but tends only to happen while updating Nintex Forms in On-Premises SharePoint environments.

 

Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings