How to resolve database version mismatch? / Database version [10.0.11] Does not match application version [10.0.21]

Hi Dough,

The message shown in the above images seems to be from user who is using Latest version of Promis.e which is Promis.e CONNECT Update 5 as the database version will be updated to 10.0.21 for database that are configured with Promis.e CE U5. And the database version in the SQL seems to be 10.0.11 which is used by Promis.e CONNECT Update 3. You can refer the below Wiki Link for details.

1.When ever a version of Promis.e is upgraded the database version also changes, hence when the user tries to launch Promis.e after updating there will be miss match in database version and Promis.e will prompt to upgrade the database to be able to user with the current version.   

Doug Murray said:

What has caused the mismatch version, if we all have the same application version?

2. You can check the version of database by running the script on database that is provided towards the end of wiki link, share the scrip only below for your reference that needs to be executed.

use promise
SELECT * FROM fn_listextendedproperty ('Version', 'user', 'dbo', 'table', 'project', default, default)

Doug Murray said:

How do I know which application version uses which database version? 

3. Again refer the above Wiki Link provided which has details on the same.

Doug Murray said:

If that user upgrades the database, how will it effect the other users?

4. If an user upgrades a database with latest version of Promis.e and if other users are using same database but on a older versions. The user using older version will not be able to use the database or work on project that are configured with that database. Hence it is suggested that database should be upgraded only when all the user are ready to upgrade to latest version. if somebody needs to use new version they can simply create new Project database on updated Promis.e. 

Doug Murray said:

How do I check which version database is on the server? (I know from the above image it's 10.0.11, but I'd like to know how to check in the future)

Hope the above details help with the issue you are facing.

Regards,
Satish Saptasagar

Hi Satish,

Since updating to version 10.05.00.38 all users get the following error twice when opening a drawing.

Also another error that states PartsDB Error Message: Could not find stored procedure 'CDT_CleasrCdtTables'

What has caused this issue and how do we resolve it?

Thanks,

DM

Hi Satish,

Since updating to version 10.05.00.38 all users get the following error twice when opening a drawing.

Also another error that states PartsDB Error Message: Could not find stored procedure 'CDT_CleasrCdtTables'

What has caused this issue and how do we resolve it?

Thanks,

DM

Hi Dough,

As seen in the Error Message there might be some stored procedure missing in the database. Please update the database using the script method and check if you are able to get Promis.e to work correctly after updating the database. You can refer the below Wiki Link for steps to follow for updating the Database using Script Method.

Hi Satish,

We updated database schema using the script method and it has resolved our issues.

Thanks

DM