| Previous | Next |  | Contents | Index | Glossary

## 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 e-mail 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

| Previous | Next |  | Contents | Index | Glossary