Oracle Expert Services Messages

XP-07000 to XP-07999: Oracle Expert Error Messages

XP-07000: The token, 'name' is ambiguous at or near line number. Expecting 1 of the following items: name.

Cause: SQL text being parsed contains invalid syntax that may have been introduced during collection or editing of workload or schema data.

Action: Correct the SQL text and retry the operation.

XP-07001: The value must be greater than or equal to number.

Cause: A numeric value was entered that is less than the lower limit.

Action: Enter a value greater than the limit specified.

XP-07002: The value must be less than or equal to number.

Cause: A numeric value was entered that is greater than the upper limit.

Action: Enter a value less than the lower limit specified.

XP-07003: C runtime error: error.

Cause: A C programming language call has failed. The additional ERROR text will provide information on the specifics of the failure. These types of errors typically indicate a problem with either the installation or the operating system settings, such as virtual memory.

Action: Use the additional information provided to determine the cause of the problem.

XP-07004: Cannot create a temporary or log file.

Cause: An error occurred while attempting to create a file.

Action: Retry the operation.

XP-07005: The name has dependents and cannot be deleted.

Cause: You attempted to delete an object before deleting its dependents.

Action: First delete the object's dependents then retry the operation.

XP-07006: Cannot instantiate a rule without an object id.

Cause: You attempted to create a copy of a rule without an associated object/owner. This is an unexpected system error.

Action: Log a bug report, including the contents of the XP_USER_RULE table from the EM repository.

XP-07007: Cannot insert a base rule with an object id.

Cause: You attempted to load the default rules, and a rule creation was attempted without an associated object/owner. This is an unexpected system error.

Action: This error indicates a logic error or installation problem with the Oracle Expert Service or client. Please log a bug report specifying the operating system, EM version, and database version of the repository.

XP-07008: Cannot remove a rule without an object id.

Cause: You attempted to remove a copy of a rule that does not have an associated object/owner. This is an unexpected system error.

Action: Log a bug report, including the contents of the XP_USER_RULE table from the EM repository.

XP-07009: Cannot delete a base rule with an object id.

Cause: You attempted to clear the default rules from the Oracle Expert Services repository, and a rule was found without an associated object/ owner. This is an unexpected system error.

Action: Log a bug report, including the contents of the XP_USER_RULE table from the Oracle Expert Services repository.

XP-07010: The collection was aborted.

Cause: You cancelled a collection while it was in progress.

Action: None.

XP-07011: The current operation was cancelled for name.

Cause: You cancelled an operation while it was in progress. The session represents either the main application or a dependent operation.

Action: None.

XP-07012: A database error has occurred: error.

Cause: An Oracle server error has occurred while attempting to access the Oracle Expert Services repository or the target tuneable database. The ERROR text provides the specific Oracle server error message.

Action: If the error indicates an environmental problem, e.g. the instance is not started, then correct the problem.

XP-07013: No rows were deleted: name.

Cause: The rows you specified for deletion were not found.

Action: None.

XP-07014: The database has not been started: error.

Cause: You attempted to access a database for which the instance has not been started. The ERROR message contains additional detail from the Oracle server error message.

Action: Start the instance.

XP-07015: An invalid connect string was used to connect to the database: name.

Cause: You attempted to connect to a database but did not supply valid logon credentials.

Action: Supply valid logon credentials.

XP-07016: A database error has occurred: error error.

Cause: A server error has occurred while attempting to access the Oracle Expert Services repository or the target tuneable database. The ERROR text provides the specific Oracle server error message.

Action: If the error indicates an environmental problem, e.g. the instance is not started, then correct the problem.

XP-07017: The name column generated the following return code: code error.

Cause: A low-level data access/OCI error has occurred while accessing a specific column in the database.

Action: This error indicates a logic error or installation problem with the Oracle Expert Services. Please log a bug report specifying the operating system, Oracle Expert Services version, database version of the repository, the return code of the error message reported, and the definition of the column where the failure occurred.

XP-07018: The number of the return variables exceeds the number of the items in the select list.

Cause: An internal logic error has occurred in the data access layer.

Action: This error indicates a logic error or installation problem with the Oracle Expert Services. Please log a bug report specifying the operating system, the Oracle Expert Services version, the database version of the repository, and the operation being performed when the failure occurred.

XP-07019: There are not enough return variables to store all items in the select list.

Cause: An internal logic error has occurred in the data access layer.

XP-07020: Unable to convert input data due to a datatype mismatch.

Cause: You supplied a value for a numeric field that contains non-numeric characters.

Action: Supply only numeric characters.

XP-07021: The device is full.

Cause: An attempt was made to write data to a disk that has no more free space available.

Action: Make space available on the device, or move the program/files to another device.

XP-07022: The end of the input file stream was reached.

Cause: A record cursor returned no more rows.

Action: None.

XP-07023: The end of the file was reached.

Cause: A file read indicated end-of-file.

Action: None.

XP-07024: The Oracle Trace collection class name is invalid.

Cause: You attempted to collect an Oracle Trace collection that contains obsolete or unsupported data items.

Action: Review the release notes for version requirements/dependencies on Oracle Trace. If you feel that your current configuration is supported, please log a bug report specifying the operating system, EM version, database version of the repository, the return code of the error message reported, and any log files which may have been generated during the import which contain additional information.

XP-07025: The product has exited with an unexpected error.

Cause: The Oracle Expert Services subsystem (workbench) encountered a severe system error.

Action: Try the operation again. Attempt to eliminate any causes which may be environmental. If you feel that your current environment is satisfactory, please log a bug report specifying the operating system, Oracle Expert Services version, database version of the repository, and the operation which was in progress at the time of the failure.

XP-07026: Exiting with a fatal error.

Cause: A severe error condition has occurred and the Oracle Expert Services cannot continue the current session.

XP-07027: This feature has not been implemented.

Cause: You attempted to access a feature/function in Oracle Expert Services that is not yet available in the current version.

Action: Please log a bug report specifying how you were able to get this error message.

XP-07028: The file name is already open.

Cause: An attempt was made to write to a file that has already been opened by another user or process.

Action: Make sure the file is not in use and retry operation.

XP-07029: The file name was not found.

Cause: An attempt was made to access a file that does not exist.

Action: Make sure that the requested file does exist and retry the operation.

XP-07030: The file name is protected against access.

Cause: An attempt was made to open a file which is not accessible as a result of privilege or security problems.

Action: Resolve the file access problem and retry operation.

XP-07032: The repository is incompatible with name number and cannot be accessed.

Cause: An attempt was made to run a version of Enterprise Manager that is not compatible with the version of the product that created the repository being accessed.

Action: Delete the repository and re-execute Enterprise Manager.

XP-07033: The name is marked as incomplete.

Cause: An object was found in the Oracle Expert Services repository that is incomplete as a result of a collection being interrupted or cancelled.

Action: Delete this object.

XP-07034: Overflow while converting an Oracle number to an integer.

Cause: A logic error has occurred in the data access layer.

XP-07035: The date/time date is invalid.

Cause: A date/time was specified using an incorrect format.

Action: Supply a valid date/time string.

XP-07036: The logical device name is missing a location.

Cause: You have created a logical device in the Oracle Expert Services repository without providing a physical location for the files. Oracle Expert Services requires this be provided.

Action: Supply a location for the logical device.

XP-07037: The token 'name' is not a valid number.

Cause: The Oracle Expert Services parser has encountered a token in an input file that was expected to be a number, but was not.

Action: Correct the file and retry the operation.

XP-07038: The token 'name' is not a valid integer.

Cause: The Oracle Expert Services parser has encountered a token in an input file that was expected to be an integer, but was not.

Action: Correct the file and retry the operation.

XP-07039: The operation is invalid.

Cause: A system error has occurred while attempting a specific operation.

XP-07040: The quoted string name contains unprintable characters.

Cause: A literal text item was found in SQL text that contains unprintable characters. Oracle Expert Services cannot display or print this text item.

Action: None.

XP-07041: An Oracle Expert Services repository has not been created for this schema.

Cause: You attempted to connect to the Oracle Expert Services repository, but the schema accessed using the logon credentials provided is not an Oracle Expert Services repository.

Action: Ensure the logon account used contains/owns an Oracle Expert Services repository schema.

XP-07042: The name contains entities that cannot be validated.

Cause: An object was collected by the Oracle Expert Services that contains references to external entities which could not be located in the Oracle repository.

Action: Collect items referenced by the object being collected.

XP-07043: The database contains entities that cannot be validated.

Cause: A database was collected by Oracle Expert Services that contains references to external entities which could not be located in the Oracle repository.

Action: Collect items referenced by the object being collected.

XP-07044: The naming template name contains invalid characters.

Cause: A naming template was supplied that contains characters that could not be used in the name of the object constructed using the template.

Action: Remove the offending characters.

XP-07045: The type name is invalid.

Cause: An instance parameter was found associated with an unknown grouping. This is an unexpected system error.

XP-07046: The name cannot be validated error.

Cause: An object was collected by Oracle Expert Services that contains references to external entities which could not be located in the Oracle Expert Services repository.

Action: Collect items referenced by the object being collected.

XP-07047: Line number number from the file name is longer than number characters.

Cause: Oracle Expert Services encountered text in an import file (SQL or XDL) that is longer than the largest allowable buffer length as specified in this message.

Action: Break the long line into separate smaller lines.

XP-07048: The message was not found.

Cause: Oracle Expert Services was unable to find an error message. This is an unexpected system error.

Action: This error indicates a logic error or installation problem with Oracle Expert Services. Please try to re-install the product. If this does not correct the problem, then log a bug report specifying the operating system, the Oracle Expert Services version, the database version of the repository, and the operation being performed when the failure occurred

XP-07049: The table, name, was not found in the Oracle Trace database.

Cause: Oracle Expert Services could not find a required table in the Oracle Trace database identified for workload collection.

XP-07050: No information was found for the repository.

Cause: An incomplete Oracle Expert Services schema was found when connecting to the repository.

Action: Re-install the Performance Pack, and recreate the Oracle Expert Services repository by issuing the following command from a DOS window : VOBSH -c "repos user/ repos password" -o DROP -p " Oracle Expert"

XP-07051: No Oracle Trace collection information was found.

Cause: The Oracle Trace database did not contain any collections, and no data will be collected by Oracle Expert Services.

Action: None.

XP-07053: The name was not found.

Cause: An attempt was made to select an object from the Oracle Expert Services repository that does not exist.

Action: None.

XP-07054: The specification name contains an invalid device name.

Cause: A filename was provided that contains an invalid disk or device name.

Action: Correct the device reference and retry the operation.

XP-07055: The database name is not an Oracle Trace collection.

Cause: A database connect string was provided for workload collection, and the schema accessed did not contain Trace data.

Action: Provide an Oracle Trace database.

XP-07056: An internal error occurred while converting an Oracle number.

Cause: A logic error has occurred in the data access layer.

Action: This error indicates a logic error or installation problem with Oracle Expert Services. Please log a bug report specifying the operating system, the Oracle Expert Services version, the database version of the repository, and the operation being performed when the failure occurred

XP-07057: Overflow while converting a machine-format number to an Oracle number.

Cause: A logic error has occurred in the data access layer.

XP-07058: The name already exists.

Cause: An attempt was made to create an object in the Oracle Expert Services repository using the name of an existing object of the same type.

Action: Provide a unique name, or delete the existing object from the Oracle Expert Services repository.

XP-07059: The value 'number' is out of range of number to number for the name.

Cause: A numeric value was supplied for the specified attribute that is not within the required range of values for the attribute.

Action: Supply a number within the required range.

XP-07060: The value is out of the range of number to number.

Cause: A numeric value was supplied for the specified attribute that is not within the required range of values for the attribute.

Action: Supply a number within the required range.

XP-07061: The value is less than the minimum of number.

Cause: A value was entered for a numeric attribute that is less than the required minimum.

Action: Enter a value greater than the required minimum.

XP-07062: The value is greater than the maximum of number.

Cause: A value was entered for a numeric attribute that is greater than the required maximum.

Action: Enter a value less than the required maximum.

XP-07063: An SQL parser stack overflow occurred.

Cause: A serious error has occurred in the Oracle Expert Services SQL parser.

XP-07064: Found 'name' at or near line number, column number. Expecting 1 of the following items: name

Cause: SQL text parsed during the collection or editing of workload or schema data contains invalid syntax.

Action: Correct the SQL text and retry the operation.

XP-07065: The name is out of range at line number.

Cause: A workload importance or frequency was found that is outside of the range allowed by Oracle Expert Services while collecting workload from an XDL file.

Action: Modify the offending value to be within the allowable range and retry the operation.

XP-07066: Reached unexpected end of statement at or near line number.

Cause: While parsing a SQL or XDL statement, Oracle Expert Services encountered the end of statement, usually a ';' when more data was expected.

Action: Correct the statement and retry the operation.

XP-07067: The view request, name, cannot be modified or deleted.

Cause: An attempt was made to modify or delete a request (SQL statement) that exists as a result of a view.

Action: Delete the actual view to remove this statement.

XP-07068: There is already an existing database connection to the Oracle Expert Services repository.

Cause: You attempted to connect to the Oracle Expert Services repository more than once in the current session.

Action: Discontinue the previous session before continuing with this operation.

XP-07069: There is no existing connection to the repository database.

Cause: An attempt was made to access data in a tunable database where no previous connection to that database was made. This is an unexpected system error.

XP-07070: Attempt to create an object in schema 'name' while collecting schema 'name'.

Cause: An attempt was made to create an object in a schema that is currently being collected.

Action: Wait until the collection is complete, or cancel it before attempting this operation.

XP-07071: Attempt to create statistics in schema 'name' while collecting schema 'name'.

Cause: A schema name was specified on the schema collect options page for schema collection, but a schema of another name was found in the schema statistics file.

Action: If the statistics are to be used for the schema name specified then edit the file and change the name.

XP-07072: The name already exists in name.

Cause: An attempt was made to create a child object using the same name as that of an existing child object.

Action: Provide a unique name.

XP-07073: The name was not found while validating the name.

Cause: Oracle Expert Services could not resolve an external reference within a SQL statement. An external reference must either be a valid workload request, or DDL statement within the Oracle Expert Services repository.

Action: Ensure that all entities referenced are collected and validate the object again.

XP-07074: Dangerous string operation attempted. name

Cause: This is an Oracle Expert Services internal error.

XP-07075: Invalid operation; string is locked. name

Cause: This is an Oracle Expert Services internal error.

XP-07076: Exceeded the allocated boundary of string.

Cause: A logic error has occurred in the string or buffer management subsystem.

XP-07077: An OCI error has occurred. message

Cause: An Oracle Call Interface (OCI) error occurred during a routine call.

XP-07078: String contains an unbalanced quotation.

Cause: A string was found in an input file with a missing beginning or end quote.

Action: Correct the problem and retry the operation.

XP-07079: A virtual memory error has occurred while accessing an internal buffer.

Cause: A logic error has occurred in the string or buffer management subsystem.

Action: This error indicates either a configuration problem, a logic error or installation problem with the Oracle Expert Services. First, increase the virtual memory setting on your operating system. If this does not resolve the problem, please log a bug report specifying the operating system, the Oracle Expert Services version, the database version of the repository, and the operation being performed when the failure occurred

XP-07080: Invalid operation; the internal buffer is locked.

Cause: A logic error has occurred in the string or buffer management subsystem.

XP-07081: Invalid operation; the internal buffer is unlocked.

Cause: A logic error has occurred in the string or buffer management subsystem.

XP-07082: The internal buffer has been truncated.

Cause: A logic error has occurred in the string or buffer management subsystem.

XP-07084: There is already an existing connection to the target database.

Cause: You attempted to connect to a target tunable database more than once in the current session.

Action: Discontinue the previous session before continuing with this operation.

XP-07085: There is no existing connection to the target database.

Cause: An attempt was made to access data in a tunable database where no previous connection to that database was made. This is an unexpected system error.

XP-07086: The name is out of range in the name template name.

Cause: A template was provided in the rules that generates a name longer than the longest allowable name.

Action: Modify the template to generate names shorter than the allowable limit.

XP-07087: The string, 'name', has more than number characters.

Cause: A text value was specified that is longer than the maximum allowable size.

Action: Shorten the text value.

XP-07088: A string-class buffer requires a larger return buffer.

Cause: This is an Oracle Expert Services internal error.

XP-07089: The operation is unsupported for this installation.

Cause: An unsupported SQL fragment was found while parsing a CREATE TABLE statement during schema collection from a SQL file.

Action: Remove the offending fragment and retry the operation.

XP-07090: The quoted string name is not terminated.

Cause: A quoted literal was found in a parsed string without a terminating close quote.

Action: Add the close quote to the string and retry the operation.

XP-07091: Unable to allocate virtual memory.

Cause: Insufficient memory exists on the platform where Oracle Expert Services is running.

Action: Increase the amount of memory.

XP-07092: The workload application 'name' contains invalid requests.

Cause: During workload collection, an application was found with requests (SQL statements) with external references to items that could not be found in the Oracle Expert Services repository.

Action: Collect objects (usually schemas) referenced by the workload and then validate the workload.

XP-07093: Unable to start duration collection. Last error code = error.

Cause: An attempt was made to start an instance duration collection that failed.

Action: The last error code should indicate an MS-Windows error. Resolve this error and retry operation.

XP-07094: Internal date format must be 'month/day/year hour:minute:second'.

Cause: An attempt was made to convert an input string to an internal date, but failed. The input string did not conform to the required date mask.

Action: Enter a date that conforms to the specified date mask.

XP-07095: Could not read all the required date fields.

Cause: An input string was specified for date conversion but did not contain all elements of a date.

Action: enter a date that contains all components 'month/day/year hour:minute:second'.

XP-07096: Unable to load resource dll : name

Cause: The system was unable to load the resource DLL specified.

Action: This error indicates a logic error or installation problem with Oracle Expert Services. First, re-install the Performance Pack by deinstalling the current Performance Pack, then re-installing. If this does not correct the problem, please log a bug report specifying the operating system, the Oracle Expert Services version, the database version of the repository, and the name of the DLL that was not found.