Oracle Database Errors or Warnings from Error ORA-40027 to ORA-40108


ORA-40027: Target attribute has more than two distinct values
Cause: Generalized Linear Models only support binary classification.
Action: Consolidate target values into two distinct categories.
ORA-40028: solution to least squares problem could not be found
Cause: Unable to find solution because the predictor build data were not properly scaled.
Action: Standardize the predictor build data by enabling auto prep.
ORA-40101: Data Mining System Error string-string-string
Cause: An internal system error occured during a data mining operation.
Action: Contact Oracle Support Services.

ORA-40102: invalid input string for data mining operation string
Cause: The input parameter is either null or invalid for the given operation.
Action: Provide a valid value. Check range for NUMBER parameters.
ORA-40103: invalid case-id column: string
Cause: The column designated as case-id is not of one of CHAR, VARCHAR2, NUMBER data type. Case-id columns of type CHAR and VARCHAR2 must be of length less than or equal to 128 bytes.
Action: Change the schema of your input data to supply a case-id column of appropriate data type and/or length.
ORA-40104: invalid training data for model build
Cause: The training data provided in the reported table is unsuitable for build, either because it is empty, has unsuitable data, or the schema of the table does not match the input specifications.
Action: Inspect the training data and correct the contents/schema as appropriate.

ORA-40105: input data incompatible with model signature
Cause: The data provided for this post-build operation is in format different from that used for model build.
Action: Provide data whose attribute data types match the build data. Input data attributes must have the same data types as those described in the model signature for the model.
ORA-40106: positive target value not specified for computing Lift
Cause: Positive target value has not been specified for Lift.
Action: Provide a positive target value for the Lift operation.
ORA-40107: operation requires string option to be installed
Cause: The specified option has not been installed with the RDBMS.
Action: Install the reported option and retry the operation.
ORA-40108: input data contains too few distinct target (string) values
Cause: At least two distinct target values are required for Build.
Action: Provide counter-example target values in the input data.

Above are list of Oracle Database Errors or Warnings from Error ORA-40027 to ORA-40108 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *