000021407 - ORA-00942: table or view does not exist

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000021407
Applies ToRSA ClearTrust 5.5
RSA ClearTrust 5.5.1
RSA ClearTrust 5.5.2
Oracle 9i
Sun Solaris 2.9
Microsoft Windows 2000
IssueORA-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
CauseIn 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')
ResolutionThe 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"
SQL>@c:\oracle\OracleDropCT.sql

This should show removal of the objects.

SQL>
connect CT_OWNER/ct_owner@CT
Connected.
SQL>@c:\oracle\OracleCreateCT.sql

This should now run with no errors.
Legacy Article IDa22776

Attachments

    Outcomes