QSM-01061: illegal query expression
Cause: An illegal query was specified. Specifically one of the following criteria was not satisfied: (a) All (non-constant, non-aggregate) SELECT expressions in the query should be made up of group expressions. (b) All column references in the HAVING clause should come from the GROUP BY expressions. (c) If there is an ORDER BY clause, then all column references should come from the GROUP BY or SELECT clause, depending on whether the query selects DISTINCT.
Action: Correct error in the syntax and rerun the query.
QSM-01062
Custom Search


More Oracle errors
NZE-28798Number of sub-keys application passes to bind does not match that in the key.
ORA-28275Multiple mappings for user nickname to LDAP distinguished name exist.
ORA-12008error in materialized view refresh path
RMAN-08109channel string: restored block(s) from backup piece string
ORA-03217invalid option for alter of TEMPORARY TABLESPACE
ORA-46058Invalid attribute specified
NNO-00121LDIF file string open failed: error = number
ORA-31527could not find source column string for CDC change table string.string
ORA-31417column list contains control column string
ORA-36884(XSSRF03) The value of the first parameter of the AW single row function is incorrect.
ORA-40104invalid training data for model build
ORA-24784Transaction exists
DRG-12227a zone section named string already exists in this section group
ORA-36963(XSRELTBL16) INHIERARCHY object workspace object should be a valid valueset or boolean variable.
RMAN-06755WARNING: datafile string: incremental-start SCN is too recent; using checkpoint SCN string instead
RMAN-20508temporary resource already in use
NNL-01057Foreign data items cached: number
NNL-01052Server has been running for: string
ORA-13187subdivision failed
SQL-02122Invalid OPEN or PREPARE for this database connection




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-32701Hang detected
ORA-10877error signaled in parallel recovery slave string
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16766Redo Apply is stopped
ORA-16664unable to receive the result from a database
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-16665timeout waiting for the result from a database
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated




Your own TOP 20 Oracle errors
QSM-01061illegal query expression