EcoStruxure Process Expert [2021]: How to use the Data integrity check feature ?
When the user creates the project or templates, many instances and facets are created in the application window. By any chance, if these instances/templates are not synched with the backend database the same objects will be corrupted and no longer useful, it can create other issues as well. This will come only when the user does not follow the right procedure to create instances/templates. The "data integrity check" feature will help the user to identify the corrupted objects when required and take the appropriate action.
This Knowledge base explains the steps to use the Data integrity check feature of EcoStruxure Process Expert.
NOTE: This feature is supported only for EcoStruxure Process Expert 2021
1. Login and Start the System Server.
2. When the server is ready, switch to maintenance mode (Ctrl + m and enter the password "support@Pes2016")
3. Run Database CheckDataIntegrity kernel command.
4. It will be showing all the possible commands available
5. Here, it shows that the database is having 3 systems in the project
6. So, the user can execute the command for Global templates and 3 systems available in the database. (ignore schema)
7. If the Template to are to be checked, execute the command "Database CheckDataIntegrity Global"
8. If corrupt templates are found, a message shows that the CSV file will be exported to C:\ProgramData\Schneider Electric\Process Expert 2020 R2\CorruptEntities
9. Similarly, to check the instance in the System1, execute "Database CheckDataIntegrity System_1"
10. If no orphan is identified, it shows Done
11. If corrupt templates are found, a message shows that the csv file will be exported to C:\ProgramData\Schneider Electric\Process Expert 2020 R2\CorruptEntities
12. Open CSV file from exported file location to view corrupted template/Instance details.
13. Example for Orphan template detection in the database.
14. Example for the orphan instances identified in a system
If you are finding the corrupted objects in your database, please try to remove and recreate the same.
Also, Contact the Support team immediately if the objects are unable to remove from the database.