We are using Promise CE update 3 - 10.03.00.35
One user gets the following prompt on startup, and cannot use Promise
I have several questions,
EDITPossible answer to question 3, found a table of Application and Database versions here Project Database Version - Substation But not sure if it is applicable to Promise as well as Substation. The answer to 2 is also on that page.
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. Below are the answers to your questions
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 promiseSELECT * 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
Answer Verified By: Doug Murray
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?
Promis•e CONNECT Edition Update 5 - Version 10.05.00.38
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. Hope the above suggestion helps.Regards,Satish Saptasagar