Wfdirchk.sql
Use wfdirchk.sql to check for the following conditions in your directory service data model:
- Invalid internal names that contain the characters '#', ':', or '/' in WF_USERS.
- Invalid compound names in WF_USERS or WF_ROLES.
- Duplicate names in WF_USERS or WF_ROLES.
- Multiple names in WF_USERS or WF_ROLES linked to the same row in the original repository.
- Missing display names in WF_USERS or WF_ROLES.
- Invalid Notification Preference or null email address if the Notification Preference is MAILTEXT, MAILHTML, or SUMMARY in WF_USERS or WF_ROLES.
- Invalid Status in WF_USERS.
- Rows in WF_USERS that do not have a corresponding row in WF_ROLES.
- Invalid internal names in WF_ROLES that contain the characters '#' or '/' or have a length greater than 30 characters.
- Invalid user/role foreign key in WF_USER_ROLES.
- Missing user/role in WF_USER_ROLES (every user must participate in its own role).
- Duplicate rows in WF_USER_ROLES.
Wfdirchk.sql should return no rows to ensure that your directory service data model is correct.
Use the script as follows:
sqlplus <user/pwd> @wfdirchk
