|Applies To||RSA ClearTrust 5.5|
RSA ClearTrust 5.5.1
RSA ClearTrust 5.5.2
Sun Solaris 2.9
Microsoft Windows 2000
|Issue||ORA-00942: table or view does not exist|
INSERT INTO WEB_SERVER_TYPE VALUES ('Apache')
ERROR at line 1:
ORA-00942: table or view does not exist
|Cause||In the phase "Installing the RSA ClearTrust Data Schema", the first step is to run a script to create the RSA ClearTrust tables, indexes, and bootstrap data. If you have not followed the instructions and logged in as "CT_OWNER", the majority of the script will complete correctly, but it will return 16 errors starting with the sample shown below. If you are logged in with another username, even if the user has greater privileges than the CT_OWNER (e.g. you are logged in as "system"), these errors would occur. The problem is that since you are not logged in as "CT_OWNER", the particular lines generating errors would need to include a "CT_OWNER prefix for the particular table name. For example:|
INSERT INTO CT_OWNER.WEB_SERVER_TYPE VALUES ('Apache')
|Resolution||The mistake is easy to rectify. A second script is provided to remove the tables created by the create script. Stay logged in as the current user, run the removal script, then redo the creation steps logged in as CT_OWNER. For example, with the OracleDropCT.sql script copied from the ClearTrust server in <CT_HOME>/data_adapters/sql/oracle to the oracle server (in this example copied to c:\oracle):|
REM logged in as the 'wrong' user for example "system"
This should show removal of the objects.
This should now run with no errors.
|Legacy Article ID||a22776|