{"id":9136,"date":"2023-11-16T08:28:40","date_gmt":"2023-11-16T08:28:40","guid":{"rendered":"https:\/\/www.threesl.com\/blog\/?p=9136"},"modified":"2023-11-16T08:28:40","modified_gmt":"2023-11-16T08:28:40","slug":"project-administration-cross-reference-integrity-checks","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/project-administration-cross-reference-integrity-checks\/","title":{"rendered":"Project Administration – Cross Reference Integrity Checks"},"content":{"rendered":"

This blog follows on from our previous blog about project integrity checks<\/a>. Here we discuss a second project integrity tool which concerns the validity of cross references. This can be found in the Project<\/strong> ribbon:<\/p>\n

\"Project
Cross Reference Integrity Check option<\/figcaption><\/figure>\n

As with the Item Integrity Checker, the user MUST<\/strong><\/em> have ACCESS_BYPASS<\/strong> privilege to instigate any changes to the data. It is highly recommended that there are no other active users in the database.<\/p>\n

In fact, we would recommend locking a project using Project Manager<\/a> prior to using these utilities if you cannot be certain that other users would not try to log on during the process of running the utilities.<\/p>\n

Also, it is highly recommended to back up your database and\/or create a snapshot prior to instigating any changes using these utilities.<\/p>\n

For details about snapshots, refer to the following help page<\/a>.<\/p>\n

Cross Reference Integrity Checker<\/h2>\n

The Cross Reference Integrity Checker<\/a> consists of several checks that compare the links found in the database with the rules specified in Project Setup. Some of the issues found can be repaired with a single click.<\/p>\n

There are some checks that would not be required in normal Cradle usage but could appear as a result of an import. An example of this could be due to the fact that Cradle has the ability to import cross references independently of any item types and specify the from<\/em> item and the to<\/em> item. These items referred to in the cross references by their identity attribute, might not exist in the database so this is an example of a dangling cross reference.<\/p>\n

Cross Reference Integrity Checks<\/h3>\n

Other checks are:<\/p>\n