Identity Suite Virtual Appliance produces errors "Workpoint db already exists..."

Document ID : KB000013073
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When using an Oracle Database as an External Database for Identity Suite 14.0 Virtual Appliance, a message shows up as “Workpoint db already exists...”. How can I run these commands successfully?

dbutil.bat -ven oracle -d <service_name> -h <host> -cs -u WPDS -p <password> -su <system_user> -sp <system_password>

dbutil.bat -ven oracle -d <service_name> -h <host> -c_wp -u WPDS -p <password> -su <system_user> -sp <system_password>

Answer:

These commands do not function the same:

dbutil.bat -ven oracle -d <service_name> -h <host> -cs -u WPDS -p <password> -su <system_user> -sp <system_password>
dbutil.bat -ven oracle -d <service_name> -h <host> -c_wp -u WPDS -p <password> -su <system_user> -sp <system_password>

To check what these parameters do, run dbutil in the command line to see accepted input.

The first line with the “-cs” switch creates the Workpoint schema (user). The second line with the “-c_wp“ switch populates the tables on this schema. After executing the second line, the message “Workpoint db already exists...” is displayed. This message be safely ignored and there is really no need to run the second line at all. Not including the second line will not impact the system in any way. The deployment succeeds regardless of this error, and the Identity Governance application will populate the WPDS tables when it starts.

This behavior has been fixed in VA-CP1.