Cannot create New Test Case

Symptom

When using SSMA tester while creating New Test Case users may see the below error.

Error:

Installed data not found.Error occurred during following command execution:

CREATE USER ssmatester oracle IDENTIFIED BY TESTER

Tester database installation failed

Cause

SSMA Tester requires ssmatester_oracle schema to be installed on the oracle database.

Resolution

SSMA Tester requires ssmatester_oracle schema to be installed on the oracle database. The error message usually comes when the execution of the command ‘CREATE USER ssmatester_oracle IDENTIFIED BY TESTER’ failed because of insufficient privileges of the user. Try to execute this command manually in Oracle database with the same user with which you are connecting to SSMA and grant all the required privileges and check with SSMA again. You must have Oracle privileges to create a new user and create objects in the schema of this user. More information about testing is provided in the ‘Testing Migrated Database Objects’ section in the help menu (F1) of the SSMA tool.

More Information

Article Id: KBO2SS1009

Applies to

SSMA 2005 for Oracle