Category Archives: ORA Database Error Messages

ORA-36161: (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR

oracle

ORA-36161: (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR
Cause: The user specified the same variable as both an aggregation variable and a COUNTVAR
Action: Specify a different COUNTVAR

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36160: (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object

oracle

ORA-36160: (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object
Cause: The user tried to run the AGGREGATE or AGGCOUNT command or function on a scalar variable
Action: Specify a dimensioned variable instead

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword

oracle

ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword
Cause: The user specified AUTOCOMMIT but not AUTOUPDATE on the AGGREGATE command line, which is illegal
Action: Either also specify AUTOUPDATE or don't specify AUTOCOMMIT

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR

oracle

ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR
Cause: The user specified an illegal variable for use with FROM or FROMVAR on the AGGREGATE command line
Action: Specify a legal variable instead

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36154: (XSMXAGGR01) workspace object is not a data variable

oracle

ORA-36154: (XSMXAGGR01) workspace object is not a data variable
Cause: An object was specified on the Aggregate command line that was not a variable
Action: Specify a variable instead

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number

oracle

ORA-35952: (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number
Cause: This method requires the named dimensions to have the same number of values in status, but the user provided statuses of different lengths
Action: Relimit the dimensions so that their status lengths are the same

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-35917: (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string

oracle

ORA-35917: (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string
Cause: User attempted to apply the HIDE command to a model in an AW that has not been upgraded to the necessary compatibility level
Action: Make sure that the database is running in the appropriate compatibility mode, and upgrade the AW

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-35810: (XSINPUTERR) The command has requested more input than was supplied in the command string

oracle

ORA-35810: (XSINPUTERR) The command has requested more input than was supplied in the command string
Cause: The command required input that was not supplied in the string
Action: Reexecute the command with the required input

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-35756: (VCTODT02) ‘number’ is not a valid date because number is out of range for a year

oracle

ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year
Cause: n'%1p'
Action: none

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels

oracle

ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels
Cause: The nesting of table functions with the PREDMLCMD token populated with an OLAP DML expression that use the embedded SQL support to access another table function which contains a table functions with the PREDMLCMD token filled in with an OLAP DML expression that uses the embedded SQL support
Action: Reduce the level of nesting between table functions and OLAP DML embedded SQL support

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/