11
Oracle SQL Analyze Services Messages

VMQ-00001 to VMQ-00055 Messages

VMQ-00001: Cannot use Hint Wizard here. Use Create Like to duplicate this SQL, then use Hint Wizard.

Cause: The Hint Wizard was launched on a read-only SQL statement. A SQL statement cannot be edited after an explain plan has been generated for it.

Action: Select File=>Create Like to create a copy of the statement on the Navigator Tree. Select the copy, then use the Hint Wizard with this file.

VMQ-00002: Hint Wizard will not add hints to INSERT, UPDATE or DELETE statements.

Cause: The Hint Wizard was launched on a statement containing INSERT, UPDATE, or DELETE statements. These statements are not currently supported.

Action: No action to be taken.

VMQ-00003: Not a DML (DELETE, INSERT, SELECT, UPDATE) statement. Cannot get the explain plan.

Cause: The statement does not use Data Manipulation Language (DML) commands. Statements that do not use DML commands do not have explain plans.

Action: This statement cannot currently be analyzed or tuned through Oracle SQL Analyze.

VMQ-00004: Unable to fetch database session parameters.

Cause: Oracle SQL Analyze could not view the parameters for the connected database. This might be because Oracle SQL Analyze does not support databases before Release 7.2, or because the V$parameter table is corrupted.

Action: If the database is Release 7.2 or above, contact Oracle Worldwide Customer Support.

VMQ-00005: Internal Error.

Cause: An internal error occurred.

Action: Retry the operation. If this message continues, contact Oracle Worldwide Customer Support.

VMQ-00006: Cannot validate SQL Syntax error: <string>.

Cause: A SQL statement was generated that was not syntactically correct.

Action: Review the statement for syntactical errors. Check the statement for possible spelling and typing errors.

VMQ-00007: This session must be connected to perform this operation.

Cause: The operation tried to access an unconnected database.

Action: Expand the database node in the Navigator window. This will connect the database and allow operations to be performed upon it.

VMQ-00008: The list of hints in the selected subquery cannot be parsed.

Cause: The query has an incorrect hint syntax.

Action: Review the hint syntax or remove hints altogether. Hints can be added to the statement with the Hint Wizard, which automatically verifies the syntax.

VMQ-00009: Internal error: invalid parameters specified for ANALYZE command

Cause: The percentage specified for the Estimate Statistics option of the Tuning Wizard was not an integer between 1 and 100.

Action: Specify a percentage between 1 and 100.

VMQ-00010: Unable to find Oracle8 ObjectID.

Cause: Oracle SQL Analyze could not locate the Oracle database.

Action: The database might be corrupted. Contact Oracle Worldwide Customer Support.

VMQ-00011: Unable to set parameter <parameter> at the session level.

Cause: An attempt was made to edit one of database parameters that cannot be changed from within Oracle SQL Analyze.

Action: Close Oracle SQL Analyze and change the parameter using Instance Manager, or by editing the init.ora file manually.

VMQ-00012: The alias or table name you chose conflicts with another name in the list.

Cause: The alias or table name chosen conflicts with another name in the list.

Action: Choose a valid alias or table name.

VMQ-00017: Cannot validate SQL statement.

Cause: Oracle SQL Analyze could not find a table or view referred to by the statement. An identifier in the SQL statement could not be resolved.

Action: Check to be sure you have privileges for that object.

VMQ-00018: An internal data format error occured. Can't proceed with the requested operation.

Cause: A data inconsistency within Oracle SQL Analyze triggered an internal error.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00019: No bind variables have been specified because the bind variables dialog was canceled.

Cause: The bind variables dialog was canceled before bind variables could be specified.

Action: Retry the operation and do not cancel the bind variables dialog.

VMQ-00020: Object <object> exists, but is not a table or a view.

Cause: One of the identifiers in the SQL statement was not a table or a view. The operation called for by the SQL statement requires a table or view (for example, the statement may have tried to SELECT from an index).

Action: Check the SQL statement and correct the identifier.

VMQ-00021: The object <object> exists, but it is not the expected object type.

Cause: Oracle SQL Analyze could not read the object. The database might be corrupted.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00022: The following value is inappropriate for this bind variable: <value>.

Cause: A non-numeric value was supplied for a numeric bind variable type.

Action: Enter a number for the bind variable value.

VMQ-00023: Unable to determine the type of the object <object>.

Cause: Oracle SQL Analyze could not read the specified object. The database might be corrupted.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00026: Unable to create PLAN_TABLE

Cause: Oracle SQL Analyze could not create a plan table either because the appropriate CREATE TABLE privileges are not available, or because there is not enough room on the specified disk.

Action: Check to make sure you have CREATE TABLE privileges, and that the specified disk has enough space.

VMQ-00027: Unable to drop PLAN_TABLE

Cause: The plan table was the wrong version for the database. The appropriate access privileges may not be available.

Action: Consult with your database administrator (DBA) to drop the database.

VMQ-00028: Object not found error.

Cause: An attempt to validate a SQL query failed because the table or view referenced in the statement does not exist.

Action: Review the statement for syntactical errors. Check the statement for possible spelling and typing errors.

VMQ-00030: Tuning Wizard will not improve INSERT, UPDATE or DELETE statements.

Cause: The Tuning Wizard was launched on a statement containing INSERT, UPDATE, or DELETE statements. These statements are not currently supported.

Action: No action to be taken.

VMQ-00031: No session parameters can be set at the session level for Oracle 7.2 or earlier.

Cause: An attempt was made to edit one of database parameters that cannot be changed from within Oracle SQL Analyze.

Action: Close Oracle SQL Analyze and change the parameter using Instance Manager or by editing the init.ora file manually.

VMQ-00032: Repository manager cannot validate repository.

Cause: The Repository Manager failed or the repository was corrupted.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00033: Unable to validate SQL statement: <string>.

Cause: An identifier in the SQL statement could not be resolved unambiguously.

Action: Check your statement for syntax, spelling, or typing errors.

VMQ-00034: The Oracle Enterprise Manager SDK is unavailable. The Oracle Enterprise Manager Console must be running while Oracle SQL Analyze is being used.

Cause: Either Oracle SQL Analyze was started before Oracle Enterprise Manager was started, or Oracle Enterprise Manager was closed while Oracle SQL Analyze was running.

Action: Re-start Oracle Enterprise Manager and leave it running while Oracle SQL Analyze runs.

VMQ-00035: Oracle Enterprise Manager SDK call failed: <string>.

Cause: The Oracle Enterprise Manager console failed for an undetermined reason.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00036: Oracle Enterprise Manager SDK array access failed.

Cause: The Oracle Enterprise Manager console failed for an undetermined reason.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00037: Session connection is being attempted on this database. Either stop this operation or wait until it finishes.

Cause: A second attempt to connect a database was made while the first attempt was still processing.

Action: Avoid clicking repeatedly on the database node. Stop this operation using something >= Cancel This Operation, or wait until it finishes.

VMQ-00038: You cannot delete this SQL item because there is a background operation in progress on it. Please cancel the current Explain Plan or Execute operation before deleting it.

Cause: A SQL statement could not be deleted because an Explain Plan or Execute option was being run against it.

Action: Cancel the operation, then delete the statement.

VMQ-00039: SQL statement labels must be between 1 and 255 characters long.

Cause: A SQL statement label was entered incorrectly.

Action: Enter a new label that is not empty and contains fewer that 256 characters.

VMQ-00040: The Explain Plan operation could not complete because the SQL statement contains ambiguous references.

Cause: The Choose an Owner dialog was canceled.

Action: Retry the Explain Plan operation. Do not cancel the dialog while the operation is in progress.

VMQ-00041: The SQL statement could not be validated because it contains ambiguous references. The 'Choose An Owner' dialog was canceled.

Cause: The Choose an Owner dialog was canceled.

Action: Bring up the Hint or Tuning Wizard. When the Choose An Owner dialog is opened, do not cancel the dialog until you have chosen the appropriate owner.

VMQ-00042: The 'Connect to Repository' operation cannot be canceled. Please wait for it to complete or exit Oracle SQL Analyze.

Cause: An attempt was made to cancel a repository connection while it was in progress.

Action: Wait for the operation to complete or exit Oracle SQL Analyze.

VMQ-00043: The 'Load Repository' operation cannot be canceled. Please wait for it to complete or exit Oracle SQL Analyze.

Cause: An attempt was made to cancel a repository connection while it was in progress.

Action: Wait for the operation to complete or exit Oracle SQL Analyze.

VMQ-00044: The Oracle RDBMS version is unavailable.

Cause: SQL Analyze cannot locate the Oracle RDBMS version it is expecting.

Action: Contact Oracle Worldwide Customer Support.

VMQ-00045: Unable to drop this SQL statement.

Cause: This database is either not connected or busy.

Action: Cancel the current operation on this database.

VMQ-00047: Cannot access private database link.

Cause: An attempt was made to access a database link that was created by another user. To access this link, Preferred Credentials must be set in the database.

Action: If possible, set up Preferred Credentials in the target database.

VMQ-00048: This service has already been discovered.

Cause: An attempt was made to discover a database that was previously discovered.

Action: Specify a different database.

VMQ-00049: Unable to contact the Oracle Management Server.

Cause: The Oracle Management Server may not be running or the repository may be unavailable.

Action: Ensure that the Oracle Management Server is running and that the repository database is available.

VMQ-00050: Internal error: unable to obtain repository credentials from the Oracle Management Server.

Cause: The client machine cannot obtain the repository credentials from the Oracle Management Server.

Action: Verify that the Oracle Management Server is running and that the client machine has access to it.

VMQ-00057: Error loading repository.

Cause: An error occurred while attempting to load this repository.

Action: Contact Oracle Worldwide Customer Support.