How can we help you today?

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

Shows the possible operations

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\CorruptEntitiesshows the corrupted templates as  CSV file

9.      Similarly, to check the instance in the System1, execute "Database CheckDataIntegrity System_1"
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.

example of templates

14.      Example for the orphan instances identified in a system

example of instances

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.

Schneider Electric UK

Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:
  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and contact centre
  • Where to buy
  • Get a Quote
  • Find our Offices
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • General Terms of Business
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
  • Preference Center